Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikmsg4u
Specialist
Specialist

Difference between Above(),Below(),Previous(),After(),Before()

Hello Community,

Can any one explain me the difference between these functions.

Above(),Below(),Previous(),After(),Before()

4 Replies
whiteline
Master II
Master II

Hi.

I think they're described inhelp clearly.

Above(),Below(),After(),Before() can be used in charts to evaluate expression for a dimension value that is offset relative to current.


Previous() canbe used in script to get field value from previous row of the source table.

It's usually considered with peek(). The main difference is that by default peek() returns value from destination table instead.

Anonymous
Not applicable

Addition:

before/after are for the pivot tables only

above/below for anything else (where applicable)

Anonymous
Not applicable

Many thanks to whiteline & Michael.

Two  good answers.

Obviously. the people do not read manuals too often.

whiteline
Master II
Master II

In defence of them I would say that only very thoughtful person could find the difference between peek and previous in help 😃

As well as features that Michael has mentioned.