Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
];
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.
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
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.
Please attach a file containing the data. How are the data in the two listboxes connected in the load?