Setting default value at reload

[#1]

Basically I would like to set a date selection field (DATA_TS) to the latest date of the last data reload.  I thought the first step would be to create a variable trigger, such as:

Settings --> Document Properites --> Triggers --> OnPostReload

Variable: vMaxDate     Value: =MAX(DATA_TS)

This does not seem to work as the value in vMaxDate is not getting set to the most recent date loaded.  Seems I need to get this part figured out first.  Next I need to understand how to get this date to become the only selection criteria for DATA_TS, i.e. overriding whatever value or values were selected for DATA_TS prior to the reload. 

All help appreciated.

Regards,

Lew

[#2 · Accepted solution]

Hi,

to select max value in DATA_TS field after every reload, use Select in Field Action Trigger OnPostReload

in Document properties: Field: DATA_FS, Value: max({1} DATA_TS)

Regards

[#3]

Many Thanks qlik_techie -- it worked!

Regards,

Lew

[#4]

Hi qlik_techie,

I've migrated my Dashboard from the desktop client to Qlikview Server.  Nothing has changed with my qvw, but the reloads of course now occur in the Server.  On the Server it seems this setting value OnPostReload is not working :-s   Any thoughts?

Thanks,

Lew

[#5]

Seems I've got my answer from Qlikview Support.  The OnPostReload Trigger does not work with Server/Publisher reloads, it only works on Manual reloads in the QV Client.  I'm told the OnOpen Trigger does work in the Server, so will be trying that shortly.

[#6]

Are u looking at the application from browser other than IE ?

Regards

[#7]

I am using IE.  Also, this OnOpen Trigger solution suggested by Qlikview does not work; in fact no default is getting set now