Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
mahitham
Contributor

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
Partner
Partner

Re: Percentage format help

you can apply the num function as below:

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

priyalvp24
Contributor

Re: Percentage format help

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...