topic Re: Pivot table with DSO issue in QlikView

Pivot table with DSO issue

Tue, 18 Nov 2014 02:06:59 GMT

Dear Experts,

would you please help the followings:

please check the testing data attached.

Can i change the DOS in Total in RED color, pick the largest month DOS, not sum up all month? so does the blue field...

i try Dimensionality(), it doesn't work.

would you please kindly help with this?

Thanks,

Best regards,

Manie

Tue, 18 Nov 2014 06:05:22 GMT

Anyone HELP??????

jonathandienst — Tue, 18 Nov 2014 06:16:06 GMT

This works, if I understand you correctly

=If(Dimensionality() = 0 And SecondaryDimensionality() = 0,

Max(Aggr(SUM(DSO), YEAR, MONTH)),

SUM(DSO)

)

HTH

Jonathan

Tue, 18 Nov 2014 06:33:15 GMT

Dear Jonathan, it seems doesn't work. what i want the result is like the follow pic:

would you please help...?

thanks,

best regards,

Manie

Tue, 18 Nov 2014 07:04:37 GMT

Help help help experts~~~~

tresB — Tue, 18 Nov 2014 07:29:35 GMT

A small correction in Jonathan's formula:

=If(Dimensionality() = 0 And SecondaryDimensionality() = 0,

Max(Aggr( Sum(DSO),YEAR,OSR)),

SUM(DSO)

)