PIVOT CHART ISSUE

[#1]

I am trying ti accomplish the attached chart in Qlikview(Report.png) .  So far I was able to Get the Attached chart in the Pivot Table with First Dimension as (Claim Type Code) and Second one is a Calculated Dimension  (=ValueList('Sum','AVG') ).

The problem is that I cant get the Totals of every thing like in the Chart  (QV_Result.png)

Any suggestions.

[agilos_mla]

Hi Ray,

You might use this alternative if it suites you (see expression in attached screenshot)

Hth,

Michael

[#3]

The second column u have is that a Calculated Dimension???

[#4]

I am getting only the SUM No Average, what am I missing??

[#5]

(=ValueList('Sum','AVG') ).

Instead of this use this expression

(=Sum(Sales)&chr(10)&avg(Sales))

[#6]

Thast  not gonna work cuz what u are doing is providing the calculations in the Dimensions??

[agilos_mla]

Only the SUM or AVG labels are calculated dimension since it's not linked to a field in the model it cannot affect the performance.

The computation of sum and avg is well made in a expression, the trick is that we use a carriage return (chr(10)) to display the results on two lines.

Valuelist or Valueloop do not atuhtorized total aggregation since it detached of the model.

[#8]

Attached is my Result screen shot. I  am not getting the AVG in there. I am using Pivot Table with Partial Sums checked

[agilos_mla]

Go to Presentation tab and set Wrap cell text in 2 lines to make the AVG ligne displayed.

Michael

[#10]

Thnx Man that Did it