topic blank row in pivot table in App Development https://community.qlik.com/t5/App-Development/blank-row-in-pivot-table/m-p/84654#M5644 <HTML><HEAD></HEAD><BODY><P>I have this kind of data in table .. in script i megerd two fields like this </P><P></P><P>[HeadMAIN]&amp;'.'&amp;[SUBCLASS] as Merged</P><P></P><P>column1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; column2</P><P>Product.P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>Product.P2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P>Product.P3&nbsp;&nbsp;&nbsp;&nbsp; 124</P><P>Product.P4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234&nbsp;&nbsp;&nbsp; </P><P>Catergory.C1&nbsp;&nbsp; 12</P><P>Catergory.C2&nbsp;&nbsp;&nbsp; 94</P><P>Catergory.C3&nbsp;&nbsp;&nbsp;&nbsp; 54</P><P>Catergory.C4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P></P><P>now i want to get one additional blank row after each headmain&nbsp; how i do this </P><P>column1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; column2</P><P>Product.P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>Product.P2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P>Product.P3&nbsp;&nbsp;&nbsp;&nbsp; 124</P><P>Product.P4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P><STRONG>Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG></P><P>Catergory.C1&nbsp;&nbsp; 12</P><P>Catergory.C2&nbsp;&nbsp;&nbsp; 94</P><P>Catergory.C3&nbsp;&nbsp;&nbsp;&nbsp; 54</P><P>Catergory.C4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45</P><P><STRONG>Category&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG></P></BODY></HTML> Mon, 26 Mar 2018 05:53:49 GMT capriconuser 2018-03-26T05:53:49Z blank row in pivot table https://community.qlik.com/t5/App-Development/blank-row-in-pivot-table/m-p/84654#M5644 <HTML><HEAD></HEAD><BODY><P>I have this kind of data in table .. in script i megerd two fields like this </P><P></P><P>[HeadMAIN]&amp;'.'&amp;[SUBCLASS] as Merged</P><P></P><P>column1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; column2</P><P>Product.P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>Product.P2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P>Product.P3&nbsp;&nbsp;&nbsp;&nbsp; 124</P><P>Product.P4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234&nbsp;&nbsp;&nbsp; </P><P>Catergory.C1&nbsp;&nbsp; 12</P><P>Catergory.C2&nbsp;&nbsp;&nbsp; 94</P><P>Catergory.C3&nbsp;&nbsp;&nbsp;&nbsp; 54</P><P>Catergory.C4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P></P><P>now i want to get one additional blank row after each headmain&nbsp; how i do this </P><P>column1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; column2</P><P>Product.P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>Product.P2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P>Product.P3&nbsp;&nbsp;&nbsp;&nbsp; 124</P><P>Product.P4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 234</P><P><STRONG>Product&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG></P><P>Catergory.C1&nbsp;&nbsp; 12</P><P>Catergory.C2&nbsp;&nbsp;&nbsp; 94</P><P>Catergory.C3&nbsp;&nbsp;&nbsp;&nbsp; 54</P><P>Catergory.C4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 45</P><P><STRONG>Category&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </STRONG></P></BODY></HTML> Mon, 26 Mar 2018 05:53:49 GMT https://community.qlik.com/t5/App-Development/blank-row-in-pivot-table/m-p/84654#M5644 capriconuser 2018-03-26T05:53:49Z