topic Does Actions support an expression? in QlikView

Does Actions support an expression?

Wed, 26 May 2010 22:39:43 GMT

I am using QV 9 SR4

Using any of the actions, is it possible to select values from a field based upon an expression?

For example, on click of a button, I need to define something like -

"TRADE_NET_CV>250000"

This should select all records from the straight table where TRADE_NET_CV > 250000

Currently I am handling this through macro and was looking for a way to convert this to action.

Thanks in advance!

Does Actions support an expression?

Wed, 26 May 2010 22:48:11 GMT

You should be able to use the "Select in Field" action. Put TRADE_NET_CV in for Field and >25000 in for Search String.

Does Actions support an expression?

Thu, 27 May 2010 13:23:47 GMT

Tried that! but doesnt seem to work...

Surprisingly some of the values even though they are above 250k are omitted with that logic...

Does Actions support an expression?

Thu, 27 May 2010 14:29:20 GMT

Obviously I was doing something wrong. It has been fixed now.

Thanks!

Does Actions support an expression?

Thu, 27 May 2010 15:12:00 GMT

By the way, would it be possible to select values in a range... for example, I want to do something like -

='>' & NetCVLow & ' and < ' & NetCVHigh

Both the variables are set through input box and on click of a button, I am calling above action on select field for TRADE_NET_CV

This currently selects all the values! Could someone suggest what am I doing wrong!

Thanks!

Does Actions support an expression?

Thu, 27 May 2010 15:52:15 GMT

You shouldn't need to pass the operators as strings though I don't exactly how it will respond to multiple comparisons. You may want to play with a few varieties like these:

> NetCVLow AND < NetCVHigh

TRADE_NET_CV > NetCVLow AND TRADE_NET_CV < NetCVHigh

NetCvLow < TRADE_NET_CV < NetCVHigh