topic Grouping data in the straight chart in QlikView https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938343#M323758 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find the attached xls and qvw files. Please help how can I group the data based on area.</P><P>( I don't want to use Pivot table)</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="778"><TBODY><TR><TD class="oa1" height="40" rowspan="2" width="363"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">Supportability</SPAN></P></TD><TD class="oa1" width="416"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">All asset documents updated but not uploaded </SPAN></P></TD></TR><TR><TD class="oa1" height="20" width="416"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">System Portal up-to-date.</SPAN></P></TD></TR><TR><TD class="oa1" height="40" width="363"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">Risks/Security</SPAN></P></TD><TD class="oa1" width="416"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">All STP standards are met</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 04 Nov 2015 19:07:42 GMT 2015-11-04T19:07:42Z Grouping data in the straight chart https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938343#M323758 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find the attached xls and qvw files. Please help how can I group the data based on area.</P><P>( I don't want to use Pivot table)</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="778"><TBODY><TR><TD class="oa1" height="40" rowspan="2" width="363"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">Supportability</SPAN></P></TD><TD class="oa1" width="416"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">All asset documents updated but not uploaded </SPAN></P></TD></TR><TR><TD class="oa1" height="20" width="416"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">System Portal up-to-date.</SPAN></P></TD></TR><TR><TD class="oa1" height="40" width="363"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">Risks/Security</SPAN></P></TD><TD class="oa1" width="416"><P style="text-align: left;"><SPAN style="font-family: Arial; color: black; font-size: 11pt;">All STP standards are met</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 04 Nov 2015 19:07:42 GMT https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938343#M323758 2015-11-04T19:07:42Z Re: Grouping data in the straight chart https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938344#M323759 <HTML><HEAD></HEAD><BODY><P>I can do it in pivot table if I check "always fully expandable" but i want to do it in the staright table</P></BODY></HTML> Wed, 04 Nov 2015 19:10:24 GMT https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938344#M323759 2015-11-04T19:10:24Z Re: Grouping data in the straight chart https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938345#M323760 <HTML><HEAD></HEAD><BODY><P>Please, go to Dimensions Limits tab</P><P>Select 2nd dimension and check "show total"</P></BODY></HTML> Wed, 04 Nov 2015 19:21:10 GMT https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938345#M323760 Clever_Anjos 2015-11-04T19:21:10Z Re: Grouping data in the straight chart https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938346#M323761 <HTML><HEAD></HEAD><BODY><P>Is it possible in table box?</P></BODY></HTML> Thu, 05 Nov 2015 05:17:42 GMT https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938346#M323761 2015-11-05T05:17:42Z Re: Grouping data in the straight chart https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938347#M323762 <HTML><HEAD></HEAD><BODY><P>No, a table box is a very simple object.</P><P>It doesn´t allow aggregations, etc</P></BODY></HTML> Thu, 05 Nov 2015 12:14:08 GMT https://community.qlik.com/t5/QlikView/Grouping-data-in-the-straight-chart/m-p/938347#M323762 Clever_Anjos 2015-11-05T12:14:08Z