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: 
Anonymous
Not applicable

Maintain variable through reload on QVS

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.

8 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
rupamjyotidas
Specialist
Specialist

Maye in Script define

Set DateSelection =''Last 7 Days''

This will force the variable to be default after reload.

Anonymous
Not applicable
Author

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

rupamjyotidas
Specialist
Specialist

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

Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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

Anonymous
Not applicable
Author

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.