Discussion board where members can get started with QlikView.
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 !
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:
View solution in original post
Hi Amruta Joshi,
Try to check: Hide Excluded vales on the presentation tab on the multibox properties.
Presentation tab - Hide Excluded check box.
Before selection of data
After data selection from Month field
Thank You all for your help !