Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
if we add num function with current date then it will display some random amount..
Is there anyone to help me regarding the logic implemented in QlikView to calculate the amount.
=num(today())
Thank You In advance.
if you use this function today i.e 03-08-2013, you will get an integer say x. then for the same function combination tomorrow (04-08-2013) you will get x+1 and for day after tomorrow x+2 and so on.
Thats the question...
from where it takes values x ...
How it will calculate value of x
QV Stores dates as serial numbers similar to the case of Excel.
I hope the below link helps you understand better :
This is 1900 Date system:
DATE(108,1,2)
returns January 2, 2008 (1900+108).DATE(2008,1,2)
returns January 2, 2008.Hope this helps