Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kris_vliegen
Partner
Partner

Set Analyses in Pivot table

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

SetPivot.JPG

1 Solution

Accepted Solutions
rubenmarin

Yes, it should be:

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

View solution in original post

5 Replies
rubenmarin

Hi Kris, can you try?:

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

kris_vliegen
Partner
Partner
Author

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

SetPivot1.JPG

rubenmarin

Yes, it should be:

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

View solution in original post

Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
kris_vliegen
Partner
Partner
Author

Thanks Ruben!

This is what I was looking for 🙂