topic Re: Num Format Issue in QlikView

Num Format Issue

senpradip007 — Fri, 16 May 2014 07:29:18 GMT

Hello Experts.

I have got stuck in a problem that may be easy to you. According to clients requirement, users decide the number format of the Num() function, i.e. if user inputs 2 the number format should be Num(10.12458, '#,###.##'). if user inputs 3 the number format should be Num(10.12458, '#,###.###').

Main challenge is to generate the Format Pattern.

Can any one help me? Thannks in advance.

Re: Num Format Issue

nizamsha — Fri, 16 May 2014 07:34:00 GMT

=if(vInput=1, Num(10.12458, '#,##0'),

if(vInput=2, Num(10.12458, '#,##0.0'),

if(vInput=3, Num(10.12458, '#,##0.00'))))

Re: Num Format Issue

Joaquin_Lazaro — Fri, 16 May 2014 07:35:20 GMT

Hi Pradip:

You need some variables

=Num(Sum(Quantity), $(NumberFormat_var), DecimalSep_var, ThousandSep_var)

and populate them with a expression based on the user input.

But ... not in all expressions and in all functions of the front end it works

Re: Num Format Issue

anbu1984 — Fri, 16 May 2014 07:39:32 GMT

=Num(10.12458, '#,###.' & Repeat('#',vInput) )