Set Expression Not filtering

[Noor51]

Hi Everyone,

I created a set expression to get a distinct count of member keys for Q2 2024, but it’s not working as expected. I’m using Qlik Sense on-premise, May 2023 version.

This is the set expression I wrote " Count(distinct({<QuarterYear={'Q2-2024'}>} Member_Key)) ".

Any help would be appreciated. 

[MatheusC · Accepted solution]

Adjust your expression by removing the parentheses from distinct () , there is no need, that should be enough:

Count(distinct {<QuarterYear={'Q2-2024'}>} Member_Key ) 

- Regards, Matheus

[Kushal_Chawda · Accepted solution]

@Noor51  Just to avoid any errors always try New set analysis syntax

{<QuarterYear={'Q2-2024'}>}count( distinct Member_Key)

[seanbruton]

Superb, I like this solution!!!

[Noor51]

Thanks I didn't know that I could do that.