Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

dynamic set analysis based on selection made in Listbox

Hi,

I have KPI descriptions in a list box and their corresponding id's are available in the data.

When user selects multiple KPI descriptions then we need to perform set analysis based on descriptions/or id' selected.

Example: user selects 5,7,9 kpi descriptions then it should convert like Sum(   {   KPI5  }  Values)+Sum(   {   KPI7  }  Values)+Sum(   {   KPI9}  Values)

How to write set analysis dynamically for this scenario.

dynamic set analysis for the selected values in a listbox.PNG

2 Replies
sunny_talwar

Might be easy to understand if you are able to share a sample

varshavig12
Specialist
Specialist

Sum of Values based on KPI:

sum({$<KPI>}Values)

OR

Sum of IDs, based on KPI_description:

sum({$<KPI_description>}IDs)