topic Re: Lag function in QlikView

Lag function

Wed, 09 Oct 2013 09:20:34 GMT

I'm new to Qlikview and have a specific problem that highlights a broader issue that I'm not sure about yet.

The problem is whether it is possible to use lag values in a straight table i.e. To create the following:

Month	Sum(Value)	Lag SUM(Value)
January	a	-
February	b	a
March	c	b
April	d	c

My ultimate aim is to be able to create a column where I compare the Value with the lag value, but I want to get there in stages.

One solution would be to create another column as I load the data. But is that the best way of doing it? If the dataset were large it would slow down loading. In this situation the data is small, but I often work with big datasets.

Any help would be much appreciated.

Re: Lag function

tresB — Wed, 09 Oct 2013 09:24:51 GMT

Use above() function, like: =Above(Sum(Value)) // this should be the expression for your lag column

Re: Lag function

sujeetsingh — Wed, 09 Oct 2013 11:16:38 GMT

Andrew ,

first of all you can compare it in Charts

Re: Lag function

MayilVahanan — Wed, 09 Oct 2013 11:22:20 GMT

Try like this

=Above(Sum(Sales)) <- Lag level.

=Below(Sum(Sales)) <- Lead level.

Re: Lag function

suniljain — Wed, 09 Oct 2013 11:24:25 GMT

You can use

above()

it will returns the value of expression evaluated with the chart's dimension values as they appear on the row above the current row within a column segment in a table or, in the case of bitmap charts, in the chart's straight table equivalent

Re: Lag function

Wed, 09 Oct 2013 11:31:50 GMT

Thanks for your replies - I got the Above() function working... I knew it must be possible