Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
alexandros17
Partner - Champion III
Partner - Champion III

I tried this ... I hope it helps

Alexandros

Not applicable
Author

Hi,

Thanks but i need rolling 24 months.

Thanks

Ritul

Not applicable
Author

Hi All,

Any one help me for this.

Regards,

Ritul

er_mohit
Master II
Master II

hiii

try this

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

Anonymous
Not applicable
Author

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
Author

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