Discussion board where members can get started with Qlik Sense.
Can any one please help me on below requirement.
I have a Measure like below
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.
you can apply the num function as below:
num( Count(ID)/Count(Distinct ID), '#,##0%' )
If you want '%' Symbol at the end then try this
num( Count(ID)/Count(Distinct ID), '#,##0%' )%' '
Note:There is Space BetweenSingle quotes ' '