Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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.
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.
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.