topic Re: PIVOT CHART ISSUE in QlikView

PIVOT CHART ISSUE

Sat, 22 Feb 2014 20:56:17 GMT

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.

Re: PIVOT CHART ISSUE

agilos_mla — Sat, 22 Feb 2014 21:32:06 GMT

Hi Ray,

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

Hth,

Michael

Re: PIVOT CHART ISSUE

Sun, 23 Feb 2014 00:28:55 GMT

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

Re: PIVOT CHART ISSUE

Sun, 23 Feb 2014 00:52:45 GMT

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

Re: PIVOT CHART ISSUE

Sun, 23 Feb 2014 03:41:35 GMT

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

Instead of this use this expression

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

Re: PIVOT CHART ISSUE

Sun, 23 Feb 2014 04:00:41 GMT

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

Re: PIVOT CHART ISSUE

agilos_mla — Sun, 23 Feb 2014 08:10:23 GMT

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.

Re: PIVOT CHART ISSUE

Sun, 23 Feb 2014 14:54:33 GMT

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

Re: PIVOT CHART ISSUE

agilos_mla — Sun, 23 Feb 2014 15:11:01 GMT

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

Michael

Re: PIVOT CHART ISSUE

Sun, 23 Feb 2014 15:20:22 GMT

Thnx Man that Did it

Re: PIVOT CHART ISSUE

Sun, 23 Feb 2014 15:44:59 GMT

Is there a Way to show 'Sum' and 'AVG ' in the Total Also?

Re: PIVOT CHART ISSUE

agilos_mla — Sun, 23 Feb 2014 15:59:41 GMT

Just below No, but you could try

- change total label with : ='Total SUM'&CHR(10)&'Total AVG'

Adjust the spaces between words to the size of the pivot.

Then please mark the answer as correct 😉

Michael