Peek function is not wrkoing

[#1]

Hi

I have scenario,

I have database like this

Date,

Region,

Loaction,

Sales

I want to create forecasting data for another 10years

Date=Date+1

region=Region

Location=Location

Sales=Last month sales+(Lastmonth sales* (last24month sales growth rate)

for finding the growth rate i am using sales-Peek(sales)/peek(sales)

but the peek(sales) is not working properly it is reverse order or some issue is there

Is there any pre requisites i need to take care while using peek function in qlikview?

Thanks

Thiru

[vikasmahajan]

attach some samples or data

Vikas

[sushil353]

Hi,

Try this:

Create a separate column say Sales2

if(rowno()=1,sales,sales-Peek(sales2)) as sales2

after that using resident load you can calculate the growth:

(sales/sales2)-1 as Growth

HTH

[#4]

Hi

I didn't get you,separate column means rowno or sales2

Thiru