topic Macro possibly needed? in QlikView https://community.qlik.com/t5/QlikView/Macro-possibly-needed/m-p/1244612#M857312 <HTML><HEAD></HEAD><BODY><P>So my app has</P><P></P><P>&lt;ch1&gt;</P><P>Dimension: Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression:Year</P><P></P><P>&lt;ch2&gt;</P><P>Dimension: Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression: Year Month</P><P></P><P>&lt;ch3&gt;</P><P>Dimension: Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression: Year Week</P><P></P><P></P><P>App loads fine. I then put this into an nPrinting report</P><P>What I want to appear is without repetive dimensions:</P><P></P><P>Row A:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column O&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column BO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression</P><P>Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YearMonth&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YearWeek&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year</P><P></P><P>If I use nPrinting to bring in the charts, the dimensions will come along with these charts. I only want the dimension in Column A</P><P></P><P>Is there a&nbsp; way in nPrinting that on completion of the generation of the nPrinting report of the above, that a macro could delete the dimension of Column O and Column BO and only leave the details of the expression.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bobbydave 2020-11-25T16:16:04Z Macro possibly needed? https://community.qlik.com/t5/QlikView/Macro-possibly-needed/m-p/1244612#M857312 <HTML><HEAD></HEAD><BODY><P>So my app has</P><P></P><P>&lt;ch1&gt;</P><P>Dimension: Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression:Year</P><P></P><P>&lt;ch2&gt;</P><P>Dimension: Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression: Year Month</P><P></P><P>&lt;ch3&gt;</P><P>Dimension: Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression: Year Week</P><P></P><P></P><P>App loads fine. I then put this into an nPrinting report</P><P>What I want to appear is without repetive dimensions:</P><P></P><P>Row A:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column O&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column BO&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>Dimension&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression</P><P>Region&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YearMonth&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; YearWeek&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Year</P><P></P><P>If I use nPrinting to bring in the charts, the dimensions will come along with these charts. I only want the dimension in Column A</P><P></P><P>Is there a&nbsp; way in nPrinting that on completion of the generation of the nPrinting report of the above, that a macro could delete the dimension of Column O and Column BO and only leave the details of the expression.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Macro-possibly-needed/m-p/1244612#M857312 bobbydave 2020-11-25T16:16:04Z