Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
Thanks in advance.
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
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.
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.