Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Julie_J
Contributor
Contributor

Is it possible to filter on multiple selections in the same filter pane using AND logic?

Hi,

I am having a field with values Seperated by pipeline.

For example

SampleValue
A|B|C1
A|B1
A|C2
B|C3
C|A|B1
A|D4
A1
C|B3
B4
D1

 

I need a multiselect dropdown with the distinct values from the column. In this case my dropdown should contain A, B, C and D.

If I select A from the dropdown then it should select the following rows

SampleValue
A|B|C1
A|B1
A|C1
C|A|B1
A|D4
A1

 

Now If I select both A and B from the dropdown Then it should select the following rows

SampleValue
A|B|C1
A|B1
C|A|B1

 

If I select A,B and C , Then I should get

SampleValue
A|B|C1
C|A|B1

 

Can somebody help me with this

1 Reply
ArnadoSandoval
Specialist II
Specialist II

@Julie_J 

Please take a look at this topic: Filter widget | Comma separated values and this QS Help article: Searching within selections or visualizations 

hth

Arnaldo Sandoval
A journey of a thousand miles begins with a single step.