topic Mini Chart - no chart for grand total? in QlikView

Mini Chart - no chart for grand total?

Thu, 18 Mar 2010 22:25:59 GMT

I love the Mini Chart feature of QV 9 and use it all the time. However I have not figured out a way to graph the grand total - each value gets graphed but not the total. Any ideas? I have tried playing with the "Total Mode" and nothing happens.

Mini Chart - no chart for grand total?

Fri, 02 Apr 2010 14:17:08 GMT

Same question here!

Now, as a workaround, I had to create a second table and try and 'pretend' it's the same table..

Mini Chart - no chart for grand total?

Wed, 19 Jan 2011 13:33:37 GMT

I have also had this problem. I would think it should just display, like any other total

Mini Chart - no chart for grand total?

Thu, 31 Mar 2011 20:31:37 GMT

I had this same challenge and resolved it so I thought I'd share. First the evidence:

Transformed into ....

The secret is in your load script. You basically need to create a "dummy" table that hooks off your displayed dimension that has an aggregated TOTAL row. A good way to understand it is a snowflake off your primary dimension with exactly TWICE as many rows as your primary dimension, 1/2 the rows exactly the same as your primary dimension and the other 1/2 hardcoded with 'Total'. I've seen people in the past call this a fancy name but I forget what they call it. I actually use this all over the place when special total formatting is needed.

Once you have this table, personally I call it <primary dimension name> Total Snow, you use it instead of your primary dimension. You don't show totals because you already have a "total" row in your dataset. You can take it from here, once you have the row "total" in your dataset you can format accordingly.

Have fun - DB