Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Filter Values in MultiBox

Hi All,

Need your help one more time. Below is the scenario:

I've 6 countries and 6 currencies. I've listbox for Country and MultiBox for Currencies. As of now, when I select one Country say HK, it is showing me all the currencies to choose from.

I want to restrict the currencies according to Country. If I'm selecting HK as Country, Currency multibox should show me only HKD and SGD, likewise For India, Currency should be INR and SGD.

Thank You in advance !

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Re: Filter Values in MultiBox

Hi Amruta,

You can simply create an association between country and currency, then hide exclude values from the presentation tab on the multi box:

Refer the attached:

Best Regards,
KC

View solution in original post

4 Replies
Highlighted
Partner
Partner

Re: Filter Values in MultiBox

Hi Amruta Joshi,

Try to check: Hide Excluded vales on the presentation tab on the multibox properties.

Highlighted
Master II
Master II

Re: Filter Values in MultiBox

Hi Amruta,

You can simply create an association between country and currency, then hide exclude values from the presentation tab on the multi box:

Refer the attached:

Best Regards,
KC

View solution in original post

Re: Filter Values in MultiBox

Presentation tab - Hide Excluded check box.

Before selection of data

After data selection from Month field

Highlighted
Partner
Partner

Re: Filter Values in MultiBox

Thank You all for your help !