topic Maintain variable through reload on QVS in QlikView

Maintain variable through reload on QVS

Anonymous — Thu, 29 Sep 2016 16:39:20 GMT

First thing, I do not manage and can not manage the QlikView servers. We are given shared space in the environment to manage an application which includes file turnovers, reloads, & entitlements.

Details:

Variable: DateSelection

Values: Last 7 Days, Last 30 Days, Last 90 Days, Last 120 Days, Today, Week To Date, Month To Date, Last 6 Full Months w/ MTD

The variable is set through triggers on buttons to change the timeframe being displayed. ie. The 'Last 7 Days' button will apply a selection to my date field to show only incidents opened in the last 7 days and it will change the variable DateSelection to 'Last 7 Days'.

Locally in QlikView Desktop the variable DateSelection can be read in the load script and is maintained after reload.

Post reload on the server causes this DateSelection value to return to the QVW saved variable value.

Does this have something to do with the settings "Allow only one copy of document in memory" and/or "Allow session recovery"?

Current settings has one copy of document in memory as enabled and session recovery as disabled.

Re: Maintain variable through reload on QVS

Gysbert_Wassenaar — Thu, 29 Sep 2016 16:52:25 GMT

The OnPostReload trigger doesn't work on the server.

Also, Allow Session Recovery will remember the last document state (i.e. selections) for a user and restore that state the next time the user opens the document.

Re: Maintain variable through reload on QVS

rupamjyotidas — Thu, 29 Sep 2016 16:58:31 GMT

Maye in Script define

Set DateSelection =''Last 7 Days''

This will force the variable to be default after reload.

Re: Maintain variable through reload on QVS

Anonymous — Thu, 29 Sep 2016 17:47:18 GMT

I want the user's time frame selection to remain after reload but it keeps reverting to the document's saved value.

Re: Maintain variable through reload on QVS

rupamjyotidas — Thu, 29 Sep 2016 18:01:32 GMT

Maybe a Inline Table with

FieldName: DateSelection

Values: Last 7 Days, Last 30 Days, Last 90 Days, Last 120 Days, Today, Week To Date, Month To Date, Last 6 Full Months w/ MTD

This would help you to maintain state after User Selection.

You may have to update your equation with 'Select In Field' Action

Re: Maintain variable through reload on QVS

Anonymous — Thu, 29 Sep 2016 19:55:36 GMT

This is a great thought but now I need to figure out how to maintain or reapply those time frame selections post reload because those buttons apply a selection to the created_at time stamp based on the reloadtime(). Need to test what gwassenaar‌ said in that onpostreload does not work.

Re: Maintain variable through reload on QVS

Anonymous — Thu, 29 Sep 2016 20:04:03 GMT

Why not use a bookmark? ,so that Qlikivew will remember all the filter selections made by the users

Re: Maintain variable through reload on QVS

Anonymous — Thu, 29 Sep 2016 20:13:27 GMT

Are you thinking I should apply these selections to a bookmark and the bookmark would maintain the selection post reload on the access point?

Re: Maintain variable through reload on QVS

Anonymous — Thu, 29 Sep 2016 20:25:46 GMT

Hey Nick,

If I understood correctly, your issue is after user making a filter selection and do necessary analysis ,then after some time he opens the dashboard again and the filters are reset as per the saved instance.

So you can ask user to create a bookmark for the filter selection so that he does not need to select all the filters again.

All the other users can still continue to use the generic filters where all the values are available for selection.