Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
balrammahato204
Not applicable

Conditional List Box

Hi All,

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

 

Labels (1)
1 Solution

Accepted Solutions
balrammahato204
Not applicable

Re: Conditional List Box

Thanks Nicole, 

Its Working 

Regards

Balram


@Nicole-Smith wrote:

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

On each sheet:

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

 


 

2 Replies
Nicole-Smith
Not applicable

Re: Conditional List Box

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

On each sheet:

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

 

balrammahato204
Not applicable

Re: Conditional List Box

Thanks Nicole, 

Its Working 

Regards

Balram


@Nicole-Smith wrote:

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

On each sheet:

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