topic Re: set analysis - 2 different conditions in QlikView

set analysis - 2 different conditions

divya_anand — Fri, 07 Sep 2018 05:35:33 GMT

Hi,

I am trying to get the count of complaints

condition 1: if the supplier family of the complaint is 'ABC', then there are no extra criteria, it should just consider that complaint

condition 2: if the supplier family of the complaint is not 'ABC', then it should check another condition Portal_Status-={0}.

Below is the expression I am using in the chart:

Count({<Supplier_Family={'ABC'} >
+
<Supplier_Family-={'ABC'}, Portal_Status-={0}, Company_Name-={'Test Supplier','Test Supplier','Test Company'} >}DISTINCT Complaint_Number)

Now the issue with this expression is this-

1. Without any selections, it is correct.

2. When I select a Supplier_Family, for eg. KGR, what I need to see is 0 (according to my 2 conditions mentioned above), but it shows the values for "ABC".

I understand it is showing correctly based on the expression, but could someone help me in modifying the expression to show the results I want?

Thank you.

Re: set analysis - 2 different conditions

swuehl — Fri, 07 Sep 2018 06:25:54 GMT

You probably need the intersection operator * in your first field modifier:

Count({<Supplier_Family *= 'ABC'} >

<Supplier_Family-={'ABC'}, Portal_Status-={0}, Company_Name-={'Test Supplier','Test company','Test Company'} >}DISTINCT Complaint_Number)

Re: set analysis - 2 different conditions

divya_anand — Fri, 07 Sep 2018 06:40:45 GMT

Hi Stefan,

Thank you for the response, while I check the data with the new expression, could you please tell me what does the intersection operator do here?

Re: set analysis - 2 different conditions

swuehl — Fri, 07 Sep 2018 06:45:30 GMT

Have a look at

Implicit Set Operators

Re: set analysis - 2 different conditions

divya_anand — Fri, 07 Sep 2018 07:03:41 GMT

It works! thank you very much.