Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
JuMo
Creator
Creator

Filters applying to some objects but not the others

Hello

I have the following data structure with a very simple star model.

Model.png

 

I want to implement the following layout

  • KPIs Object on the left are affected by the 3 filters
  • Charts Objects on the right are only affected by the year and the product filtesr.

Can I get that in Qlik ? How ?

 

Drawing1.png

Labels (4)
1 Solution

Accepted Solutions
JuMo
Creator
Creator
Author

Eventually, I have used a set expression that ignore the filter

{<[Calendar.Month]=>} FirstSortedValue({<Fact.KPIName = {"KPI 3"}>} Fact.Actual,Calendar.ID)

It only work if it treat the ignored filter with an OUTER ser expression

View solution in original post

2 Replies
JuMo
Creator
Creator
Author

Eventually, I have used a set expression that ignore the filter

{<[Calendar.Month]=>} FirstSortedValue({<Fact.KPIName = {"KPI 3"}>} Fact.Actual,Calendar.ID)

It only work if it treat the ignored filter with an OUTER ser expression

-SW-
Partner - Creator II
Partner - Creator II