Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
renuka_sasikumar
Creator III
Creator III

MultiBox Display Option.

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

8 Replies
daniel_kusiak
Creator II
Creator II

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

renuka_sasikumar
Creator III
Creator III
Author

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

qlikmsg4u
Specialist
Specialist

See the attached app.

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

santhoo_san
Partner - Creator II
Partner - Creator II

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.

daniel_kusiak
Creator II
Creator II

Still you can't see ohter months in MultiBox.

Anonymous
Not applicable

Hi Renuka,

Can you reduce the data and attach your sample application.

That would be helpful.

Thanks

BKC

daniel_kusiak
Creator II
Creator II

Solution in attachement

Anonymous
Not applicable

Hi Renuka,

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

Regards.