topic Re: Num vs num # in QlikView

Num vs num #

deepakqlikview_123 — Fri, 30 May 2014 07:20:41 GMT

Hi all,

Can you please tell me difference between num and num#.

Thanks

Re: Num vs num #

Anonymous — Fri, 30 May 2014 07:27:06 GMT

Pls check

Number format: what is the difference between the num and num# functions?

Re: Num vs num #

tresB — Fri, 30 May 2014 07:28:12 GMT

Num() - changes format only (without making any change in the original backend data)

Num#() - parses/reads the data according to mentioned format.

See the examples from help.

Re: Num vs num #

its_anandrjs — Fri, 30 May 2014 07:31:17 GMT

The definition from the help

Num Definition

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# Definition

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.

Re: Num vs num #

deepakqlikview_123 — Fri, 30 May 2014 07:58:44 GMT

Can u plz give me some example for use of both.

Thanks

Re: Num vs num #

its_anandrjs — Fri, 30 May 2014 08:24:03 GMT

Very simple example Suppose you have a string abc123 and you want to convert it into number then you have to use NUM#

Eg:-

=Num#('abc123', '#,##0.##', '.' , ',' ) //this gives you abc123 but if sam you use with Num it will not convert this into number

In the same if you want to get only numbers to be extract from same then first you have to use Num# then Num

=NUM( Num#('abc123,4', 'abc#,#') ,'####') // this will gives only 1234

Same for Num but here i am format my given number like i have numbers 123 and i want to format it as 123.00 then is use Num because it is already in number but i want to format it

Eg:-

=Num('123', '#,##0.##') //This will gives 123.00 and so many formats you can use

Re: Num vs num #

tresB — Fri, 30 May 2014 08:24:25 GMT

Say, you have a resultant number 5555.1234567 and your user wants to see only till two decimals. Here num() helps you - Num(5555.1234567, '##0.##') -> 5555.12 and the backgound number remains as it is.

You get a sting which is aaa12234, and your user asks to get the number part only. You can use num#() -

=Num(Num#(aaa12234, 'aaa#####')) -> 12234

Re: Num vs num #

deepakqlikview_123 — Fri, 30 May 2014 08:29:54 GMT

Thanks Tresco and Anand, that is very helpful for me .

Re: Num vs num #

Fri, 30 May 2014 08:36:21 GMT

Hi,

In simple words,

Num# can be considered as 'Taking In'

Num can be considered as 'Giving out'

Eg. '10.222222'

Num#('10.222222','##.######') => 10.222222

Num('10.222222','##.##') => 10.22

Regards,

Priyanka

Re: Num vs num #

deepakqlikview_123 — Fri, 30 May 2014 08:42:28 GMT

Thanks Priyanka