topic Re: New to Qlikview in QlikView https://community.qlik.com/t5/QlikView/New-to-Qlikview/m-p/877509#M994918 <HTML><HEAD></HEAD><BODY><P>You want this in a chart?</P><P></P><P>Just create a straight table chart with dimension Category and a single expression:</P><P>=Sum([Market Value])</P></BODY></HTML> Fri, 03 Jul 2015 15:20:20 GMT swuehl 2015-07-03T15:20:20Z New to Qlikview https://community.qlik.com/t5/QlikView/New-to-Qlikview/m-p/877508#M994917 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a field called Category and under this i have duplicate data like</P><P></P><P>Category&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Market Value</P><P>Level 1 Assets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 43395</P><P>Level 1 Assets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 96387</P><P>Level 1 Assets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 44997</P><P>Level 2 Assets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14360</P><P>Level 2 Assets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 34885</P><P>Level 2 Assets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 78013</P><P>Non-Qualifying Assets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12096</P><P>Non-Qualifying Assets&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28817</P><P></P><P>I want my output in qlikview as</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="211"><TBODY><TR><TD height="20" width="147">Category</TD><TD width="64">Total</TD></TR><TR><TD height="20">Level 1 Assets</TD><TD align="right">184779</TD></TR><TR><TD height="20">Level 2 Assets</TD><TD align="right">127258</TD></TR><TR><TD height="20">Non-Qualifying Assets</TD><TD align="right">40913</TD></TR></TBODY></TABLE><P></P><P>Here the total is sum of all Level 1 assets.</P><P></P><P>Please help me out how to do it in qlikview</P></BODY></HTML> Fri, 03 Jul 2015 11:13:24 GMT https://community.qlik.com/t5/QlikView/New-to-Qlikview/m-p/877508#M994917 srujanaponnuru 2015-07-03T11:13:24Z Re: New to Qlikview https://community.qlik.com/t5/QlikView/New-to-Qlikview/m-p/877509#M994918 <HTML><HEAD></HEAD><BODY><P>You want this in a chart?</P><P></P><P>Just create a straight table chart with dimension Category and a single expression:</P><P>=Sum([Market Value])</P></BODY></HTML> Fri, 03 Jul 2015 15:20:20 GMT https://community.qlik.com/t5/QlikView/New-to-Qlikview/m-p/877509#M994918 swuehl 2015-07-03T15:20:20Z Re: New to Qlikview https://community.qlik.com/t5/QlikView/New-to-Qlikview/m-p/877510#M994919 <HTML><HEAD></HEAD><BODY><P>Thanks a lot</P></BODY></HTML> Fri, 03 Jul 2015 15:22:46 GMT https://community.qlik.com/t5/QlikView/New-to-Qlikview/m-p/877510#M994919 srujanaponnuru 2015-07-03T15:22:46Z