topic Reduce by field in QlikView https://community.qlik.com/t5/QlikView/Reduce-by-field/m-p/125521#M1248102 <HTML><HEAD></HEAD><BODY><P>We have a table that shows metrics for the top 10 sub-categories.&nbsp; We have 10 categories.&nbsp; We want to distribute a report through the Qlikview Management Console that has one table per category.&nbsp; One option is to use set analysis to create 10 tables showing the top 10 sub-categories per category.&nbsp; I would prefer to create one table instead of 10.&nbsp; Is there a way, in one pdf, to loop through the category dimension so that it just uses the same table and just replicates it?&nbsp; Even if it is 10 pages, that would be better than sending out 10 documents.&nbsp; I hope that makes sense!&nbsp; Thank you!</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT lfholland 2026-01-26T18:19:17Z Reduce by field https://community.qlik.com/t5/QlikView/Reduce-by-field/m-p/125521#M1248102 <HTML><HEAD></HEAD><BODY><P>We have a table that shows metrics for the top 10 sub-categories.&nbsp; We have 10 categories.&nbsp; We want to distribute a report through the Qlikview Management Console that has one table per category.&nbsp; One option is to use set analysis to create 10 tables showing the top 10 sub-categories per category.&nbsp; I would prefer to create one table instead of 10.&nbsp; Is there a way, in one pdf, to loop through the category dimension so that it just uses the same table and just replicates it?&nbsp; Even if it is 10 pages, that would be better than sending out 10 documents.&nbsp; I hope that makes sense!&nbsp; Thank you!</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Reduce-by-field/m-p/125521#M1248102 lfholland 2026-01-26T18:19:17Z Re: Reduce by field https://community.qlik.com/t5/QlikView/Reduce-by-field/m-p/125522#M1248105 <HTML><HEAD></HEAD><BODY><P>I finally came across this for anyone else that has this questions. </P><P>Edit Reports &gt; Report Settings &gt; Selections &gt; Banding</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/212272_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 30 Aug 2018 19:38:50 GMT https://community.qlik.com/t5/QlikView/Reduce-by-field/m-p/125522#M1248105 lfholland 2018-08-30T19:38:50Z