Display the list box based on 4 different KPI's

[Sai78]

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.

[billbois · Accepted solution]

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.

[Sai78 · Accepted solution]

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.