Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one explain these functions in detail with simple example.
Date
Date#
Num
Num#
First Sorted Value
Thanks in advance
Madhu
such as Num(Month(Today()))
Output is 8
Num#('DD-MM-YYYY','YYYYMMDD')
Output is 20150819
Hope u understand
Open Qlikview Desktop and press the F1 key. You can the find the answers to your questions in the help file you just opened.
Date and Num are used to change the display format of a date or number. Date# and Num# are used to convert a character string into a date or number. You can find your examples in the help file.
And if you find qv help to be not enough, check: Re: Num vs num #
Hi,
Please check this.
Thank u got it
Thank u got it
Please close the topic by selecting Correct and Helpful answers.
such as Num(Month(Today()))
Output is 8
Num#('DD-MM-YYYY','YYYYMMDD')
Output is 20150819
Hope u understand