# New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Not applicable

## Sales growth for 24 month back

Hi,

How can i calculate the 24 month back sales growth. Attach is a sample and i have to create a line chart for rolling 24 month back.

Let me know if any thing requires.

Thanks

Tags (2)
6 Replies
MVP

## Re: Sales growth for 24 month back

I tried this ... I hope it helps

Alexandros

Not applicable

## Re: Sales growth for 24 month back

Hi,

Thanks but i need rolling 24 months.

Thanks

Ritul

Not applicable

## Re: Sales growth for 24 month back

Hi All,

Any one help me for this.

Regards,

Ritul

Honored Contributor II

## Re: Sales growth for 24 month back

hiii

try this

Valued Contributor III

## Re: Sales growth for 24 month back

Or if you have a Date field in your data you can use that to create a new Year-Month field which you can use as your dimension. To do this you can use this in your script:

date(monthstart(DATEFIELD), 'YYYY-MMM') AS YearMonth,

That is how I would do it

If you have a month and year field you can also solve it with a calculated dimension.

The expersion is in the attached example.

Good Luck,

Dennis.

Not applicable

## Re: Sales growth for 24 month back

Hi,

Thanks but i want to get growth by previous year like

Ex1:-

2012-12 / 2011-12

(2824 / 2531) -1  = 12%

Ex2:-

2012-11 / 2011-11

(3147 / 3048) -1  = 3%

like ways for other months upto rolling 24 months.

And i have month year field also in different table but dont know how to calculate the growth of current month vs previous year month upto rolling 24 months.

Regards,

Ritul

Community Browser