Clear listbox based on a particular value on another listbox

[udaya_kumar]

Hi,

I have two listboxes, Listbox1 and Listbox2.

consider i have values in Listbox1 like

Fruits

Vegetables

Animals

In Listbox2

Apple

Orange

Carrot

Cucumber

Lion

Tiger

If Tiger is selected in Listbox2, then on clicking Fruits, the Listbox2 should get cleared.

How can we do this?

[#2]

How are the data loaded?

If you link the to datasets, Qlikview will do this automatically. Se attached file.

Table1:

LOAD * INLINE

[

   Group, Item

   Fruits, Apple

   Fruits, Orange

   Vegetables, Carrot

   Vegetables, cucumber

   Animals, Lion

   Animals, Tiger

];

[udaya_kumar]

Hi Martin,

I am getting data from Database, i cant use like this in load script, since the data is big.

And i gave the simple example, but that is not proper.

But i want like, on clicking Fruits, the Listbox2 should get cleared, but on clicking other value in Listbox1 should not clear Listbox2.

[#4]

Hi,

If the data is not related, you can use a trigger.

Attached is a document with this.

The trigger is defined in the "Settings"-menu and select "Document properties"

Go to the tab "Triggers" and look click on "Item <Has action(s)>" in the "Field event triggers"-combobox.

Then click on the button "Edit action(s)..." nedt to it.

Cheers

[udaya_kumar]

hi martin,

Thanks for the reply,

In the file which u have given,

I want like,

Clicking on listbox "Group" with value Animals, then the Item listbox should get cleared.

on clicking on Fruits and Vegetables, the Item listbox should NOT get cleared.

i want this functionality.

[#6]

Please attach a file containing the data. How are the data in the two listboxes connected in the load?