topic Re: MultiBox Display Option. in QlikView

MultiBox Display Option.

renuka_sasikumar — Tue, 16 Jun 2015 11:32:08 GMT

Hi,

I have two multi box Year & Month

So when I select Year 2015 I want the Month should be display as =Max(Month) i.e. June, but there should be other Month in the list.

Can ayone help me with this.

Thanks & Regards,

Renuka S

Re: MultiBox Display Option.

daniel_kusiak — Tue, 16 Jun 2015 11:49:27 GMT

Maybe you can try to set this in sheet or document triggers -> Select in field month Max(month)

Re: MultiBox Display Option.

renuka_sasikumar — Tue, 16 Jun 2015 12:01:20 GMT

Hi,

I tried doing the same but the Multibox contains if condition in it,

Selection is getting selected Max Month but it does not show in MultiBox display.

Thanks & Regards,

Renuka S

Re: MultiBox Display Option.

qlikmsg4u — Tue, 16 Jun 2015 12:25:04 GMT

See the attached app.

But frankly I don't know how it is working. Can any one explain what is happening there

Re: MultiBox Display Option.

santhoo_san — Tue, 16 Jun 2015 12:36:57 GMT

In that case, create another field using your condition in the script and use the new field in your multi box and then try trigger option as Daniel said. It should work.

Re: MultiBox Display Option.

daniel_kusiak — Tue, 16 Jun 2015 12:38:11 GMT

Still you can't see ohter months in MultiBox.

Re: MultiBox Display Option.

Anonymous — Tue, 16 Jun 2015 12:52:41 GMT

Hi Renuka,

Can you reduce the data and attach your sample application.

That would be helpful.

Thanks

BKC

Re: MultiBox Display Option.

daniel_kusiak — Tue, 16 Jun 2015 13:14:22 GMT

Solution in attachement

Re: MultiBox Display Option.

Anonymous — Tue, 16 Jun 2015 13:42:13 GMT

Hi Renuka,

test this, I hope can help you (monthname is in Italian but it is not a problem).

Regards.