topic Re: Current_date column is not displaying as required. in QlikView

Current_date column is not displaying as required.

Thu, 08 Jan 2015 10:19:04 GMT

Hi All,

I am working on Incremental load report i have created one variable that contains(created_date,-1) by using peek() function and i dragged that column into report screen by using text object.current_date column is displaying as required.

I have attached my script.

Please let us know how to proceed.

Re: Current_date column is not displaying as required.

tresB — Thu, 08 Jan 2015 10:24:29 GMT

Remove $ sign and try like: =date(vCreatedDate,'M/D/YYYY')

Re: Current_date column is not displaying as required.

Thu, 08 Jan 2015 10:30:10 GMT

yes it works, tresesco

but still i am not aware of the logic behind this remove dollar sign from variable that is being used in TEXT OBJECT

Generally what we do , we always access the variable having syntax like $(var_name)

can u explain lil bit.

Re: Current_date column is not displaying as required.

tresB — Thu, 08 Jan 2015 10:53:04 GMT

Sure.

If you just take the variable without $, you will see it coming like - 1/8/2015 . This variable is already evaluated in the script and got a value assigned. Now if you try to expand this using $ , it will evaluate the value it self, i.e - 1/8/2015.

That means it will first evaluate 1/8=0.125 and then 0.125/2015=0.0000620..

And then effectively Date(0)->12/30/1899 the starting date.

Basically a numerical evaluation of 1/8/2015 where '/' is division symbol. Hope this helps.

Re: Current_date column is not displaying as required.

Thu, 08 Jan 2015 11:07:03 GMT

thanks tresesco.............

Re: Current_date column is not displaying as required.

Thu, 08 Jan 2015 11:08:51 GMT

Thanks tresesco.....