Script variable headache

Thu, 20 Oct 2016 07:59:45 GMT

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.

Re: Script variable headache

Tue, 01 Nov 2016 15:45:47 GMT

There were no responses so I assume this caused other people headaches too.

Solved it using the interval function though.

topic Script variable headache in QlikView

Script variable headache

Re: Script variable headache