# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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

1 Solution

Accepted Solutions
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

## 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