Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

deepaktibhe
Valued Contributor

Simple reduce vs loop and reduce

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Simple reduce vs loop and reduce

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.

6 Replies
deepaktibhe
Valued Contributor

Re: Simple reduce vs loop and reduce

Hello all,

Can u plz help me out on this.

Thanks

MVP
MVP

Re: Simple reduce vs loop and reduce

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.

deepaktibhe
Valued Contributor

Re: Simple reduce vs loop and reduce

Hi Tesco,

Thanks for your prompt response.

Can you please give me some example on this.

Thanks

MVP
MVP

Re: Simple reduce vs loop and reduce

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.

deepaktibhe
Valued Contributor

Re: Simple reduce vs loop and reduce

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

MVP
MVP

Re: Simple reduce vs loop and reduce

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