Dynamic Filter for Comparibility

Riadak — Sat, 16 Nov 2024 02:20:27 GMT

Hello Qlik Community,

I need help to create a dynamic filter.

I have a classic Market Analysis Dashboard and I want to be able to analyze sales over time. However, a comparison over time might be flawed, because a Brand might drop in and out over time. Instead of a User Manually deselecting the Brands that are not consistently reported in the selected time period, I want to enable a filter that the user can select.

So I am able to create a measure that creates the desired output:

if(Count(Aggr(Sum(UNITS_SOLD),Brand,[Date.autoCalendar.Year])) = Count(Distinct Total [Date.autoCalendar.Year]),'Comparable','Not Comparable')

However, I have no clue how to transform this into a calculated dimension, since AGGR does not work in a calculated dimension. I believe adding this into to load script will also not be of use, since I want the dimension to be calculated dynamically based on the selected years.

I would highly appreciate your help.

topic Dynamic Filter for Comparibility in App Development

Dynamic Filter for Comparibility