topic ABOVE statement shows null when I change offset in QlikView

ABOVE statement shows null when I change offset

Fri, 20 Nov 2020 18:02:30 GMT

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 — Mon, 15 Feb 2016 18:35:51 GMT

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)