Gantt Chart ignor Filter

[Flxvio043]

hello all.

I am working on two different Qliksense Gantt chart. For the data I am using sharepoint. So far so good.
In my data it is important to filter by countries and regions. There are SSA, Asia-Pasific, MEA etc. and also Global for so called Reference Country's like USA or EU. However, these are entered quite normally in the countries. So example for the data that:

Now I would like to make a Gannt Chart only for these Reference Country EU, USA and Switzerland. So it should only show the countries USA, EU and the home country, which is in the subregion Global. Now the problem is that a user can filter by subregion. Nothing is displayed in the chart if global is not selected. However, I would like to ignore the filter so that these countries are always displayed.

As dimension I have this code:

=if(Country='EU' or Country='USA' or Country='Switzerland', Country)

And as meassure i have this code two if's for

Start date:
if(Country='Switzerland' or Country='USA' or Country='EU', if([Actual Submission Date]<>'', [Actual Submission Date], if(GetFieldSelections(Case)='Standard Case', [Target Submission Date (Standard Case)], [Target Submission Date (Best Case)])), min([Actual Submission Date]))

End date:

if(Country='Switzerland' or Country='EU' or Country='USA', if([Actual Approval Date]<>'', [Actual Approval Date], if(GetFieldSelections(Case)='Standard Case', [Target Approval Date (Standard Case)], [Target Approval Date (Best Case)])), min([Actual Approval Date]))

I would be so happy if someone could help me. I'm really lost at this point.

Thank you very much

[Michael_Tarallo · Accepted solution]

Hi there - have you looked at Set Analysis? - This can have different settings to ignore filters and define specifics sets of data for your measures. 

For example -SUM({1<[Model Variation]={'Control Pad','Arcade Stick'}>}[Lineitem price] * [Lineitem quantity])

This will calculate Gross Sales - for only Control Pad and Arcade Sticks and will ignore any selections - using the "1" identifier

This video shows a quick example use case and the below links have more examples.

https://youtu.be/wSrKGu_8EfU 

More helpful resources:

Introduction to Set Analysis: - Part 1 https://www.youtube.com/watch?v=YMQJnKMkfxg

Cool Stuff you can so with Set Analysis - Part 2 https://www.youtube.com/watch?v=nB-HJ8X1QbI&t=0s

Qlik Sense in 60 - Set Analysis https://www.youtube.com/watch?v=uVDOESAxp3M

Getting Started Data Samples and Examples: https://community.qlik.com/t5/Qlik-Sense-Documents/Introduction-to-Set-Analysis-video-Part-1/ta-p/14... https://community.qlik.com/t5/Qlik-Sense-Documents/Set-Analysis-Part-2-Cool-Stuff-You-Can-Do-video/t...

Qlik Help

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/SetAnalys...