topic Totals in Chart Question in QlikView https://community.qlik.com/t5/QlikView/Totals-in-Chart-Question/m-p/229155#M81108 <HTML><HEAD></HEAD><BODY><P>I don't think this is possible the way you are creating the chart with multiple dimensions. I would be interested to see a solution by someone.</P></BODY></HTML> Wed, 03 Feb 2010 04:37:41 GMT disqr_rm 2010-02-03T04:37:41Z Totals in Chart Question https://community.qlik.com/t5/QlikView/Totals-in-Chart-Question/m-p/229154#M81107 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I'm new to Qlikview. I just started by creating a basic chart in Qlikview.</P><P></P><P>My Data looks like this:</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />HEAD SECTION VALUE PERIOD NAME MONTH YEAR<BR />-------------------- -------------------- ---------------------- ------------------------- -------------------- --------- ----<BR />UUDET 0000 10 01-FEB-10 1 FEB 2010<BR />UUDET 1000 20 01-FEB-10 1 FEB 2010<BR />UUDET 2000 30 01-FEB-10 1 FEB 2010<BR />UUDET 3000 40 01-FEB-10 1 FEB 2010<BR />UUDET 0000 25 01-FEB-10 2 FEB 2010<BR />UUDET 1000 15 01-FEB-10 2 FEB 2010<BR />UUDET 2000 10 01-FEB-10 2 FEB 2010<BR />UUDET 3000 55 01-FEB-10 2 FEB 2010<BR />UUDET 0000 15 01-JAN-10 1 JAN 2010<BR />UUDET 1000 18 01-JAN-10 1 JAN 2010<BR />UUDET 2000 5 01-JAN-10 1 JAN 2010<BR />UUDET 3000 76 01-JAN-10 1 JAN 2010<BR />UUDET 0000 88 01-JAN-10 2 JAN 2010<BR />UUDET 1000 36 01-JAN-10 2 JAN 2010<BR />UUDET 2000 12 01-JAN-10 2 JAN 2010<BR />UUDET 3000 40 01-JAN-10 2 JAN 2010<BR />LOPETETUT 0000 100 01-JAN-10 1 JAN 2010<BR />LOPETETUT 1000 20 01-JAN-10 1 JAN 2010<BR />LOPETETUT 2000 5 01-JAN-10 1 JAN 2010<BR />LOPETETUT 3000 8 01-JAN-10 1 JAN 2010<BR />LOPETETUT 0000 10 01-JAN-10 2 JAN 2010<BR />LOPETETUT 1000 13 01-JAN-10 2 JAN 2010<BR />LOPETETUT 2000 16 01-JAN-10 2 JAN 2010<BR />LOPETETUT 3000 12 01-JAN-10 2 JAN 2010<BR />LOPETETUT 0000 53 01-FEB-10 1 FEB 2010<BR />LOPETETUT 1000 23 01-FEB-10 1 FEB 2010<BR />LOPETETUT 2000 19 01-FEB-10 1 FEB 2010<BR />LOPETETUT 3000 36 01-FEB-10 1 FEB 2010<BR />LOPETETUT 0000 2 01-FEB-10 2 FEB 2010<BR />LOPETETUT 1000 1 01-FEB-10 2 FEB 2010<BR />LOPETETUT 2000 9 01-FEB-10 2 FEB 2010<BR />LOPETETUT 3000 11 01-FEB-10 2 FEB 2010<BR /><BR /></PRE><BR /><BR /> <P>I created a simple chart that uses three dimensions (in the respective order) - MONTHS (grouped), SECTION and NAME. It uses one expression to dislay the value which reads -</P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code">Sum(if(HEAD='UUDET',VALUE))</PRE><BR /><BR /> <P>The chart looks as I intend it to be like:</P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-1015_sourceID:1015" /></P><P>Is it possible to show a Totals bar after each month block. Currently it shows a 0000,1000,2000,3000 for each month. What I would like is 000,1000,2000,3000, Total for each month.</P><P>My apologies for the bad screenshot. It was the only tool I had at hand.</P><P>Any help?</P><P></P><P></P></BODY></HTML> Tue, 02 Feb 2010 15:39:16 GMT https://community.qlik.com/t5/QlikView/Totals-in-Chart-Question/m-p/229154#M81107 2010-02-02T15:39:16Z Totals in Chart Question https://community.qlik.com/t5/QlikView/Totals-in-Chart-Question/m-p/229155#M81108 <HTML><HEAD></HEAD><BODY><P>I don't think this is possible the way you are creating the chart with multiple dimensions. I would be interested to see a solution by someone.</P></BODY></HTML> Wed, 03 Feb 2010 04:37:41 GMT https://community.qlik.com/t5/QlikView/Totals-in-Chart-Question/m-p/229155#M81108 disqr_rm 2010-02-03T04:37:41Z Totals in Chart Question https://community.qlik.com/t5/QlikView/Totals-in-Chart-Question/m-p/229156#M81109 <HTML><HEAD></HEAD><BODY><P>Rakesh, would the same thing be possible if I changed my data model in some way?</P></BODY></HTML> Wed, 03 Feb 2010 07:08:45 GMT https://community.qlik.com/t5/QlikView/Totals-in-Chart-Question/m-p/229156#M81109 2010-02-03T07:08:45Z