how can i change currency format..??

[Silambarasan1306]

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.

[sunny_talwar]

May be try this:

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

[Colin-Albert]

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.

[yasmeenk]

This can be helpful:

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

[Silambarasan1306]

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..

[Colin-Albert]

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

See this post  Re: Large Integer formatting question

[Silambarasan1306]

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..

[Silambarasan1306]

Thanks you so much colin_albert

[Anonymous]

Hi,

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

Thanks

[ba124847]

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.