topic Re: Merging rows in a straight table in QlikView https://community.qlik.com/t5/QlikView/Merging-rows-in-a-straight-table/m-p/1311634#M847574 <HTML><HEAD></HEAD><BODY><P>What is the issue here?</P><P>Use straight table,</P><P></P><P>Dim: Header1</P><P>expr: Sum(Header2) </P><P></P><P>Then for expr in expression tab use No Totals from the Total Mode you can see that in bottom right corner .</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158340_Capture1.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 30 Mar 2017 16:08:05 GMT vishsaggi 2017-03-30T16:08:05Z Merging rows in a straight table https://community.qlik.com/t5/QlikView/Merging-rows-in-a-straight-table/m-p/1311633#M847573 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>I have the following requirement which I need to complete. It is :</P><P></P><P>I have the following straight table :</P><P></P><TABLE border="1" class="jiveBorder" height="174" style="border: 1px solid rgb(0, 0, 0); width: 247px; height: 125px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">10</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">25</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">40</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">50</TD></TR></TBODY></TABLE><P></P><P>I need the output as </P><P></P><TABLE border="1" class="jiveBorder" height="149" style="border: 1px solid rgb(0, 0, 0); width: 274px; height: 114px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH></TR><TR><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">77</TD></TR><TR><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">80</TD></TR><TR><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">15</TD></TR><TR><TD style="padding: 2px;">D</TD><TD style="padding: 2px;">30</TD></TR></TBODY></TABLE><P></P><P>where header 1 is a dimension and header 2 values are measures. </P><P>And values of all the measures are either stored in variables or&nbsp; expressions in another part of staging. </P><P></P><P>How to do that?</P><P></P><P>Please share your thoughts.@</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Merging-rows-in-a-straight-table/m-p/1311633#M847573 2020-11-25T16:16:04Z Re: Merging rows in a straight table https://community.qlik.com/t5/QlikView/Merging-rows-in-a-straight-table/m-p/1311634#M847574 <HTML><HEAD></HEAD><BODY><P>What is the issue here?</P><P>Use straight table,</P><P></P><P>Dim: Header1</P><P>expr: Sum(Header2) </P><P></P><P>Then for expr in expression tab use No Totals from the Total Mode you can see that in bottom right corner .</P><P></P><P><IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/158340_Capture1.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 30 Mar 2017 16:08:05 GMT https://community.qlik.com/t5/QlikView/Merging-rows-in-a-straight-table/m-p/1311634#M847574 vishsaggi 2017-03-30T16:08:05Z