topic Re: Loop and reduce in Qlik Automate

Loop and reduce

rbarboza — Wed, 26 Jun 2024 19:13:15 GMT

Good afternoon, is there a way to reduce an application from a condition. 
For example, reduce the sales application by the country field where country is equal to Argentina and Chile. 
Use the Loop and reduce block. But I don't know how to add a condition to filter by two countries.
Thank you.-

Re: Loop and reduce

Shai_E — Fri, 28 Jun 2024 09:46:14 GMT

Hi @rbarboza

What if you do the following:

1. Loop And Reduce the app using the "Loop And Reduce" block
2. Inside the loop use a "Condition" block
3. Have the Condition block setup as follows:

If reduced values equals to Argentina and If reduced values equals Chile

4. if the expression in point 3 is true, use the "Publish Reduced App To Managed Space"

Please note i think this wont stop the loop from looping through all field values.

A better way might be to store these two countries in an array and each time the condition is true, pop off one of the countries from the array, when the array is clear use a stop block to maybe stope the automation

Re: Loop and reduce

rbarboza — Mon, 01 Jul 2024 19:17:23 GMT

Thank you so much. From what I understand, the result would be two applications, one with each country filtered. And what I'm looking for is a single application with the two countries filtered.