Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

trishita
Contributor III

How to show number after 2 decimal places in qliksense with num function

I have to fetch numbers before and after decimal places in qliksense. I used the syntax 

num(Share% ,'####.##', '.', ',') as Share_HPPD_Percent 

but I can not retrieve the value which is less than 0 percent (for example 0.08 or 0.99)num.JPG

1 Solution

Accepted Solutions
pradosh_thakur
Honored Contributor II

Re: How to show number after 2 decimal places in qliksense with num function

num#(Share% ,'###0.00', '.', ',') as Share_HPPD_Percent

Learning never stops.
4 Replies
pradosh_thakur
Honored Contributor II

Re: How to show number after 2 decimal places in qliksense with num function

num(Share% ,'###0.00', '.', ',') as Share_HPPD_Percent

Learning never stops.
trishita
Contributor III

Re: How to show number after 2 decimal places in qliksense with num function

not working as it is not showing the values which are after decimal places. 0.99 and 0.08 are disappearing
pradosh_thakur
Honored Contributor II

Re: How to show number after 2 decimal places in qliksense with num function

num#(Share% ,'###0.00', '.', ',') as Share_HPPD_Percent

Learning never stops.
Highlighted
trishita
Contributor III

Re: How to show number after 2 decimal places in qliksense with num function

Thanks !!