Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
vijetasharma
Contributor III

Calculating growth for month on month

Hi everyone,

I am having data of months for particular years suppose,I am selecting 2012 then it should show me growth by calculating for feb(feb-jan),for march(march-feb) and so on  and when it calculate for jan 2012 it should calculate jan-dec of year 2011

can anybody provide me solution for this?

3 Replies
MVP
MVP

Re: Calculating growth for month on month

You can do it in the front end using above()/below() function. In the script, using previous()/peek() with proper sort order and group by. Try to create a sample qvw and share here if you need more help in details.

vijetasharma
Contributor III

Re: Calculating growth for month on month

growth_demo.bmp

Here, I am attaching sample image where I want to display trend for month 1 also by taking jan 2012-dec 2011

MVP
MVP

Re: Re: Calculating growth for month on month

Script-way, like attached sample.

Community Browser