DEAR TEAM,
We have one multibox object which is subset of FEILD (KPI).Here multibox object will show values excluding selection of MAIN KPI.
Example:
KPI Values->A,B,C,D,E,F,G
Current Selection of KPI -> A,B
THEN MULTIBOX OBJECT WILL CONATINS-> C,D,E,F,G for user selection exclude (A,B).
What clients require is that in Multibox obect drop down it should be autoselected with first value in alphabetic order(A-Z) list.
i:e here Multibox object selection will be "C"" of KPI as it is the first that appears in aplhabtic order.
Is it possible that I can do as required by any MACRO or existing QLIKVIEW TRIGGERS? CAN YOU PLEASE ADVISE.