topic dynamic set analysis based on selection made in Listbox in QlikView

dynamic set analysis based on selection made in Listbox

Wed, 25 Nov 2020 16:16:04 GMT

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.

sunny_talwar — Tue, 18 Oct 2016 02:59:47 GMT

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

varshavig12 — Tue, 18 Oct 2016 03:26:54 GMT

Sum of Values based on KPI:

sum({$<KPI>}Values)

Sum of IDs, based on KPI_description:

sum({$<KPI_description>}IDs)