Clearing previous selection with a trigger?

[#1]

Hi,

There is a Customer Type field which can be either ‘VIP’ or ‘Regular’.

I would like the user to select one of the following options:

• VIP
• Regular
• All

Assuming I use a ListBox, my question is how to implement the ‘All’ selection.

Another words, how do I clear the previous selection. I tried triggers, but I had a problem with defining an expression for the search string in a selected field.

Thanks!

[jonathandienst · Accepted solution]

Hi

Add the following inline load in your script:

Customer_Type_Select:

LOAD * Inline

[

          Customer Type, Customer Type Select

          VIP, VIP

          Regular, Regular,

          VIP, All

          Regular, All

];

Then use [Customer Type Select] in your list box (and Qlikview will do the rest!)

Hope that helps

Jonathan

[#3]

Brilliant!

Thanks!