Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

manoranjan3359
New Contributor II

Selective values to be affected in one filter only not in other filter of Filter pane.

Hello All, I am new to Qlik and having a question on filter pane section. Here, I am having two filters one is category and second is category name. If I selected any  value in category it won't affected or selected in second filter (category name). Same like in category name filter also. Please help me out from this. 

Attached is the screenshot for your reference.

filter.PNG

 

Thank you in advance.

Manoranjan

6 Replies
Employee
Employee

Re: Selective values to be affected in one filter only not in other filter of Filter pane.

The Category and Category name fields do not seem to be associated. What does your data model look like? Do you load them as separate tables? 

manoranjan3359
New Contributor II

Re: Selective values to be affected in one filter only not in other filter of Filter pane.

Hello,
I loaded them from one table only and I want to build the expression for that column as, If user selected any value in column "Category" that won't affected or selected in the second column "Category name". So I need to build the expression like that for that column in filter pane. If I need to provide some other example:

Like this;
manoranjan3359
New Contributor II

Re: Selective values to be affected in one filter only not in other filter of Filter pane.

Another example was added as updated image in main discussion (post). Please check and let me know any information needed. Please help me on this.

Thanks in Advance.
Employee
Employee

Re: Selective values to be affected in one filter only not in other filter of Filter pane.

Maybe I didn't understand you correctly. Is your intention to have no associations between the two tables, that is, if you select Category you don't want it to affect Category name and vise versa?
In that case you can break the association in the load script with Loosen Table.
Tab1:
Load * from...;

Loosen Table Tab1;

More info in the help:

https://help.qlik.com/en-US/sense/November2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

manoranjan3359
New Contributor II

Re: Selective values to be affected in one filter only not in other filter of Filter pane.

Can, we write through expression (set analysis) part for that filter in filterpane. Like , If we select any filter that won't affected to next filter. Here I am using the Loosen function for that table but, unable to get my solution. Please help on this.

Highlighted
manoranjan3359
New Contributor II

Re: Selective values to be affected in one filter only not in other filter of Filter pane.

Both, Category and Category Name are from the same table, I used Loosen table but I am getting some data mismatch in my table when I am using the loosen function in the table.