topic Re: QlikView cache, variables in QlikView

QlikView cache, variables

Sun, 26 Feb 2017 09:20:48 GMT

Hi All,

I have below questions

1) When we do any selection, qlikview stores that into cache, next day when reload happens and new data added, cache results stored before will work?

2) When I open the application on access point, variables gets calculated?

Re: QlikView cache, variables

marcus_sommer — Sun, 26 Feb 2017 12:01:29 GMT

1) A reload will clear the selections-cache because the datamodel will be change.

2) I would say yes but it might depend on how opening is defined and where the variable reside and what should be calculated - is there any issue with it?

- Marcus

Re: QlikView cache, variables

rwunderlich — Sun, 26 Feb 2017 22:15:07 GMT

1) Cached results remain until storage is required for newer entries and then older cached entries are rolled out. A chart calculation will use a cached entry if it uses the same Dimension(s), Expression and selected data as a result in the cache. It's possible for previously cached results to be used after a reload. For example, assume we are in 2017. User selects 2016 to see previous year, results are cached. Overnight, reload adds more data for 2017. If user selects 2016 in the updated app, the 2016 cached results are still valid.

It's even possible for cache results to be used between apps.

2) My understanding is that variables are calculated only when they are referenced. That said, I think I've seen circumstances where variables defined with "=" are calculated even when not referenced on the current sheet. I have not been able to recreate this though.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: QlikView cache, variables

Sat, 04 Mar 2017 09:50:17 GMT

Thanks marcus.

I have created the variable with "=" and they are many, so do they cause opening the application issue on access point? Currently I am opening the application with saved page as blank sheet (no objects), though it takes a lot of time to open application.

Re: QlikView cache, variables

Sat, 04 Mar 2017 09:50:49 GMT

Thanks for your response rob.

Re: QlikView cache, variables

marcus_sommer — Mon, 06 Mar 2017 08:02:11 GMT

I think the variables could have an impact on the opening times and the performance even on a blank sheet because the variables belong to the whole document and not to a single sheet.

- Marcus