topic Simple reduce vs loop and reduce in QlikView

Simple reduce vs loop and reduce

deepakqlikview_123 — Mon, 26 Jan 2026 18:19:17 GMT

Hi All,

Can u plz tell me the difference between simple reduce and loop and reduce.in which cases we can choose what to use.

Thanks

Re: Simple reduce vs loop and reduce

deepakqlikview_123 — Mon, 26 May 2014 04:23:15 GMT

Hello all,

Can u plz help me out on this.

Thanks

Re: Simple reduce vs loop and reduce

tresB — Mon, 26 May 2014 04:32:24 GMT

In simple reduce you get to select specific values from a field and reduce on them. Whereas, in loop and reduce, reduction is done on each value of the selected field.

Re: Simple reduce vs loop and reduce

deepakqlikview_123 — Mon, 26 May 2014 04:55:50 GMT

Hi Tesco,

Thanks for your prompt response.

Can you please give me some example on this.

Thanks

Re: Simple reduce vs loop and reduce

tresB — Mon, 26 May 2014 05:12:28 GMT

Say, you have field Country with values - US, UK, Spain, .... (100 such). Now you want to distribute your application to two users for US and UK. For this if use use Simple Reduce for Country field, select UK and US and reduce on them. You would get two reduced applications, one for US and another for UK. If you select Loop and Reduce - that would generate 100 reduced applications for each country. So for this scenario- first option is desired. Hope this helps you conprehend.

Re: Simple reduce vs loop and reduce

deepakqlikview_123 — Mon, 26 May 2014 05:15:47 GMT

Thanks Tresco,

Except above mentioned difference.

In both simple and loop and reduce we are able to mail application to users,and save document to target place,is it.

Please correct me if I am wrong.

Thanks

Re: Simple reduce vs loop and reduce

tresB — Mon, 26 May 2014 05:30:09 GMT

Yes. However, that is more about Distribution rather than Reduction.