topic Re: Dependent Listbox and Table Box in QlikView

Dependent Listbox and Table Box

Wed, 25 Nov 2020 16:16:04 GMT

I have two list boxes "ShipCountry" and "ShipCity" and one TableBox as per attached screenshot.

I have the following requirement

1. The selection of ShipCountry and ShipCity should be independent.

2. When I select "ShipCountry" it should show record in Table based on ShipCountry selected. But should not effect selection of "ShipCity"

3. When I select "ShipCity" it should show record in Table based on ShipCountry selected. But should not effect selection of "ShipCountry"

The point 1 I was able to achieve by setting "Alternate States"

Re: Dependent Listbox and Table Box

Gysbert_Wassenaar — Sat, 21 May 2016 17:01:47 GMT

I'm not quite sure what you want. Have a look at this blog post: http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/

Re: Dependent Listbox and Table Box

Sun, 22 May 2016 07:37:00 GMT

My requirement is when I select ShipCity (for e.g. Berlin), then the ShipCountry box selection should be cleared and the TableBox should ONLY show the record of the selected city (Berlin)

Similarly when I select ShipCountry (for e.g. Canada),then the ShipCity box selection should be cleared and the TableBox should ONLY show the record of the selected Country (Canada)

Re: Dependent Listbox and Table Box

Gysbert_Wassenaar — Sun, 22 May 2016 12:23:10 GMT

Ah, you want to confuse the heck out of your users by making Qlikview work totally different from the way it does by default. Well, if you insist. Open the Document Properties window and go to the Triggers tab. Select the ShipCountry field in the Field Event Triggers and click the Add Action(s) button below OnSelect. On the Actions dialog window click on the Add button. Next select the Clear Field action in the list of actions on the right. Click the OK button. In the Field input box enter the name of the other field ShipCity. Click the OK button to save the action configuration and to return to Document Properties window. Now do the same for the ShipCity field only this time use ShipCountry as name of the Field to be cleared. When done click OK to close the Document Properties window.

Re: Dependent Listbox and Table Box

Sun, 22 May 2016 15:33:36 GMT

Hi,

I have tried the given steps. But it doesn't works. I have attached the screen of the steps.

Do we need to specify objectId in Field for Actions or FieldName?

Re: Dependent Listbox and Table Box

Gysbert_Wassenaar — Mon, 23 May 2016 05:32:31 GMT

Use the Clear Field action instead of the Clear Other Field action.

Re: Dependent Listbox and Table Box

Wed, 25 May 2016 02:43:23 GMT

I have tried but it doesn't work. When I select "ShipCity" it select the corresponding "ShipCountry". When I select "ShipCountry" it clears "ShipCity" as well as "ShipCountry"

Re: Dependent Listbox and Table Box

Gysbert_Wassenaar — Wed, 25 May 2016 06:56:52 GMT

Post a small Qlikview document that demonstrates the problem.

Re: Dependent Listbox and Table Box

Wed, 25 May 2016 19:03:08 GMT

I have attached .qvw file along with data in excel sheet

Re: Dependent Listbox and Table Box

Gysbert_Wassenaar — Thu, 26 May 2016 15:55:54 GMT

As I explained above you need to use the Clear Field action. Not the Clear Other Field action.