topic Conditional List Box in QlikView

Conditional List Box

balrammahato204 — Sat, 16 Nov 2024 04:47:37 GMT

Please help on below requirement.

I have one list box which is available on all sheets of the dashboard and this list box having the default selection value and can select the multiple values from this list box and able to filter the data. Now i want, once movement is happen from one sheet to another sheet then only default selection should available on my list box and rest of the selection should be clear.

Please advise.

Thanks in Advance

Balram

Re: Conditional List Box

Nicole-Smith — Thu, 10 Jan 2019 15:19:15 GMT

You can set triggers on each sheet to reset the selections.

On each sheet:

Go to Settings > Sheet Properties
On the "Triggers" tab, you want to add actions "OnActivateSheet"
Add "Clear Field"
1. Enter the name of the field you want to clear
Add "Select in Field"
1. Enter the name of the field you want to select in
2. Enter the "default" value you want selected

Re: Conditional List Box

balrammahato204 — Thu, 10 Jan 2019 16:44:18 GMT

Thanks Nicole,

Its Working

Regards

Balram

@Nicole-Smith wrote:
You can set triggers on each sheet to reset the selections.
On each sheet:
Go to Settings > Sheet Properties
On the "Triggers" tab, you want to add actions "OnActivateSheet"
Add "Clear Field"
Enter the name of the field you want to clear
Add "Select in Field"
Enter the name of the field you want to select in
Enter the "default" value you want selected