Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

silambarasan130
Contributor II

how can i change currency format..??

Hi all,

I want to display this '10000000000' into like this '10,00,00,00,000' .

      using num function but instead of using like this '##,##,##,##' .

     is there any other way available to change the format.

9 Replies
MVP
MVP

Re: how can i change currency format..??

May be try this:

Num(FieldName, '##,##,##,##,###.')

Re: how can i change currency format..??

You can modify the number format of your chart measure.

Switch off Auto to enable Custom formatting and you can add the pattern you need.

SenseNumFormat.PNG

yasmeenk
Contributor

Re: how can i change currency format..??

This can be helpful:

=Num(sum(Budget),'###,##,##')

silambarasan130
Contributor II

Re: how can i change currency format..??

thanks for your respose..

if suppose i have 100000000000000000 this value that time also i have to use the same thing.. '##,##,##,##,##,##' like this...?

is thr anyother way to implement this..

Re: how can i change currency format..??

There is a limit of 14 digits for an integer in Qlik

See this post  Re: Large Integer formatting question

silambarasan130
Contributor II

Re: how can i change currency format..??

Hi Yasmeen,

if suppose i have 100000000000000000 this value that time also i have to use the same thing.. '##,##,##,##,##,###' like this...? i want to convert the value in indian currency.

is thr any other way to implement this..

silambarasan130
Contributor II

Re: how can i change currency format..??

Thanks you so much colin_albert

gompa786
Contributor III

Re: how can i change currency format..??

Hi,

NUM function doesn't seem to work in Qlik sense.. The nearest I could reach is screenshot below:

Thanks

ba124847
New Contributor

Re: how can i change currency format..??

I tried to put this format in KPI object and it worked . But when I tried it in line chart or bar chart , the label is not appearing properly. Please see attached screenshot.

stalwar1‌ : Please advise.