Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I need to get certain result without clicking on any filter,
by default it should pick the application name as its result as soon as dashboard gets loaded. For example.
I want to do the below -
=if(Application ='ABC' and Databaseupdatedate >20, 'True', 'False'))
that means by default when dashboard loads it should pick 'ABC' and if meets criteria it should show true or false in a text box. Currently it shows result only if i manually select the Application as ABC.
I need this value for my other calculations, hence do not want to disturb the actual dashboard presentation which shows everything by default
When you open the dashboard, if you want 'ABC' to get selected automatically then you need to use On Open Trigger in document Properties as show below in the screen shot:
Then in the text box you can use the expression that you posted. Hope this helps..
This is for qlikview.
Thanks