what is diff b/w num and num# fun

[gkcchowdary]

hi

tell me about subfield with examples

[robert_mika]

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

[jonathandienst]

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

[nagarjuna_kotha]

Hi Chaithanya,

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

how to use num() function in qlikview?

Regdards,

Nagarjuna