Qlikview Pivot chart Avg() for distinct records

[#1]

Hi Experts,

I have an internal table with records. For reasons I should keep duplicated records with different IDs. But I'm NOT able to get expected average LT. How to get average for a shared dimension (plnt) using Pivot Chart and Avg()?

qvw file is attached for your kind help.

[swuehl · Accepted solution]

Try as expression:

=Avg( Aggr( LT, plnt, mat))

[prashantbaste]

Hi

Please check attached QVW ...  I hope issue is resolved in it.

--

Regards,

Prashant P Baste

[#4]

Thanks swuehl, it works.

The solution can also be Avg(aggr(LT,mat))