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

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

qlikmsg4u — Fri, 06 Sep 2013 16:41:20 GMT

Hello Community,

Can any one explain me the difference between these functions.

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

whiteline — Fri, 06 Sep 2013 19:14:40 GMT

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 — Fri, 06 Sep 2013 19:20:16 GMT

Addition:

before/after are for the pivot tables only

above/below for anything else (where applicable)

Anonymous — Fri, 06 Sep 2013 19:35:20 GMT

Many thanks to whiteline & Michael.

Two good answers.

Obviously. the people do not read manuals too often.

whiteline — Fri, 06 Sep 2013 19:43:31 GMT

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.