Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to set a dimension value based on the selection of a multibox selection by a user. I have attached a sample .QVW with a use case. When the user selects on the DEPT dimension in a summary table I want either a trigger. Any thoughts?
Thanks,
Ryan
My use case was cutoff. When a user comes in a selects a DEPT from the Summary Multibox I would like to automatically set the DEPTHis dimension in the History Multibox to the equivalent value. I cannot perform this as a trigger in the Multibox as it does not allow triggers. What would be the best solution to support this use case? This is an actual use case for another app I support and cannot change the underlying datamodel to link the two tables.
Thanks
Check this?
Change your variable vDept to below using Ctrl+Alt+V
= GetFieldSelections(DEPT)
Then in your 2nd Bar Total Charges History Graph use this as your expression:
= IF(GetSelectedCount(DEPT) > 0, Sum({< DEPTHis = { '$(vDept)' } >}Charges), Sum(Charges))
If you want the History Multibox to be selected as well when DEPT is selected. Use trigger like below:
Thanks Vishwarath, One other use case I would need is the ability to select multiple values in the DEPT multibox. Like IT, Financial. I tried this, but it does not bring back any data when more then one is selected. Do I need to wrap the variable a certain way in the set analysis?
Try this in your expression?
= IF(GetSelectedCount(DEPT) > 0, Sum({< DEPTHis = { $(=concat(chr(39) & DEPT & chr(39),',')) } >}Charges), Sum(Charges))
And change the trigger to below