How to add static filter on a table in Qlik Sense?

[mrichman]

Hi community.

I'm wondering if you could help me out.

I have a 2 tables,  1 dynamically changes when I use the filter. However, I would like the other one to always be filtered of my choice, no matter than current filter. The table is a combination of strings and numbers.

Do you guys know how to do this?

Thanks in advance.

[niclaz79]

Hi,

You can override any selections made and apply others using set-expressions. This way it will not be affected by anything you click on filter-wise.

[mrichman]

Hi Niclas,

Thanks for your prompt reply. I would I use the set-expressions? I have tried using a set analysis but i'm getting wrong numbers. Do you have any suggestions?

ie. If Scenario filter is "Scenario 1", then show "Scenario 2"  .....something like this.

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetA...

Thanks in advance.

[MK9885]

I think in Nov-2018 latest release for Qlik Sense they are rolling out alternate states.

https://www.quickintelligence.co.uk/alternate-states-in-qlik-sense/

Same as what we had in QlikView.

Or as suggested you can use Set Analysis with different Identifiers

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetA...

[fginfrida]

If the requirement is to have a table always return a subset of the data, there's a straightforward approach that works.

Assume that your table shows a listing of work orders, e.g.

Work Order Number     Responsible Technician

12345                                  Bill

23456                                  Mary

67890                                  Joe

The table can be limited to return only the work order assigned to Bill by changing the expression for Work_Order_Number to:

=IF(Responsible_Technician = 'Bill', Work_Order_Number, NULL())

and unchecking the "Include Null Values" check box.

[Mukesh_s]

Hi @fginfrida ,

I want to get the rows which is having the responsible technician as "bill" but this value will change regularly, but the place is same. So what ever it is in Bill place I want the rows with that value. Can you help me in getting the data with this requirement.

Thank you.