Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Previous Year Value Calculation

Hi Everyone,

I have data in this manner :

YearProductSales
2000P1100
2001P1189
2002P1154
2003P1145
2000P267
2001P287
2002P245
2003P267

I need to have one more Column to have "Previous Year Sales" for Year and Product.

Final Result will be like this :

YearProductSalesPrevious_Year_Sales
2000P1100-
2001P1189100
2002P1154189
2003P1145154
2000P267-
2001P28767
2002P24587
2003P26745

How can I achieve this ? Kindly help

Regards,

Kumar

1 Solution

Accepted Solutions
MVP
MVP

Re: Previous Year Value Calculation

Front-end - use Above() function

Script - use Peek() function

Update: PFA

View solution in original post

2 Replies
MVP
MVP

Re: Previous Year Value Calculation

Front-end - use Above() function

Script - use Peek() function

Update: PFA

View solution in original post

Not applicable

Re: Previous Year Value Calculation

Thanks Tresesco