Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Determining the output format of an expression

I am using a dynamic footnote for one of my KPI boxes. The results of the function I use is a decimal out to 13 places past the decimal. I would like it to be a percentage but not sure how to script that format requirement within the function.

The function I am using is:

'% of Total Requests ' &Count({$<SUPPORTTEAM= 'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME)

RequestVolume KPI.png

4 Replies
ogster1974
Honored Contributor II

Re: Determining the output format of an expression

'% of Total Requests ' & NUM(((Count({$<SUPPORTTEAM= 'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME))*100,'#,##0') & '%'

Should sort it.

sasiparupudi1
Honored Contributor III

Re: Determining the output format of an expression

try

'% of Total Requests ' &num(Count({$<SUPPORTTEAM= 'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME),'# ##0.00%')

Not applicable

Re: Determining the output format of an expression

Thank you gentlemen, between the both of you I have it. Both of your solutions gave me an "error in expression" saying "Error in set modifier expression".

However, I combined both of your solutions to come up with this, and it worked:

'Percentage of Total Requests  '  &Num((Count({$<SUPPORTTEAM={'Member*'}>}EFOLDERNAME)/Count(EFOLDERNAME)*100),'#,##0.0') &' %'

solutionforpercentageofrequestsfunction.png

Thanks again

sasiparupudi1
Honored Contributor III

Re: Determining the output format of an expression

Glad to know that you could solve your issue. May I suggest to please close this thread by marking a correct answer so that it would be beneficial for others?

Thanks

Sasi

Community Browser