Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qlikmsg4u
Valued Contributor

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
Honored Contributor II

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

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.

mov
Esteemed Contributor III

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

Addition:

before/after are for the pivot tables only

above/below for anything else (where applicable)

carbal1952
Contributor II

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

Many thanks to whiteline & Michael.

Two  good answers.

Obviously. the people do not read manuals too often.

whiteline
Honored Contributor II

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

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.

Community Browser