topic Re: Simple reduce vs loop and reduce in QlikView

Simple reduce vs loop and reduce

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

What is difference between simple reduce and loop and reduce in qlikview publisher.

Thanks,

Deepak

Re: Simple reduce vs loop and reduce

Luis_Cortizo — Thu, 10 Apr 2014 17:07:48 GMT

The output of the Simple Reduce is a published QlikView document with only the data that you have selected on the Simple Reduce options.

If you do a Loop And Reduce and select the Year field (for instance), assuming that you have three years loaded on your application (2014, 2013 and 2012) you would have three different published QlikView documents. One with information of 2014, another one with information of 2013 and another on with information of 2012.

Hope it helps.

Best regards.

Re: Simple reduce vs loop and reduce

Thu, 10 Apr 2014 21:02:05 GMT

check this tutorial by Qlik: QlikView Security Video Series (5 of 8): Reduce and Loop by NT Username - YouTube

Re: Simple reduce vs loop and reduce

deepakqlikview_123 — Fri, 11 Apr 2014 04:29:48 GMT

Hello Luis,

Thanks for reply.

You mean in simple reduce if we select year field having year 2012,2013,2014 it will create 1 document only while loop and reduce it will create separate document for each year is it.

Moreover also the document what we got as a output is in QVW format.

Thanks,

Deepak