topic Re: What is num & Num#, Date & date# in QlikView

What is num & Num#, Date & date#

madhubabu — Thu, 20 Aug 2015 05:29:36 GMT

Can any one explain these functions in detail with simple example.

Date

Date#

Num

Num#

First Sorted Value

Thanks in advance

Madhu

Re: What is num & Num#, Date & date#

Gysbert_Wassenaar — Thu, 20 Aug 2015 05:37:03 GMT

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.

Re: What is num & Num#, Date & date#

tresB — Thu, 20 Aug 2015 05:44:03 GMT

And if you find qv help to be not enough, check: Re: Num vs num #

Re: What is num & Num#, Date & date#

qlikviewwizard — Thu, 20 Aug 2015 06:07:54 GMT

Hi,

Please check this.

Re: What is num & Num#, Date & date#

madhubabu — Thu, 20 Aug 2015 06:13:58 GMT

Thank u got it

Re: What is num & Num#, Date & date#

madhubabu — Thu, 20 Aug 2015 06:14:07 GMT

Thank u got it

Re: What is num & Num#, Date & date#

qlikviewwizard — Thu, 20 Aug 2015 07:11:33 GMT

Please close the topic by selecting Correct and Helpful answers.

Re: What is num & Num#, Date & date#

Thu, 20 Aug 2015 08:24:15 GMT

Date , Num change the display format of a date or number.

such as Num(Month(Today()))

Output is 8

Date# and Num# are used to convert a character string into a date or number.

Num#('DD-MM-YYYY','YYYYMMDD')

Output is 20150819

Hope u understand