Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
Maye in Script define
Set DateSelection =''Last 7 Days''
This will force the variable to be default after reload.
I want the user's time frame selection to remain after reload but it keeps reverting to the document's saved value.
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
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.
Why not use a bookmark? ,so that Qlikivew will remember all the filter selections made by the users
Are you thinking I should apply these selections to a bookmark and the bookmark would maintain the selection post reload on the access point?
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.