topic Re: How to change the number format in QlikView

How to change the number format

abc_18 — Thu, 14 Dec 2017 07:39:19 GMT

Hi,

In my dashboard, I have a expression where data is coming as 590.988, I want to replace the decimal with comma separator like 590,988

Please suggest.

Thanks

Re: How to change the number format

Chanty4u — Thu, 14 Dec 2017 07:43:20 GMT

try this

Replace(Value,',','.');

SET DecimalSep=','; // . instead of .

Re: How to change the number format

Chanty4u — Thu, 14 Dec 2017 07:44:36 GMT

check this

Get comma separated values of a field

Re: How to change the number format

abc_18 — Thu, 14 Dec 2017 09:12:01 GMT

Hi Chanty,

I changed the DecimalSep, but still I am getting value as 590.988.

I tried to use the 'num' function, but not getting proper output.

Re: How to change the number format

Anil_Babu_Samineni — Thu, 14 Dec 2017 09:13:54 GMT

You said, You have expression. What expression you have?

Re: How to change the number format

abc_18 — Thu, 14 Dec 2017 09:58:55 GMT

Expression is:-

if(%CurrencyDesc = 'D&C Currency',sum($(curr_year)sales_sm_fxa)/vPer,sum($(curr_year)[sales_$(vCurrency_Fxx)])/vPer)

and I am trying to change the format using 'num' function

Re: How to change the number format

Anil_Babu_Samineni — Thu, 14 Dec 2017 10:06:34 GMT

May be this?

if(%CurrencyDesc = 'D&C Currency',Num(sum($(curr_year)sales_sm_fxa)/vPer, ''#,##,##0'),Num(sum($(curr_year)[sales_$(vCurrency_Fxx)])/vPer, ''#,##,##0'))

Re: How to change the number format

Anonymous — Thu, 14 Dec 2017 10:19:14 GMT

Shikha , I guess your currency format is in Euro and assuming this is something that was changed in the main tab. Check SET money format.

Re: How to change the number format

neha_shirsath — Thu, 14 Dec 2017 11:35:57 GMT

In your data field its comma? or after calculation its showing like this?

Re: How to change the number format

el_aprendiz111 — Thu, 14 Dec 2017 15:57:51 GMT

Hi,

=NUM(590.988,'#,###',',','.')