topic Re: Merging rows in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Merging-rows-in-Pivot-table/m-p/1070913#M924589 <HTML><HEAD></HEAD><BODY><P>Can you please check your screenshots, I can't see any image.</P><P></P><P>Maybe you are using links to images that can't be accessed by unauthorized users.</P><P></P><P>If possible, please also post a small sample QVW.</P></BODY></HTML> Thu, 07 Apr 2016 17:26:47 GMT swuehl 2016-04-07T17:26:47Z Merging rows in Pivot table https://community.qlik.com/t5/QlikView/Merging-rows-in-Pivot-table/m-p/1070912#M924588 <HTML><HEAD></HEAD><BODY><P>Would like to merge cells in Pivot table, sample design attached below for reference. </P><P></P><P>Basic Pivot design:</P><P></P><P><IMG alt="Pivot_design.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/120813_Pivot_design.png" style="height: 116px; width: 620px;" /></P><P></P><P>Requirement is to merge cells and expected to design like, </P><P><IMG alt="Expected_Design.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/120814_Expected_Design.png" style="height: 66px; width: 620px;" /></P><P>Would like keep Abc - Total &amp; Fun - Total expressions as columns and not to show duplicate for each rows. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Merging-rows-in-Pivot-table/m-p/1070912#M924588 2020-11-25T16:16:04Z Re: Merging rows in Pivot table https://community.qlik.com/t5/QlikView/Merging-rows-in-Pivot-table/m-p/1070913#M924589 <HTML><HEAD></HEAD><BODY><P>Can you please check your screenshots, I can't see any image.</P><P></P><P>Maybe you are using links to images that can't be accessed by unauthorized users.</P><P></P><P>If possible, please also post a small sample QVW.</P></BODY></HTML> Thu, 07 Apr 2016 17:26:47 GMT https://community.qlik.com/t5/QlikView/Merging-rows-in-Pivot-table/m-p/1070913#M924589 swuehl 2016-04-07T17:26:47Z Re: Merging rows in Pivot table https://community.qlik.com/t5/QlikView/Merging-rows-in-Pivot-table/m-p/1070914#M924590 <HTML><HEAD></HEAD><BODY><P>Plz check now. Attached the screenshot..I did the design in Excel to share with this group. I dont have any QVW file.</P></BODY></HTML> Thu, 07 Apr 2016 17:41:46 GMT https://community.qlik.com/t5/QlikView/Merging-rows-in-Pivot-table/m-p/1070914#M924590 2016-04-07T17:41:46Z Re: Merging rows in Pivot table https://community.qlik.com/t5/QlikView/Merging-rows-in-Pivot-table/m-p/1070915#M924591 <HTML><HEAD></HEAD><BODY><P>That's not possible. You can try calculated dimensions instead of expressions, but then they would show up on with the other dimensions on the left side of the pivot table. A calculated dimension would look something like <EM>=aggr( ...original_expression_here... , Col1, Col2, Col3, Col4). </EM></P></BODY></HTML> Fri, 08 Apr 2016 08:16:28 GMT https://community.qlik.com/t5/QlikView/Merging-rows-in-Pivot-table/m-p/1070915#M924591 Gysbert_Wassenaar 2016-04-08T08:16:28Z