Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pivot table with DSO issue

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?

2014-11-18_10-01-09.png

Thanks,

Best regards,

Manie

5 Replies
Highlighted
Not applicable

Anyone HELP??????

Highlighted

Hi

This works, if I understand you correctly

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

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

  SUM(DSO)

)

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Not applicable

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

2014-11-18_14-29-44.png

would you please help...?

thanks,

best regards,

Manie

Highlighted
Not applicable

Help help help experts~~~~

Highlighted
MVP
MVP

A small correction in Jonathan's formula:

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

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

  SUM(DSO)

)