Discussion board where members can get started with QlikView.
I am using below code:
now I want get the serial number of this date i.e if I get 06/17/2017, how can I get the date serial number for this date?
View solution in original post
Serial number means, What was the output you are expecting from this date
In his expression, Henrik shows you the QlikView date serial # which means that 1 = Dec 31, 1899. Today is day # 42908.
If you want a different serial number for todays date, please specify the starting date for your counter.
Just write num() you will get in numeric as a date..
Hope this will helps u..!!
If you want to get serial number along with the date field , you can try using Dual function.