topic Re: Setting default value at reload in QlikView

Setting default value at reload

Thu, 18 Oct 2012 16:05:48 GMT

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

Re: Setting default value at reload

Thu, 18 Oct 2012 16:14:21 GMT

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

Re: Setting default value at reload

Tue, 23 Oct 2012 21:35:19 GMT

Many Thanks qlik_techie -- it worked!

Regards,

Lew

Re: Setting default value at reload

Thu, 06 Dec 2012 20:30:46 GMT

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

Re: Setting default value at reload

Thu, 06 Dec 2012 21:56:54 GMT

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.

Re: Setting default value at reload

Thu, 06 Dec 2012 21:57:32 GMT

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

Regards

Re: Setting default value at reload

Fri, 07 Dec 2012 02:04:02 GMT

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