ABOVE statement shows null when I change offset

[#1]

Dear Qlik Community,

ABOVE statement shows null when I change offset. See 3 columns-samples below:

Sample 1 = Above ( Sales, 0, 1) - works fine

Sample 2 = Above ( Sales, 1, 1) - failing, shows "-"

Sample 3 = RangeSum( Above ( Sales, 1, 1) - failing, shows 0 (I thought maybe RangeSum can solve it...)

(Chart 'Pivot table' used as object)

[swuehl · Accepted solution]

That's because of the so called column segments. Above() will only work within a column segment.

A new column segments starts for very change in an upper dimensional value (i.e. for every change in TMC).

In your example, your column segments starts on each new line, hence above() with an offset other zero won't work.

To disregard the column segments, use the TOTAL qualifier:

=Above(TOTAL Sales,1,1)