topic Re: How to ignore this filter in set analysis ? in App Development

How to ignore this filter in set analysis ?

Derek_T — Fri, 15 Jul 2022 14:09:30 GMT

I know the question have been asked in many times, but none of the solutions I've found give me the expected result.

I have 2 tables, and the only filter in my analysis is a date range: 2021-01-01 to 2022-01-01

I haven't shown all the date because their value are irrelevant, only the boundary matters.

What I'm trying to build is the table below, the trick is "MAX_DATE" and "AVG_AC_COUNT" should be unaffected by the ATA, only the "SUM_AMOUNT" should be impacted.

I've tried many combinations of set modifiers, but I always end up with the "MAX_DATE" and "AVG_AC_COUNT" being affected by the ATA where they should only be affected by the date range selected by the user.

Thanks !

Re: How to ignore this filter in set analysis ?

edwin — Fri, 15 Jul 2022 14:47:04 GMT

in your expressions for AVG_AC_COUNT and MAX_DATE, add the set analysis modifier ATA=

this means for this expression ignore ATA filter

since you want SUM_AMOUNT to consider ATA filter, then dont add this into that expression

Re: How to ignore this filter in set analysis ?

Derek_T — Fri, 15 Jul 2022 14:52:58 GMT

Thanks Edwin,

could you elaborate the code a bit more please, I've tried passing ATA but I don't know how to exactly, I've tried:
{1<ATA={*}>} but it does not work.

Re: How to ignore this filter in set analysis ?

edwin — Fri, 15 Jul 2022 15:03:29 GMT

to ignore ATA the set analysis should be

{1<ATA=>}

Re: How to ignore this filter in set analysis ?

edwin — Fri, 15 Jul 2022 15:04:35 GMT

you may want to try

{<ATA=>}

if you add 1, it means ignore ALL filters but you may want to ignore only specific filters

Re: How to ignore this filter in set analysis ?

Derek_T — Fri, 15 Jul 2022 17:20:56 GMT

Thanks Edwin, I've tried both and it does not work.
Here's the formula for the cumulative amount: Avg({1<ATA=>}AC_COUNT) / Avg({<ATA=>}AC_COUNT)

But I still get completely different number by ATA, which does not make sense since each AC (Aircraft) is composed of the same set of ATAs, so the count of AC / ATA should remains the same.

Re: How to ignore this filter in set analysis ?

Derek_T — Fri, 15 Jul 2022 17:40:24 GMT

The solution was to ignore the dimensions ATA:

Avg(TOTAL AC_COUNT)

Re: How to ignore this filter in set analysis ?

edwin — Fri, 15 Jul 2022 21:53:36 GMT

you may want to test that. without set analysis, there is no ignored filters

Re: How to ignore this filter in set analysis ?

Derek_T — Mon, 18 Jul 2022 12:15:09 GMT

You're right, being new to Qlik my choice of words was incorrect, it's not a "filter" I was trying to ignore but a "dimensions" in a table. Thank you !

Re: How to ignore this filter in set analysis ?

edwin — Mon, 18 Jul 2022 15:04:38 GMT

not intending to belabor this but filter and dimensions are interchangeable. a dimension when selected IS a filter. what i am saying is that without set analysis, you are not ignoring filters nor dimensions. however, if this works for you then maybe you never had an issue in the first place.