Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

_fl
New Contributor

PROBLEM: AND-MODE selection for Qlik Sense

Hi All,

Below an exercise I am trying to solve but I can't find a solution.

Starting with a database with products that may have different configurations:

GoodsAttributes
Product 1A,B,C
Product 1D,E
Product 1A,C,T
Product 2E,D,G
Product 2A,H,C
Product 3B,C,E
Product 3A,D,E
Product 3B,D,F,R
Product 3A,B,C,D

 

1) In the data model, I uploaded the table above and inserted a column "Elementary Attributes"obtained through a Subfield of the column Attributes

2) On a dashboard, I created a table with both the columns above and a filter on the Elementary Attributes(A;B;C;D;E;F;G..).

What I need to do is to filter all the rows that have in the column Attributes all the elements that I have filtered.

For example, if I select in the filter the elements A and I need to see the following rows:

GoodsAttributes
Product 1  A,B,C
Product 1A,C,T
Product 2A,H,C
Product 3A,B,C,D

 

And not the result that the basic filter does with OR selection (below):

GoodsAttributes
Product 1A,B,C
Product 1A,C,T
Product 2A,H,C
Product 3B,C,E
Product 3A,D,E
Product 3A,B,C,D

 

I tried a few work-around on it but could not find a solution.

Looking forward to hearing Your opinion, I thank you in advance for your help.

1 Solution

Accepted Solutions
Partner
Partner

Re: PROBLEM: AND-MODE selection for Qlik Sense

Create a table with 2 dimensions:

dim1: Good

dim2 : =aggr(if(GetSelectedCount(ElementaryAttributes)=0,Attributes,
if(len(trim(KeepChar(Attributes,Concat(distinct ElementaryAttributes))))=len(trim(Concat(total distinct ElementaryAttributes))), Attributes)
),Goods,Attributes)

 

Result:

No selection:

 

Capture.PNG

Select A and C:

Capture.PNG

 

 

2 Replies
Partner
Partner

Re: PROBLEM: AND-MODE selection for Qlik Sense

Create a table with 2 dimensions:

dim1: Good

dim2 : =aggr(if(GetSelectedCount(ElementaryAttributes)=0,Attributes,
if(len(trim(KeepChar(Attributes,Concat(distinct ElementaryAttributes))))=len(trim(Concat(total distinct ElementaryAttributes))), Attributes)
),Goods,Attributes)

 

Result:

No selection:

 

Capture.PNG

Select A and C:

Capture.PNG

 

 

_fl
New Contributor

Re: PROBLEM: AND-MODE selection for Qlik Sense

It worked, thank you very much!! 🙂