Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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
Highlighted
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

View solution in original post

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.
Highlighted
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

View solution in original post