Totals in Chart Question

[#1]

Hi guys,

I'm new to Qlikview. I just started by creating a basic chart in Qlikview.

My Data looks like this:

HEAD SECTION VALUE PERIOD NAME MONTH YEAR
-------------------- -------------------- ---------------------- ------------------------- -------------------- --------- ----
UUDET 0000 10 01-FEB-10 1 FEB 2010
UUDET 1000 20 01-FEB-10 1 FEB 2010
UUDET 2000 30 01-FEB-10 1 FEB 2010
UUDET 3000 40 01-FEB-10 1 FEB 2010
UUDET 0000 25 01-FEB-10 2 FEB 2010
UUDET 1000 15 01-FEB-10 2 FEB 2010
UUDET 2000 10 01-FEB-10 2 FEB 2010
UUDET 3000 55 01-FEB-10 2 FEB 2010
UUDET 0000 15 01-JAN-10 1 JAN 2010
UUDET 1000 18 01-JAN-10 1 JAN 2010
UUDET 2000 5 01-JAN-10 1 JAN 2010
UUDET 3000 76 01-JAN-10 1 JAN 2010
UUDET 0000 88 01-JAN-10 2 JAN 2010
UUDET 1000 36 01-JAN-10 2 JAN 2010
UUDET 2000 12 01-JAN-10 2 JAN 2010
UUDET 3000 40 01-JAN-10 2 JAN 2010
LOPETETUT 0000 100 01-JAN-10 1 JAN 2010
LOPETETUT 1000 20 01-JAN-10 1 JAN 2010
LOPETETUT 2000 5 01-JAN-10 1 JAN 2010
LOPETETUT 3000 8 01-JAN-10 1 JAN 2010
LOPETETUT 0000 10 01-JAN-10 2 JAN 2010
LOPETETUT 1000 13 01-JAN-10 2 JAN 2010
LOPETETUT 2000 16 01-JAN-10 2 JAN 2010
LOPETETUT 3000 12 01-JAN-10 2 JAN 2010
LOPETETUT 0000 53 01-FEB-10 1 FEB 2010
LOPETETUT 1000 23 01-FEB-10 1 FEB 2010
LOPETETUT 2000 19 01-FEB-10 1 FEB 2010
LOPETETUT 3000 36 01-FEB-10 1 FEB 2010
LOPETETUT 0000 2 01-FEB-10 2 FEB 2010
LOPETETUT 1000 1 01-FEB-10 2 FEB 2010
LOPETETUT 2000 9 01-FEB-10 2 FEB 2010
LOPETETUT 3000 11 01-FEB-10 2 FEB 2010

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 -

Sum(if(HEAD='UUDET',VALUE))

The chart looks as I intend it to be like:

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.

My apologies for the bad screenshot. It was the only tool I had at hand.

Any help?

[disqr_rm]

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.

[#3]

Rakesh, would the same thing be possible if I changed my data model in some way?