topic Possible to have both filter and ignored selection in a set analysis? in App Development

Possible to have both filter and ignored selection in a set analysis?

KennyTan — Sun, 05 Sep 2021 11:49:52 GMT

Hi Qlik Community,

Would like to get some insight on how to , is it possible to have both respect filter criteria and ignored criteria in a set analysis? if yes can please share with me how?

For eg, I have below set analysis to return SUM of sales for year 2020:

SUM({$<year={'2020'}>}sales)

let said if i have a filter panel with a "product" dimension, and i would like to ignored product selection within filter panel with certain value, for eg, something as below:

{1<[product]={'prod1', 'prod2'}>}

Is it possible to combine this 2 criteria in a set analysis? If yes can please show me how? Thanks in advance.

Basically i would like to ignored certain value in a dimension when user perform filter selection, but not to totally ignored all other available value, so something like [product]= is not viable in this case

Regards,

Kenny.

Re: Possible to have both filter and ignored selection in a set analysis?

PrashantSangle — Sun, 05 Sep 2021 20:05:13 GMT

Yes it is possible with e()

see below link for reference

https://community.qlik.com/t5/QlikView-App-Dev/P-E-and-where-do-you-use-them/td-p/457847

Regards,

Prashant

Re: Possible to have both filter and ignored selection in a set analysis?

KennyTan — Mon, 06 Sep 2021 02:50:45 GMT

Hi @PrashantSangle ,

Thanks for the replied and link provided. Try to understand the usage for E() in set analysis without any success. Can please help me understand?

I have a sample data as below (attached qvf if it can provide more clarity).

Based on the explanation from the linked provided, i can interprets below as (Please correct me if my understanding was wrong):

Get the SUM of sales for for product on year 2019 where product color not to include red.

sum({$<product=E({1<color={'red'}>}), year={'2019'}>}sales)

I expect above set analysis will returned me something as below?

But the calculation i get is 0 with above set analysis. Not sure how this Exclude mechanism is work.

Hope you can shed some light on this please?

Thanks and Regards,

Kenny.