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

[BVG]

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

[Anil_Babu_Samineni · Accepted solution]

@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

[BVG]

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

[rwunderlich]

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

-Rob

[Anil_Babu_Samineni]

@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. 

[BVG]

Hi @rwunderlich,

We are using Qlik cloud for Loop and Reduce implementation.

Br,

BVG

[BVG]

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