Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
manoj217
Creator III
Creator III

loop and reduce

how to do loop and reduce in qlikview desktop level

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Manoj,

Loop and reduce is a functionality of Qlik View Publisher, it is not available in Qlikview Desktop.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jaumecf23
Creator III
Creator III

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 -> Reduce Data -> 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.

The problem of this method is that you will need to go Country by Country.

The best way is to have a publisher to do loop and reduce.