Hi everyone,
I have the following problem. I created a line chart that displays different KPIs depending on a variable. The variable changes through the selection in a filter field and is then used in the diagram to adapt the set for which the KPI should be calculated. This means I can only display one variable at a time, because if I select another item in the filter field the set changes as well.
It looks like this:
COUNT({$<category = {'$(variable)'}>}KPI)
I am looking for a way now to display several KPIs at the same time without using thousands of if()s in the chart script. Do you have any ideas?
I thought for example of an array variable and a loop in the chart script that iterates over the array. Is there anything like this in qlik sense?