topic Re: Syntax for an Action in QlikView

Syntax for an Action

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have the following statement:

=If(Metric_Charge_Actual_CurrentMonth_EPSI>'0',Metric_MonthEndDate,'')

This statement is in the Settings>Document Properties>Triggers>On Open>Action>Select in Field.

The statement is not appearing in the Current Selection when I close the dashboard and re open it. Should the statement be different?

Re: Syntax for an Action

rubenmarin — Wed, 07 Mar 2018 15:18:48 GMT

Hi Quan, you can add the expression to a text box to check the value returned, after setting the expression that retruns the value you wants you can add an action to the same text box, and check if clicking it works as you want. If it works ok, the same action OnOpen should work.

Maybe has something to do with Metric_Charge_Actual_CurrentMonth_EPSI having more than one value, in this case adding a Max() or some other funcion that returns only one value con solve this.