topic Re: Create Two multibox independently in QlikView

Create Two multibox independently

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

Hi,

I have a question,

I want to create 2 multi box object with the same field (let's say my field name is Product)

Each multi box only choose one value and not related to another multi box.

So if i want to choose two product (lets say product A and product B), i must choose A in first multi box, and choose B in second multi box. The 1st and 2nd multi box must be independent

Is it possible to make it ?

Looking forward for your great idea. thanks in advance

Re: Create Two multibox independently

vishsaggi — Thu, 18 Aug 2016 03:53:47 GMT

Use Alternate states from Document Properties.

Add Alt state and give it a name. Use this name in one of the Multibox -> Properties -> Alt State dropdown.

Re: Create Two multibox independently

Thu, 18 Aug 2016 03:55:11 GMT

Hi,

Use different alternate state in two multi boxes.

To create alternate state :- Settings-> Document Properties-> General Tab-> Alternate States Button-> Add Alternate state with any name.

And set those Alternate states in Multi box Properties.

Thanks!

Re: Create Two multibox independently

VishalWaghole — Thu, 18 Aug 2016 04:05:50 GMT

Hi,

PFA attached test application and images.

Use created state in list box, refer attached below image.

Regards,

Vishal Waghole

Re: Create Two multibox independently

Anonymous — Thu, 18 Aug 2016 04:55:30 GMT

Hi,

Thanks for your idea.

But i still confuse how to get the value from the selection ?

Thanks in advance.

Re: Create Two multibox independently

kaushiknsolanki — Thu, 18 Aug 2016 05:01:48 GMT

Hi,

If you use the options given above then you will have to use the Set. And your expression should be like below.

sum({[Group 1]<Product= $::Product>} Sales)

Regards,

Kaushik Solanki