Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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)