Problem creating an action with an "indirect" selection

[jcarpenter9]

I'm trying to create a button that applies an "indirect" selection, that is, a selection based on values in other fields than the field being selected. For example (using the QlikView Designer course .qvw), I can enter this search in the OrderID list box:

=UnitPrice<CataloguePrice

...and all orders that were sold for less than the CataloguePrice are selected. It's a bit like using the P() function in set analysis.

I cannot, however, figure out how to enter this criterion as a Selection Action in a button. I've entered it with and without quotes "", equal sign =, brackets []. Can anyone provide an answer for this?

James

[rwunderlich · Accepted solution]

Define the Action Search String like this:

='=UnitPrice < CatalogPrice'

-Rob

http:/robwunderlich.com

[jcarpenter9]

That was quite the correct answer, indeed. Thank you, Rob!

I wish I could attend the conference of QlikView "rockstars" in Vegas this spring. I hope it goes well..

James

[rwunderlich]

Thanks. Sorry you can't join us in Las Vegas. The conference link for anyone else who may be interested is

http://masterssummit.com/

-Rob