Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jordanhertl
Creator
Creator

Help with showing 'Percentage of numbers in a range'?

Hello all.

My chart is successfully showing the percentage of numbers above 4 like this...

Num(Count({<Score = {">=4"}>} Score) /Count(Score),'0%')

How would I go about altering this to show percentages in a range? For instance between 3.0 and 3.99?

Thank you for your help,

Jordan

1 Solution

Accepted Solutions
MK9885
Master II
Master II

Guess

Num(Count({<Score= {">=3<=3.9"}>} Score) /Count(Score),'0.0%')

View solution in original post

4 Replies
MK9885
Master II
Master II

Num(Count({<Score = {">=4"}>} Score) /Count(Score),'0.0%')

Your expression would only show values which are greater or equal to 4.

If you want 3 as well then use

Num(Count({<Score = {">=3"}>} Score) /Count(Score),'0.0%')

or if you want all %'s

Num(Count({<Score = {">=0"}>} Score) /Count(Score),'0.0%')




jordanhertl
Creator
Creator
Author

Hi, thanks for the response.

Yes I know that the expression only shows value which are greater than or equal to 4.

I was wondering how I would write this expression to show a range of values. Specifically between 3.0 and 3.9.

MK9885
Master II
Master II

Guess

Num(Count({<Score= {">=3<=3.9"}>} Score) /Count(Score),'0.0%')

View solution in original post

jordanhertl
Creator
Creator
Author

That appears to have worked. Thanks for the help my friend.