topic Re: Caching sheet loading, bookmarks selection and removing unwanted bookmarks from Loop and Reduce apps in App Development

Caching sheet loading, bookmarks selection and removing unwanted bookmarks from Loop and Reduce apps

BVG — Tue, 20 Feb 2024 07:39:07 GMT

Hello everyone,

We recently implemented Loop and Reduce concept in one of our Qlik Sense app and had 3 apps in total (One normal app and 2 Loop and Reduce apps). Now we want to remove unwanted bookmarks from Loop and Reduce apps with out effecting the bookmarks in normal app.

Also looking for caching selections of a particular bookmark and caching of loading objects in a specific sheet once after opening the app (other than first sheet of the app).

Can anyone please let us know the possibilities/challenges in implementing these scenarios?

@theoat @P_Kale @Anil_Babu_Samineni @rwunderlich

Br,

BVG

Re: Caching sheet loading, bookmarks selection and removing unwanted bookmarks from Loop and Reduce apps

Anil_Babu_Samineni — Tue, 20 Feb 2024 09:54:14 GMT

@BVG

#1, IMO that is not possible, But workaround can be to have bookmark less in one application and that can be used for your L&R or you need to call some API's commands to force to not effect into L&R from source application.

#2, Mounting from one sheet to another sheet will give same calculation and same cache because the selections is more matter here, If a user move from one sheet to another sheet and it holds different filters, then definitely it requires an additional mechanism from your Engine memory. More you can read from here: Logical Inference and Aggregations - Qlik Community - 1466049

Re: Caching sheet loading, bookmarks selection and removing unwanted bookmarks from Loop and Reduce apps

BVG — Tue, 20 Feb 2024 14:37:47 GMT

Thanks @Anil_Babu_Samineni. Also can you please let me know the possibility in doing cache warming of a particular bookmark selection?

Re: Caching sheet loading, bookmarks selection and removing unwanted bookmarks from Loop and Reduce apps

rwunderlich — Tue, 20 Feb 2024 15:44:58 GMT

Are you Qlik Cloud or on-prem? What are you using to implement the Loop and Reduce?

-Rob

Re: Caching sheet loading, bookmarks selection and removing unwanted bookmarks from Loop and Reduce apps

Anil_Babu_Samineni — Tue, 20 Feb 2024 19:38:06 GMT

@BVG Please check here: Cache Warming - qs-admin-playbook (qlik-poc.com).

Meaning, the batch script need to be create and immediately to reload of qlik sense app the batch can run to save cache inline memory for user selections, So the bookmark filters that using can be used to below command line.

Re: Caching sheet loading, bookmarks selection and removing unwanted bookmarks from Loop and Reduce apps

BVG — Wed, 21 Feb 2024 07:27:26 GMT

Hi @rwunderlich,

We are using Qlik cloud for Loop and Reduce implementation.

Br,

BVG

Re: Caching sheet loading, bookmarks selection and removing unwanted bookmarks from Loop and Reduce apps

BVG — Wed, 21 Feb 2024 07:32:47 GMT

Hi @Anil_Babu_Samineni ,

Thanks for your support and guidance.

I will check with the team who is working on batch scripts and try to implement the same.

Br,

BVG