Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
May be try this:
Num(FieldName, '##,##,##,##,###.')
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.
This can be helpful:
=Num(sum(Budget),'###,##,##')
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..
There is a limit of 14 digits for an integer in Qlik
See this post Re: Large Integer formatting question
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..
Thanks you so much colin_albert
Hi,
NUM function doesn't seem to work in Qlik sense.. The nearest I could reach is screenshot below:
Thanks
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.