how to add an average on a qlikview pivot table ?

[Anonymous]

Hi everyone,

Hi, I'd like to add an aggregated column with the average at the end of the attached report.

I don't find any way to do that, especially the aggregation option is disable for all the expressions.

Any idea ?

Message was edited by: Bertrand Q.

[Anonymous]

Hi ,

yoo have to write the  expression like this

=If(SecondaryDimensionality() = 0, AVG calculation, Sum Calculation)

Thanks & Regards,

Venkata Sreekanth

[Anonymous]

Yes but I really don't get why as soon as I have a set analysis in the Sum Calculation, then I loose the last avg column.

[Anonymous]

Hi Venkata and everybody,

It seems to me that the example you posted does not work.

The last column that appears is just the sum for the months not displayed. If I select in the dimension tab "Supress if value is null" then the column disappear...

I still cannot get any added column  (with weighted average) on my cross tab, any help welcome.

[Anonymous]

I cannot get anything with SecondaryDimensionality or Dimensionality

[Anonymous]

Hi,

Kindly post the sample application here. Explain the logical condition what you want to write under the Set analysis.

Thanks & Regards,

Venkata Sreekanth