Get selected value from multibox, in a chart expression

[Anonymous]

I have a multibox with which I can select a work cycle(cycle1, cycle2 and cycle3). How can I get the value selected in the multibox for the cycle field and then use it in a chart expression? I have to change the value of a field called "working days" in the said chart(Pivot table) depending on the selected cycle value.

[Anil_Babu_Samineni]

This can be achievable, Would you like to share some sample application?

[YoussefBelloum]

Hi,

retrieve the values:

=Concat(distinct work_cycle, ',')

use it on chart (set analysis for example):

Sum({< work_cycle={$(=Concat(distinct work_cycle, ','))}  >} [working days])

[Anonymous]

Sum({< work_cycle={"=Concat(distinct work_cycle, ',')"}  >} Value) basically sums all Values that have the work_cycle value equal to the value selected in my multibox right? How do I use "=Concat(distinct work_cycle, ',')" in an If?
I'm looking for something like if( $(=Concat(distinct work_cycle, ',')) = 'Cycle1', do_stuff, do_else_stuff)

[YoussefBelloum · Accepted solution]

Maybe this:

=if(WildMatch(Concat(distinct work_cycle, ','),'*Value*'), 'do_stuff','dont do stuff')

[Anonymous]

That's it! Thanks!

[YoussefBelloum]

You're welcome !

Good luck

[maheshakula02]

Is work_cycle the Object ID of the multi box? When I use the object id in the function Concat(distinct MB01, ','), it doesn't work. Thanks in advance.