Thank you. I'm using date time field from database for the incremental test. I got the max date time from the qvd and converted to timestamp, then tried the peek variable, and where clause in my sql query hit qlik keeps telling me error in converting date to text. I have the single quotes around the variable expansion. If I don't put it says maxdate field not found :/
First - declare the variable using LET statement and then expand or evaluate it using $ symbol, no single quotes required. Second - As I did in video first make sure required date or timestamp in correct format similar to database is captured in variable. Then proceed with adding variable in where clause. If you still have issues send me an email with more data and error snapshot.
Good explanation
Thank you
we need all ways of incremental hope you will post next yt
Sure
th-cam.com/video/LRyBaTtbR98/w-d-xo.html
Please create one complete dashboard .. waiting 🎉
You can refer to this playlist.
th-cam.com/play/PLxmjvkMH6h7dFFb4-ayd4CEEySRgcVk9H.html
Thank you. I'm using date time field from database for the incremental test. I got the max date time from the qvd and converted to timestamp, then tried the peek variable, and where clause in my sql query hit qlik keeps telling me error in converting date to text. I have the single quotes around the variable expansion. If I don't put it says maxdate field not found :/
First - declare the variable using LET statement and then expand or evaluate it using $ symbol, no single quotes required.
Second - As I did in video first make sure required date or timestamp in correct format similar to database is captured in variable. Then proceed with adding variable in where clause.
If you still have issues send me an email with more data and error snapshot.