Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
BernardoTali
Partner - Contributor
Partner - Contributor

Qlik sense - And mode

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:

BernardoTali_0-1725989549655.png

 

Here are some attached images to better understanding.

In Qlik View, this was de filter panel:

BernardoTali_1-1725989566001.png

 

When I select one or more “keywords” the IDs get filtered in the following way:

BernardoTali_2-1725989584485.png

 

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.

Labels (1)
2 Replies
Vegar
MVP
MVP

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

 

 

QFabian
Specialist III
Specialist III

@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?

QFabian