Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

new_user30
New Contributor

Multiple Field values in Single filter- How can we make it associative

Hi,

I have 3 columns Column A, Column B, Column C residing in same table. I need to create a filter with the distinct values of this 3 columns, and when I apply filter or select any particular value which belongs to Column A, the data should get filtered based on only Column A. Is this can be achieved?

  Source Table

ABCDEFG
aa1bb1cc1deerweok
aa2bb1cc2deertdfjk
aa2bb1cc2dsytvbhjg
aa3bb2cc3dgfdkjlww

Filter Needed in below format:

aa1

aa2

aa3

bb1

bb2

cc1

cc2

cc3

Output :

In the filter if I select value aa1, only the first row should get displayed.

1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

Re: Multiple Field values in Single filter- How can we make it associative

In attached one I get what you mentioned when I select cc2.

Can you elaborate the actual business need, may be we can meet requirement by some other means.

5 Replies
Digvijay_Singh
Honored Contributor III

Re: Multiple Field values in Single filter- How can we make it associative

See if this can help -

new_user30
New Contributor

Re: Multiple Field values in Single filter- How can we make it associative

Thanks for the reply Digvijay.

But if I use the above query, only Column A will get affected. Actually I need the filter to have functionality over all the 3 columns.

Sorry that I have mentioned a particular column name in the question, I was trying to give an example.

What I meant was, the filter should posses distinct of all 3 columns and if I select a particular value, the respective Field should get filter out.

So

Output : In the filter if I select value aa1, only the first row should get displayed.

If I select value cc2, then second and third should be displayed.

Digvijay_Singh
Honored Contributor III

Re: Multiple Field values in Single filter- How can we make it associative

In attached one I get what you mentioned when I select cc2.

Can you elaborate the actual business need, may be we can meet requirement by some other means.

new_user30
New Contributor

Re: Multiple Field values in Single filter- How can we make it associative

Thank you Digvijay, this is what exactly I want.

eknezo24
New Contributor

Re: Multiple Field values in Single filter- How can we make it associative

Hi Digvijay,

Is there a way to open your .qvf file without the Sense Desktop application? I think this is exactly what I need to solve a problem I'm having but I can't open the file. Do you happen to have the script in a text document?

THANK YOU!

Best,

Elise