topic Re: Set analysis don't show data when not selected in QlikView

Set analysis don't show data when not selected

lanlizgu — Fri, 18 Oct 2019 11:14:33 GMT

Hi,

I have a KPI where I'm counting the number of stores such as

=count(distinct {<STORE={'one'}>}ID)

The thing is that If I select a STORE different than one, I don't want the count to take place.

How could I achieve this without an if and just with set analysis?

Thank you.

Best regards.

rubenmarin — Fri, 18 Oct 2019 11:18:05 GMT

Hi, maybe with * operator:

=count(distinct {<STORE*={'one'}>}ID)

lanlizgu — Fri, 18 Oct 2019 11:25:56 GMT

aggregating by the same field solves the issue:

aggr(count(distinct {<STORE={'one'}>}ID, STORE)