Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone.
I have one filter pane with qualities for a set of people for year 2017.
I want to select in the filter pane two of those qualities simultaneously (intersection) for these people this year. What I'm getting is the union. How do I do this ?
Thank you in advance.
Ioanna
Perhaps this?
Exp(Sum({<Person = P(Person)>} Log(Sales)))
Let's say in these qualities I have the traits:
happy
excited
sad
I want to select people in the filter pane who are both happy and excited. If i click on happy and excited I get all the people who are either happy or excited.
This is what I'm looking for, maybe I was not clear.
Any ideas?
Thank you for the input Anil.
maybe something as below for a calculated dimension in a filter?
aggr( if( qualities = happy and qualities = excited, 'happy&excited' ), person )
Hello and thank you.
Thought about that, but the thing is I have then 125 combinations to present like that. So I hoped there's another, quicker way for me to do this.
Perhaps this?
Sum({<Person = {"$(=Chr(39) & Concat(Distinct Person, ',') & Chr(39))"}>} Sales)
Or
Sum({<Person={"$(=SubField(Chr(39) & Concat(Distinct Person, ',') & Chr(39),',',1))"}>+<Person={"$(=SubField(Chr(39) & Concat(Distinct Person, ',') & Chr(39),',',2))"}>+<Person={"$(=SubField(Chr(39) & Concat(Distinct Person, ',') & Chr(39),',',3))"}>} Sales)
Or, I would recommend give self Adhoc to customers (It will allow based on selection)
Let's begin with the fact: There is no way to do this in a single action using the qlik engine filter functionality as it is.
So you have to consider alternatives. Each have pros and cons, select depending on what you want.
Hello @gmenoutis ,
i'm coming back to this thread. Quoting your answer
What If i wanted to select those IDs with simultaneously three values in this filter? How could this work?
Ahh, the famous "Re-select Possible" problem. I remember I had found it in some third party extension, but I found another way to do it. So:
1) Filter "Happy"
2) Go to the persons key, let's say "Person ID", and "Select Possible". Clear "Happy". Now you have all happy persons' ids selected.
3) Select "Excited". In order to "lock" this selection, go to "Person ID" and do "Select alternative" *twice*. This will have an effect of "re-selecting possible". Clear "Excited". Now you have all happy and excited persons' ids selected.
4) Repeat step 3 with "Sad" or actually any other selection. You can keep doing this indefinitely. In the end, you will have a set of persons which satisfy all of your conditions.
haha @gmenoutis , really, the infamous intersection problem... Just like you said it!
I will try it and let you know how it went. Really complex for someone who is just a plain ui user , but, what to do 😕