Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jordanhertl
New Contributor III

Help with properly displaying percentage?

I have a formula that appears to be shooting out the right number just in a format I can't use. I am wanting to see the percentages of test scores above or equal to 4 and in the first quarter of 2018.

count({<test_score = {">=4"}, Quarter={"Q1 2018"} >} test_score)

Resulting in 186100%

How would I go about converting this to just a 2 digit percentage?

3 Replies

Re: Help with properly displaying percentage?

Where are you using this?

you can use

Num(

count({<test_score = {">=4"}, Quarter={"Q1 2018"} >} test_score)

,'#,##0')

jordanhertl
New Contributor III

Re: Help with properly displaying percentage?

I am using it in an extension called "Simple KPI"

yujiyamane
Contributor II

Re: Help with properly displaying percentage?

If the percent is against test scores in the same period. It should be like below.

Num(count({<test_score = {">=4"}, Quarter={"Q1 2018"} >} test_score) /count({<Quarter={"Q1 2018"} >} test_score) ,'#,##0.00%')

If the percent is against the total count. It should be like below.

Num(count({<test_score = {">=4"}, Quarter={"Q1 2018"} >} test_score) /count( test_score) ,'#,##0.00%')

Hopefully this helps you.

Let me know if i can be of any more help.

Community Browser