Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
BVG
Contributor II
Contributor II

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

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

Labels (1)
1 Solution

Accepted Solutions
Anil_Babu_Samineni

@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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

6 Replies
Anil_Babu_Samineni

@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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
BVG
Contributor II
Contributor II
Author

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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. 

Anil_Babu_Samineni_0-1708457808174.png

 

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
BVG
Contributor II
Contributor II
Author

Hi @rwunderlich,

We are using Qlik cloud for Loop and Reduce implementation.

 

Br,

BVG

BVG
Contributor II
Contributor II
Author

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