Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
 JuMo
		
			JuMo
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Hello
I have the following data structure with a very simple star model.
I want to implement the following layout
Can I get that in Qlik ? How ?
 JuMo
		
			JuMo
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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
 JuMo
		
			JuMo
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		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-
		
			-SW-
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Potentially Alternate State may be useful here.
https://help.qlik.com/en-US/sense/May2025/Subsystems/Hub/Content/Sense_Hub/Visualizations/alternate-...
or set analysis where you ignore certain fields:
https://community.qlik.com/t5/QlikView-App-Dev/Set-Analysis-to-Ignore-Specific-Filters-Dimensions/td...
