Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ABOVE statement shows null when I change offset

Dear Qlik Community,

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

test.jpg

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)

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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)

View solution in original post

1 Reply
swuehl
MVP
MVP

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)