topic Re: Display the list box based on 4 different KPI's in QlikView

Display the list box based on 4 different KPI's

Sai78 — Sat, 26 Sep 2020 19:54:57 GMT

I have a requirement that a list box which by default displays the unique cases by adding the 4 different KPIs(each KPI has different logic) ..KPI display counts ..but the list box displays the case #.

When the user clicks one KPI, the list box should display the cases according to that KPI.

If the user does not select any KPI, by default list box should display the total unique cases from all KPI's

Any insight would really help.

Re: Display the list box based on 4 different KPI's

billbois — Wed, 09 Sep 2020 16:12:06 GMT

I'm not sure I understand correctly, but I think you'll need to set your list box's Field to an expression. Scroll down to the bottom of the Field list, select <Expression>, and the Edit Expression dialog will pop up. Your expression would be something like:

If(GetSelectedCount(KPI_1) = 1,

KPI_1_Cases,

If(GetSelectedCount(KPI_2) = 1,

KPI_2_Cases,

If(GetSelectedCount(KPI_3) = 1,

KPI_3_Cases,

If(GetSelectedCount(KPI_4) = 1,

KPI_4_Cases,

Cases))))

Just a guess.

Re: Display the list box based on 4 different KPI's

Sai78 — Wed, 09 Sep 2020 20:24:24 GMT

Thanks to your reply, I figured a solution

The solution is to create five list boxes and, using actions, controlled the list box conditional display.