topic set analysis in QlikView

set analysis

vidhyancs — Sat, 16 Nov 2024 05:03:29 GMT

hi all,

need a small favor as i know that the below expression is to ignore the selections from Year, Quarter and Month and accept all other filters.

sum({$<Year=, Quarter, Month>} SalesAmount)

but what i need is i just need to accept the selections from Year,Quarter and Month and ignore all other filters.

Thanks in advance.

Lech_Miszkiewicz — Wed, 05 Dec 2018 04:05:57 GMT

Maybe:
Sum({1<Year=P(Year),Quarter=P(Quarter),Month=P(Month)> SalesAmount)

Lech_Miszkiewicz — Wed, 05 Dec 2018 04:07:28 GMT

The onother thing is to consider if other selections can Include/Eclude data from your Year,Quarter and month fields