topic Re: Get selected value from multibox, in a chart expression in QlikView

Get selected value from multibox, in a chart expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Get selected value from multibox, in a chart expression

Anil_Babu_Samineni — Fri, 19 Jan 2018 14:01:53 GMT

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

Re: Get selected value from multibox, in a chart expression

YoussefBelloum — Fri, 19 Jan 2018 14:06:25 GMT

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])

Re: Get selected value from multibox, in a chart expression

Anonymous — Fri, 19 Jan 2018 14:20:23 GMT

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)

Re: Get selected value from multibox, in a chart expression

YoussefBelloum — Fri, 19 Jan 2018 14:28:40 GMT

Maybe this:

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

Re: Get selected value from multibox, in a chart expression

Anonymous — Fri, 19 Jan 2018 14:47:40 GMT

That's it! Thanks!

Re: Get selected value from multibox, in a chart expression

YoussefBelloum — Fri, 19 Jan 2018 14:49:19 GMT

You're welcome !

Good luck

Re: Get selected value from multibox, in a chart expression

maheshakula02 — Wed, 28 Aug 2019 21:55:32 GMT

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.