topic Peek function is not wrkoing in QlikView

Peek function is not wrkoing

Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 07 Jul 2016 06:39:56 GMT

attach some samples or data

Vikas

sushil353 — Thu, 07 Jul 2016 06:46:29 GMT

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

Thu, 07 Jul 2016 06:54:42 GMT

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

Thiru