Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
tell me about subfield with examples
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
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
Hi Chaithanya,
Please go through the below link it might be helpful to you.
how to use num() function in qlikview?
Regdards,
Nagarjuna