Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Sep 29, 2022 3:29:02 AM
Mar 14, 2022 5:17:20 AM
Note: loop and reduce will remove an app's section access that was defined through the load script. Offline usage needs to be enabled in your tenant's management console in order to use the Loop And Reduce block on an app outside a personal space. More information on offline usage.
You might have noticed that it is not possible to perform a loop and reduce operation on apps that contain fields with the Always One Selected Value property set to true.
We've now released a new block, Set Always One Selected Value Field Property in Qlik Application Automation that allows you to manage this setting for individual fields.
The general idea is that you use this block to disable this property on all fields in the source app before executing the Loop And Reduce block. When the loop and reduce operation is completed, you can execute another instance of this block to set the Always One Selected Value property back to true.
The following example is a practical application of this idea. The scenario is as follows: the source app has one field (Country) that has the Always One Selected Value property set to "true". This is also the field we want to reduce on during the loop and reduce operation.
Before you begin this example, make sure you have a basic loop and reduce automation that uses the blocks Loop And Reduce and Publish Reduced App To Managed Space. If you have no experience with these blocks, take a look at this article or get started with the "Loop, reduce and distribute an app" template that you can find in the automations template picker in Qlik Sense SaaS. In this article, we'll start with the following example:
Steps:
That's it! We'll continue to build upon this automation in the next example were the source app contains multiple fields with the Always One Selected Value property set to true.
In this example, the app has multiple (two) fields that have the Always One Selected Value property set to true: "Country" and "Year". We still want to reduce on Country as in the previous example, but we'll also have to disable this for the Year field before performing the loop and reduce operation. The reason for this is that the Year field will always have a selection applied which limits the amount of available data for the loop and reduce process. If we don't change this property for the Year field, all data that was not included in the selected Year before reduction, will not be available in the reduced apps.
We'll start this example where the previous example ended:
The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.