topic Problem creating an action with an "indirect" selection in QlikView

Problem creating an action with an "indirect" selection

jcarpenter9 — Wed, 27 Feb 2013 21:35:18 GMT

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

Re: Problem creating an action with an "indirect" selection

rwunderlich — Thu, 28 Feb 2013 06:16:55 GMT

Define the Action Search String like this:

='=UnitPrice < CatalogPrice'

-Rob

http:/robwunderlich.com

Re: Problem creating an action with an "indirect" selection

jcarpenter9 — Thu, 28 Feb 2013 13:48:55 GMT

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

Re: Problem creating an action with an "indirect" selection

rwunderlich — Fri, 01 Mar 2013 04:10:49 GMT

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