topic Pivot table to show average in partial sums in QlikView

Pivot table to show average in partial sums

Anonymous — Tue, 20 Dec 2016 06:21:47 GMT

Hi,

Appreciate any help on this.

The below table is what i am trying to achieve. I need the AVERAGE column beside the Total column.

I achieve the below, but i do not need the average column for all dimension Dim2. Only need the last AVERAGE column.

Please advise me!

Re: Pivot table to show average in partial sums

Anil_Babu_Samineni — Tue, 20 Dec 2016 11:47:58 GMT

Can you send sample to work, This will works and lot make sense.

Re: Pivot table to show average in partial sums

marcus_sommer — Tue, 20 Dec 2016 11:59:51 GMT

There are two possibilities - one is to add an extra field-value in Dim2 and the another is to use respectively to create a further dimension Dim3 above your Dim2 either by using a superior-group or just by typing a string like 'All available values of Dim2' into a calculated Dim3.

The next then would be to query this additionally fieldvalue like: if(Dim2 = 'avg Dim2', avg(value), sum(value)) or by the dimension-version with: if(secondarydimensionality() = 0, avg(value), sum(value))

- Marcus

Re: Pivot table to show average in partial sums

sunny_talwar — Tue, 20 Dec 2016 12:02:38 GMT

Something along these lines:

How to suppress 0 in expression