topic Re: Re: Regarding Pivot table row wise average in QlikView

Regarding Pivot table row wise average

Mon, 07 Jul 2014 19:35:33 GMT

Hello Friends,

Your helps are always appreciated!

I have a pivot table in which I need a row wise average as like below,

Kindly share your ideas

Thanks,

Kiru

Gysbert_Wassenaar — Tue, 08 Jul 2014 09:15:27 GMT

Please read these two documents:

Tue, 08 Jul 2014 13:37:59 GMT

Thank you Gysbert!

gerhard_jakubec — Wed, 06 Aug 2014 13:24:10 GMT

Hi Kiru,

i am stuck on this topic for quite some time now.

My situation:

Requirement:

unfortunately I have not found a solution yet... good luck

Clever_Anjos — Wed, 06 Aug 2014 13:35:56 GMT

Please check if this solve your needs

jonathandienst — Wed, 06 Aug 2014 14:04:27 GMT

Use an expression with Dimensionality() (for row dimensions) and SecondaryDimensionality() (for column dimensions) like this:

If(Dimensionality() = 0,

Count(Distinct businessKey),

If(SecondaryDimensionality() = 0,

Avg(Aggr(Count(Distinct businessKey), Dim1, Dim2, Dim3)),

Count(Distinct businessKey)

)

where Dim1, Dim2, and Dim3 are the three dimensions of the table. See attached for an example

Regards

Jonathan

gerhard_jakubec — Wed, 06 Aug 2014 14:50:00 GMT

Thank you, will test your proposed solutions.

kind regards