Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

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
tresesco
MVP
MVP

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.

View solution in original post

6 Replies
deepakqlikview_123
Specialist
Specialist
Author

Hello all,

Can u plz help me out on this.

Thanks

tresesco
MVP
MVP

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.

deepakqlikview_123
Specialist
Specialist
Author

Hi Tesco,

Thanks for your prompt response.

Can you please give me some example on this.

Thanks

tresesco
MVP
MVP

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.

deepakqlikview_123
Specialist
Specialist
Author

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

tresesco
MVP
MVP

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