Discussion board where members can get started with Qlik Sense.
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:
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 C I need to see the following rows:
And not the result that the basic filter does with OR selection (below):
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.
Go to Solution.
Create a table with 2 dimensions:
dim2 : =aggr(if(GetSelectedCount(ElementaryAttributes)=0,Attributes,if(len(trim(KeepChar(Attributes,Concat(distinct ElementaryAttributes))))=len(trim(Concat(total distinct ElementaryAttributes))), Attributes)),Goods,Attributes)
Select A and C:
It worked, thank you very much!! 🙂