Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kennethand
New Contributor III

How to disable connection between filter

Is it possible to disable the connection between to filters?

Usually when I select from one filter the corresponding answers in another filter will be shown and the answer which is not corresponding will be shown in grey like this:

Udklip.PNG

I don't want them suppressed at all.

How do I do that?

9 Replies
mikelmuru
New Contributor II

Re: How to disable connection between filter

Hi

Are the fields in the same table?

tomasz_tru
Valued Contributor

Re: How to disable connection between filter

You have to rebuild your data model, or use set analysis to make your measures independend of such a selection.

Tomasz

kennethand
New Contributor III

Re: How to disable connection between filter

Thanks for you answer - but how do I do that?

Partner
Partner

Re: How to disable connection between filter

=aggr(Only({$<YourDimension= p({1})>} YourDimension),YourDimension)

tester_sogeti
Contributor

Re: How to disable connection between filter

You can create data islands. As the name says it is a field disconnected from the others so when you select one filter the data island will not be affected.

Or you can use set analysis like this:

Imagine 2 linked fields, Country and Revenue. When i select 1 contry only 1 revenue is shown (just like in you case). To make all Revenues able to be shown i will use this set analysis in the objects that i want (obviusly i will have to use some calculation like sum, average...):

  {$<Country=>}

This makes the selection of country to not affect the object.

Regards

Partner
Partner

Re: How to disable connection between filter

Havn't this done the trick?

Capture.PNG

Capture.PNG

Employee
Employee

Re: How to disable connection between filter

Hi Kenneth - I see you are new to Qlik - so some of these responses might be a bit daunting. Our Qlik Community is great, but may forget to look at the users level number and may assume the common Qlik language is understood.

You have a couple of good suggestions here - please advise if you need clarity on them.

In short what you are experiencing is part of our associative technology - which automatically displays related and unrelated values using the color scheme green, white and shades of grey - if you want to learn more you can read this post here: The Associative Difference

Now in regards to your questions:

The values that show up in gray - are not related to the current selections.

  • Do you not want them to appear in gray?
  • Would you rather have them removed from the list?

If you can described your use case a bit better - we can propose perhaps better ideas.

Re:

Set Analysis is an expression syntax that can restrict measures uses in visualizations to a sub-set of data that you define - there is an option to ignore any selections - so the visualization's measure displays only that measure even where someone selects values from list boxes and charts - it is very powerful expression and can be used for a number of things. There are some beginner videos on the topic here:

New to Qlik Sense Videos

If you have time, I suggest you take a moment to review them.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
kennethand
New Contributor III

Re: How to disable connection between filter

Hi Mike,

I have no problems dealing with set analysis in this case.

I have one table, But I need to use one filter for one part of the table and another filter for another part. Which means I don't want the selection from one filter to affect between the two filters.

tiziano_z
New Contributor II

Re: How to disable connection between filter

DID SOMEONE FIND A SOLUTION FOR THIS ? I AM STACKING ON THE SAME PROBLEM.