Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jordanhertl
New Contributor III

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
Khan_Mohammed
Honored Contributor II

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

Guess

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

4 Replies
Khan_Mohammed
Honored Contributor II

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

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
New Contributor III

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

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.

Khan_Mohammed
Honored Contributor II

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

Guess

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

jordanhertl
New Contributor III

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

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

Community Browser