Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Percentage format help

Hi Experts,

Can any one please help me on below requirement.

I have a Measure like below

=Count(ID)/Count(Distinct ID)

Getting value as 0.44123. The Number Format is Auto.

Without changing Number Format to Percentage how to show the value as 44% in the above measure.

Please help me on this.

Thanks in advance.

2 Replies
agigliotti
Partner - Champion
Partner - Champion

you can apply the num function as below:

num( Count(ID)/Count(Distinct ID), '#,##0%' )

priyalvp24
Creator
Creator

Hi,

If you want '%' Symbol at the end then try this

num( Count(ID)/Count(Distinct ID), '#,##0%' )%' '


Note:There is Space BetweenSingle quotes ' '


Thanks...