topic Re: Set Expression Not filtering in App Development

Set Expression Not filtering

Noor51 — Mon, 28 Oct 2024 14:34:51 GMT

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.

Re: Set Expression Not filtering

MatheusC — Mon, 28 Oct 2024 14:46:15 GMT

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

Re: Set Expression Not filtering

Kushal_Chawda — Mon, 28 Oct 2024 15:18:03 GMT

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

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

Re: Set Expression Not filtering

seanbruton — Mon, 28 Oct 2024 15:38:51 GMT

Superb, I like this solution!!!

Re: Set Expression Not filtering

Noor51 — Mon, 28 Oct 2024 15:41:20 GMT

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