Expressions->Total Mode in a Bar Chart possible?

[#1]

I can't seem to enable the Total Mode options under the Expressions tab when I'm using a bar chart, is it possible to do so? The radio buttons are grayed out and unable to be clicked on. It works fine when I'm using a straight table. Is this just a strange limitation of QlikView? Searching these forums and the developers book it looks like there is a Show Total checkbox under Dimension Limits instead, but it looks rather limited i.e. it can only show a bar which is a sum total of the other bars, rather than an Average or other options available in the Total Mode -> ____ of Rows combo box (which I would like to use).

[#2]

Hi Blien

There is no totals mode enabled as you are unable to have a "total" in a bar chart.

You can however add an average / total line by going into the presentation tab in the chart properties and adding a reference line.

Hope this helps!

Erica

[stigchel]

There are ways to work around this by creating a total in the dimension. One way is to do a crostable load of the dimension you want to use:

Crosstable(Dimension, DimData,1) load

Key,

Value1 as DimValue1

Value2 as DimValue2

Value1 as DimTotal

Value2 as DimTotal

Resident Data;

Or create a calculated dimension with a ValueList, in the expression do the right calculation for either values and total.

[Gysbert_Wassenaar]

You can use the aggr function to do this. See attached example. It show the count of sales per salesperson, but the total column shows the average instead of the total count.

[stigchel]

Either I'm missing something, or maybe you have included the wrong example Gysbert?

[Gysbert_Wassenaar]

You're right. Fixed now. Thanks!