Re: Expressions in multibox - Qlik Community

Report Inappropriate Content · ‎2012-09-20

Hello, I need help about how to use expression in a multibox.

Let's say i want to have a multibox for each Product Brand and in each multibox only the products that belong to a line must appear.

any ideas of how to do this?

thank you!

Report Inappropriate Content · ‎2012-09-20

You can limit what is shown using expressions. See attached.

Report Inappropriate Content · ‎2012-09-20

In your case, it might be something like:

=if(Line='12345',Products)

Report Inappropriate Content · ‎2012-09-20

That works fine, but how about keep the values even if the user change the selection of the brand line?

i'm using two charts, each one must have its multibox in case the user whats to compare the sales of two different products of different brands.

Thank you

Report Inappropriate Content · ‎2012-09-20

Do you have a sample file of what you are trying to achieve? From what it sounds like, it is very doable, but I am not entirely clear about what you are trying to accomplish.

CELAMBARASAN · ‎2012-09-20

Hi,

You can go with alternates states which is new feature in Qlikview 11.

Its mainly for comparitive analysis.

Check the help file for more info.

Report Inappropriate Content · ‎2012-09-20

Following your sample file, I'm trying to create two independent multiboxes, one having Anne's Countries and in another one Joe's Contries for the use of set analysis in two charts. So the user can select in each one and the compare Anne's Country vs Joe's Country selection.

Report Inappropriate Content · ‎2012-09-20

We're currently using QV 10. But where can i find information about this?