topic Re: Set Analyses in Pivot table in QlikView

Set Analyses in Pivot table

kris_vliegen — Wed, 14 Jan 2015 14:11:52 GMT

Hi all,

I have a problem with Set Analyses in a pivot table.

This is my set Analyses for AVGPrijs =avg({<stationId={"$(=vEigenStation)"} >}DagPrijs)

I would like to compare the value of the records with the value of my reference station (StationId = 1008)

Is there a solution to get the AVGPrijs of the reference-station in everry row?

Regards,

Kris

rubenmarin — Wed, 14 Jan 2015 14:24:41 GMT

Hi Kris, can you try?:

=avg(TOTAL {<stationId={"$(=vEigenStation)"} >}DagPrijs)

kris_vliegen — Wed, 14 Jan 2015 14:32:01 GMT

Hi Ruben,

thanks for your answer.

But now he gives the average value of stationId 1008. Is it possible to split it up in the years?

For 2014 : 1.435 and for 2014 =1.396

rubenmarin — Wed, 14 Jan 2015 14:35:36 GMT

Yes, it should be:

=avg(TOTAL <YearField> {<stationId={"$(=vEigenStation)"} >}DagPrijs)

Gysbert_Wassenaar — Wed, 14 Jan 2015 14:39:27 GMT

=avg(TOTAL <$(='['&getcurrentfield(MyDrillDownGroupNameHere)&']')> {<stationId={"$(=vEigenStation)"} >}DagPrijs)

kris_vliegen — Wed, 14 Jan 2015 14:42:29 GMT

Thanks Ruben!

This is what I was looking for 🙂