Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
mahitham
Contributor

Percentage Help

Hi Experts,

Can any one please help me on below issue. I have 5% in Measure 1 for the month of Jul-2018.

But when I filter Month=Jul-2018 then this 5% turns to 100%.

I have used the below expression. Please help me on this.

Sum(if([ Not Null <3days]='True' or [Null <3days]='True',[Count]))
/
Sum(Total if([ Not Null <3days]='True' or [ Null <3days]='True',[Count]))

 

Per 1.png

per 2.png

Thanks in advance

1 Solution

Accepted Solutions
MVP
MVP

Re: Percentage Help

Override the Month selection in the divisor:

Sum(if([ Not Null <3days]='True' or [Null <3days]='True',[Count]))
/
Sum({<Month>} Total if([ Not Null <3days]='True' or [ Null <3days]='True',[Count]))
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies

Re: Percentage Help

because when you select Jul-2018 then you denominator change
In denominator used set analysis

Sum({1<[ Not Null <3days]={'True'}>+1<[ Null <3days]={'True'}>}Count)
Great dreamer's dreams never fulfilled, they are always transcended.
MVP
MVP

Re: Percentage Help

Override the Month selection in the divisor:

Sum(if([ Not Null <3days]='True' or [Null <3days]='True',[Count]))
/
Sum({<Month>} Total if([ Not Null <3days]='True' or [ Null <3days]='True',[Count]))
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein