topic Re: loop and reduce in QlikView https://community.qlik.com/t5/QlikView/loop-and-reduce/m-p/37589#M786959 <HTML><HEAD></HEAD><BODY><P>Maybe you can do it manually. For example if you want to loop and reduce for the field Country. Select the first country that you want to reduce in your application and then go to File -&gt; Reduce Data -&gt; Keep Possible values. Now with this option the data model has been reduced only with the selected selections, in your case the Country information. To not override the file, save the file with a new name, something like FileName_CountryName.qvw.</P><P>The problem of this method is that you will need to go Country by Country. </P><P>The best way is to have a publisher to do loop and reduce.</P></BODY></HTML> Fri, 16 Feb 2018 11:07:22 GMT jaumecf23 2018-02-16T11:07:22Z loop and reduce https://community.qlik.com/t5/QlikView/loop-and-reduce/m-p/37587#M786957 <HTML><HEAD></HEAD><BODY><P>how to do loop and reduce in qlikview desktop level</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/loop-and-reduce/m-p/37587#M786957 manoj217 2020-11-25T16:16:04Z Re: loop and reduce https://community.qlik.com/t5/QlikView/loop-and-reduce/m-p/37588#M786958 <HTML><HEAD></HEAD><BODY><P>Hi Manoj,</P><P></P><P>Loop and reduce is a functionality of Qlik View Publisher, it is not available in Qlikview Desktop.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Fri, 16 Feb 2018 09:33:54 GMT https://community.qlik.com/t5/QlikView/loop-and-reduce/m-p/37588#M786958 kaushiknsolanki 2018-02-16T09:33:54Z Re: loop and reduce https://community.qlik.com/t5/QlikView/loop-and-reduce/m-p/37589#M786959 <HTML><HEAD></HEAD><BODY><P>Maybe you can do it manually. For example if you want to loop and reduce for the field Country. Select the first country that you want to reduce in your application and then go to File -&gt; Reduce Data -&gt; Keep Possible values. Now with this option the data model has been reduced only with the selected selections, in your case the Country information. To not override the file, save the file with a new name, something like FileName_CountryName.qvw.</P><P>The problem of this method is that you will need to go Country by Country. </P><P>The best way is to have a publisher to do loop and reduce.</P></BODY></HTML> Fri, 16 Feb 2018 11:07:22 GMT https://community.qlik.com/t5/QlikView/loop-and-reduce/m-p/37589#M786959 jaumecf23 2018-02-16T11:07:22Z