topic Re: Filter Values in MultiBox in QlikView

Filter Values in MultiBox

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

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 !

Re: Filter Values in MultiBox

avkeep01 — Thu, 30 Aug 2018 10:17:24 GMT

Hi Amruta Joshi,

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

Re: Filter Values in MultiBox

jyothish8807 — Thu, 30 Aug 2018 10:39:03 GMT

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:

Re: Filter Values in MultiBox

BalaBhaskar_Qlik — Thu, 30 Aug 2018 13:28:35 GMT

Presentation tab - Hide Excluded check box.

Before selection of data

After data selection from Month field

Re: Filter Values in MultiBox

amruta_j — Fri, 31 Aug 2018 06:49:54 GMT

Thank You all for your help !