Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

6 Replies

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

er_mohit
Honored Contributor II

Re: Sales growth for 24 month back

hiii

try this

='>=' & Date(addmonths(monthstart(Max([Rollmonth and year])),-24),'MMM-YYYY') & '<=' 8 Date(addmonth(max([Rollmonth and year]),0),'MMM-YYYY')

dennisnet
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