Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using the script below I'm testing an incremental load to only load new records. Using the debugger I can see that the variable correctly stores the datetime 10/12/2015 00:00:01 as the number 42348.000011574. However when I instruct the load to only bring in records greater than this datetime it also brings in records with the same date (10/12/2015 00:00:01).
To test it further I stored three test fields. Test1 is the datetime from the records I want to load, test2 is the variable and test3 is the variable minus the record date. When I look at them in the front end (see below) I can see that both the variable and the record date are the same, yet Qlikview shows a difference between them. I'm sure it's something to do with the dollar expansion because if I take that off the second expression the difference shows as zero (the result I want) but I can't think of a way to achieve the same thing in the script. Basically, Qlikview is storing the variable result correctly but when I try to use it in the script it must be applying a different figure.
There were no responses so I assume this caused other people headaches too.
Solved it using the interval function though.
There were no responses so I assume this caused other people headaches too.
Solved it using the interval function though.