topic Re: what is diff b/w num and num# fun in QlikView

what is diff b/w num and num# fun

gkcchowdary — Tue, 11 Aug 2015 09:04:40 GMT

tell me about subfield with examples

Re: what is diff b/w num and num# fun

robert_mika — Tue, 11 Aug 2015 09:10:58 GMT

num(expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )

The num function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the number format settings that have been specified with the Number Interpretation Variables are used in first hand, in second hand the operating system number format settings are used if number interpretation variables have not been set.

num#(expression [ , format-code[ , decimal-sep [ , thousands-sep] ] ])

The num# function evaluates the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters. If the parameters 2-4 are omitted, the default number format set by script variables or in the operating system is used.

Basically num is to format a Date already in numerical format whereas num# is to transform from string to number.

Usually if you Date is is string format you will use

Date(Date#(Your Field,Format),Format)

where format is to example

'DD/MM/YYYY'

Look at Qlikview help for examples

Re: what is diff b/w num and num# fun

jonathandienst — Tue, 11 Aug 2015 09:16:44 GMT

Num() formats a number. It has no effect on the value.

Num(1.876, '0.0') --> 1.9

Num(0.89, '0%') --> 89%

Num#() interprets a string as a number, but keeps it formatted the same

Num#('89%', '0%') --> 89% (as a number)

Num#('1,800', '#,##0', '.', ',') --> 1,800 (as a number)

Num(Num#()) interprets the number and reformats

Num(Num#('89%', '0%')) --> 0.89

Num(Num#('1,800', '#,##0', '.', ',') --> 1800

Re: what is diff b/w num and num# fun

nagarjuna_kotha — Tue, 11 Aug 2015 09:17:52 GMT

Hi Chaithanya,

Please go through the below link it might be helpful to you.

how to use num() function in qlikview?

Regdards,

Nagarjuna