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