Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have the following issue in Qlik Sense.
I need to replicate (or find a way to emulate) the AND operator that was present in Qlik View List Box.
I have the following “KEYWORD” table which has de “id” and “keyword” fields:
Here are some attached images to better understanding.
In Qlik View, this was de filter panel:
When I select one or more “keywords” the IDs get filtered in the following way:
I’m trying to do the same thing in Qlik Sense; I’m creating a filter panel that works the same way, selecting one or more “keywords” filtering by “id”.
But I can’t find the Set analysis that fulfills that function.
It's been a while since a looked into the AND workaround in Qlik Sense. But I suggest you to take a look at @JonnyPoole 's old post on the topic:
Generating AND, OR , NOT selection logic in Qlik Sense
@BernardoTali what if you create a new field concatenating both fields? and then use the new field as filter
id & ' | ' & keyword as And_Dimension
or is not that your problem?