Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ppereria
Contributor
Contributor

How to default a value on the opening of the dashboard

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

3 Replies
trdandamudi
Master II
Master II

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:

Trigger.PNG

Then in the text box you can use the expression that you posted. Hope this helps..

Sue_Macaluso
Community Manager
Community Manager

Is this for QlikView or Sense? I would like to move it into the product forum as this is for non product discussion. Thanks
Sue Macaluso
trdandamudi
Master II
Master II

This is for qlikview.

Thanks