topic Re: Clearing previous selection with a trigger? in QlikView

Clearing previous selection with a trigger?

Tue, 12 Feb 2013 15:25:21 GMT

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!

Re: Clearing previous selection with a trigger?

jonathandienst — Tue, 12 Feb 2013 15:32:29 GMT

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

Re: Clearing previous selection with a trigger?

Tue, 12 Feb 2013 15:48:02 GMT

Brilliant!

Thanks!