Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

Expressions in multibox

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!

7 Replies
Not applicable

Re: Expressions in multibox

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

Not applicable

Re: Expressions in multibox

In your case, it might be something like:

=if(Line='12345',Products)

Not applicable

Re: Expressions in multibox

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

Not applicable

Re: Expressions in multibox

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.

Re: Expressions in multibox

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.

Not applicable

Re: Expressions in multibox

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.

Not applicable

Re: Expressions in multibox

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