Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Syntax for an Action

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?

1 Reply
rubenmarin

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.