topic Re: Straight table chart with customized rows. in QlikView https://community.qlik.com/t5/QlikView/Straight-table-chart-with-customized-rows/m-p/786851#M278363 <HTML><HEAD></HEAD><BODY><P>Hi there.</P><P></P><P>See QVW attached.</P><P></P><P>Kind regards,</P><P>Ernesto.</P></BODY></HTML> Fri, 05 Dec 2014 20:28:23 GMT consenit 2014-12-05T20:28:23Z Straight table chart with customized rows. https://community.qlik.com/t5/QlikView/Straight-table-chart-with-customized-rows/m-p/786850#M278362 <HTML><HEAD></HEAD><BODY><P>I am trying to create a straight table which has an added row showing the subset of the top rows filtered by Geo. I am trying to show the product and its quantity sold with an additional row showing just the canadian number. I tried using a calculated dimension with if(geo='Canada', 'Canada', Product) obviously I don't get the result I expect to see.</P><P></P><P>Expected Result:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="128"><TBODY><TR><TD height="20" width="64">Product</TD><TD width="64">Quantity</TD></TR><TR><TD height="20">A</TD><TD align="right">1</TD></TR><TR><TD height="20">B</TD><TD align="right">2</TD></TR><TR><TD height="20">C</TD><TD align="right">3</TD></TR><TR><TD height="20">Canada</TD><TD align="right">2</TD></TR></TBODY></TABLE><P></P><P>Result Obtained:</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 128px;"><TBODY><TR><TD height="20" width="64">Product</TD><TD width="64">Quantity</TD></TR><TR><TD height="20">A</TD><TD align="right">1</TD></TR><TR><TD height="20">B</TD><TD align="right">1</TD></TR><TR><TD height="20">C</TD><TD align="right">2</TD></TR><TR><TD height="20">Canada</TD><TD align="right">2</TD></TR></TBODY></TABLE><P>Any help is appreciated. </P><P></P><P>Thank you</P><P>Suraj</P></BODY></HTML> Fri, 05 Dec 2014 17:17:49 GMT https://community.qlik.com/t5/QlikView/Straight-table-chart-with-customized-rows/m-p/786850#M278362 2014-12-05T17:17:49Z Re: Straight table chart with customized rows. https://community.qlik.com/t5/QlikView/Straight-table-chart-with-customized-rows/m-p/786851#M278363 <HTML><HEAD></HEAD><BODY><P>Hi there.</P><P></P><P>See QVW attached.</P><P></P><P>Kind regards,</P><P>Ernesto.</P></BODY></HTML> Fri, 05 Dec 2014 20:28:23 GMT https://community.qlik.com/t5/QlikView/Straight-table-chart-with-customized-rows/m-p/786851#M278363 consenit 2014-12-05T20:28:23Z