Qlik Sense Set Analysis

[pjpkumar26]

Hi All,

I am using the below expression for a chart and the cahrt is working as expected

aggr(Count({<BFlag"={'Y'},"Type"={"Post"}>}[ID]),[Week])  
/
Count(distinct[ADate])
/
(sum(aggr((gur),[Week], [ID]))

now I got a filter in my application Week and I don't want my chart to change when I select week in the Week filter.

I tried some of the set option but no joy.

any suggestion please 

Regards,

Sudheer

[BrunPierre]

This perhaps.

Count({<Week=>}aggr(Count({<BFlag"={'Y'},"Type"={"Post"}>}[ID]),[Week]))
/
Count({<Week=>} distinct [ADate])
/
(sum({<Week=>}aggr((gur),[Week], [ID]))

[pjpkumar26]

Thanks for the quick reply 

I tried the above syntax but still the graph is changing when I select Week Filter and figures shows as 0

Regards,

Sudheer

[BrunPierre]

((Count({<Week=>} Aggr(Count({<BFlag={'Y'},Type={'Post'},Week=>} ID), Week))
/
Count({<Week=>}DISTINCT ADate))
/
Sum({<Week=>} Aggr(Only({<Week=>} gur), Week, ID)))

[pjpkumar26]

Thanks for your reply,

but still no change 

[pjpkumar26]

Hi Pierre,

one thing I tried - by keep 1 the graph is not changing that's good but the values are showing as 0's

it's not counting teh records.

((Count({1<Week=>}Aggr(Count({<BFlag={'Y'},Type={'Post'},Week=>} ID), Week))
/
Count({1<Week=>}DISTINCT ADate))
/
Sum({1<Week=>}Aggr(Only({<Week=>} gur), Week, ID)))

Thanks,

Sudheer