topic Re: Combine reported dimension rows in straight table in QlikView https://community.qlik.com/t5/QlikView/Combine-reported-dimension-rows-in-straight-table/m-p/1296664#M404665 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P>Calculated Dimension</P><P><STRONG>If(Match(errorType, 'Critical', 'High'), 'High &amp; Crit',</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(Match(errorType, 'Med'), 'Med', 'Other'))</STRONG></P><P></P><P>Expression</P><P><STRONG>Count(error)</STRONG></P></BODY></HTML> Wed, 26 Jul 2017 15:33:23 GMT sunny_talwar 2017-07-26T15:33:23Z Combine reported dimension rows in straight table https://community.qlik.com/t5/QlikView/Combine-reported-dimension-rows-in-straight-table/m-p/1296663#M404664 <HTML><HEAD></HEAD><BODY><P>I have a straight table showing the number of errors</P><P></P><P>Critical | 4</P><P>High&nbsp;&nbsp;&nbsp; | 6</P><P>Med&nbsp;&nbsp;&nbsp;&nbsp; | 3</P><P>Low&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 2</P><P>Pass&nbsp;&nbsp;&nbsp; | 20</P><P></P><P></P><P>Dimension is errorType, Expression is Count of error.</P><P></P><P>How do I combine rows to end up with:</P><P></P><P>High &amp; Crit | 10</P><P>Med | 3</P><P>Other | 22</P></BODY></HTML> Wed, 26 Jul 2017 15:30:30 GMT https://community.qlik.com/t5/QlikView/Combine-reported-dimension-rows-in-straight-table/m-p/1296663#M404664 nickedw0 2017-07-26T15:30:30Z Re: Combine reported dimension rows in straight table https://community.qlik.com/t5/QlikView/Combine-reported-dimension-rows-in-straight-table/m-p/1296664#M404665 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P>Calculated Dimension</P><P><STRONG>If(Match(errorType, 'Critical', 'High'), 'High &amp; Crit',</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; If(Match(errorType, 'Med'), 'Med', 'Other'))</STRONG></P><P></P><P>Expression</P><P><STRONG>Count(error)</STRONG></P></BODY></HTML> Wed, 26 Jul 2017 15:33:23 GMT https://community.qlik.com/t5/QlikView/Combine-reported-dimension-rows-in-straight-table/m-p/1296664#M404665 sunny_talwar 2017-07-26T15:33:23Z