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.

Not applicable

Clearing previous selection with a trigger?

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!

1 Solution

Accepted Solutions
MVP
MVP

Re: Clearing previous selection with a trigger?

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
2 Replies
MVP
MVP

Re: Clearing previous selection with a trigger?

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Clearing previous selection with a trigger?

Brilliant!

Thanks!

Community Browser