Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator 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
Master II
Master II

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

Learning never stops.

View solution in original post

4 Replies
pradosh_thakur
Master II
Master II

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

Learning never stops.
trishita
Creator III
Creator III
Author

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

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

Learning never stops.
trishita
Creator III
Creator III
Author

Thanks !!