Qlik Sense Filter Issue

[rajany089]

Hi Team, 

I have a bar chart where i have to include just Day 1,3,7,14 and exclude >Day14 and FutureDate. below is my calculation. even after explicitly filtering out >Day14 and FutureDate. i still get >Day14 in my bar graph. 

when i manually select the Day 1,3,7,14 there is change in the data. Any help on this ?

Num(RangeSum(Above(COUNT(DISTINCT {<[Ready at Nth Day] ={'Day1', 'Day3', 'Day7', 'Day14'}>} item_number), 0, RowNo())) / COUNT(TOTAL <Effective_Month_Year>distinct item_number), '#,##0%')

[TauseefKhan]

Hi @rajany089,

Check this one:

Num(
RangeSum(
Above(
COUNT(
DISTINCT {<[Ready at Nth Day] = {'Day1', 'Day3', 'Day7', 'Day14'}, [Ready at Nth Day] -= {">Day14", "FutureDate"}>}
item_number
),
0, RowNo()
)
) / COUNT(TOTAL <Effective_Month_Year> DISTINCT item_number),
'#,##0%'
)

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***

[rajany089]

Hi @TauseefKhan  Thank you for your help but it did not work.