Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Read about Qlik’s Response to COVID-19 Read the Letter, Join the Group.
Contributor II

Get selected value from multibox, in a chart expression

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.

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Esteemed Contributor

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

Maybe this:

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

View solution in original post

7 Replies
Highlighted

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Esteemed Contributor

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

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

Highlighted
Contributor II

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

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)

Highlighted
Esteemed Contributor

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

Maybe this:

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

View solution in original post

Highlighted
Contributor II

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

That's it! Thanks!

Highlighted
Esteemed Contributor

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

You're welcome !

Good luck

Highlighted
New Contributor

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

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.