topic Re: Pivot table AGGR, MAX function return null value in QlikView

Pivot table AGGR, MAX function return null value

phoenix — Wed, 25 Nov 2020 16:16:04 GMT

I have first three columns in my data and I am trying to get to last three column in a pivot by VINTAGE_YR and TOB. I am trying to get to set analysis using AGGR, MAX functions

Re: Pivot table AGGR, MAX function return null value

sunny_talwar — Tue, 21 Aug 2018 12:19:06 GMT

May be this

1) Max(TOTAL <VINTAGE_YR, VINTAGE_MTH> TOB)

2) Max(TOTAL <VINTAGE_YR> TOB)

3) Max(TOTAL <VINTAGE_YR, TOB> VINTAGE_MTH)

Re: Pivot table AGGR, MAX function return null value

phoenix — Thu, 30 Aug 2018 17:50:54 GMT

Thanks