Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
This works, if I understand you correctly
=If(Dimensionality() = 0 And SecondaryDimensionality() = 0,
Max(Aggr(SUM(DSO), YEAR, MONTH)),
Dear Jonathan, it seems doesn't work. what i want the result is like the follow pic:
would you please help...?
Help help help experts~~~~
A small correction in Jonathan's formula: