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 in 12 Month Increments

I want to be able to see how new products do every months months from its release date.  For example, if we have a product that is release on 06/15/2008  I want to be able to see the sales from 07/01/2008 - 06/30/2009, then from 07/01/2009 - 06/30/2010.  Each product has a unique release date.

I want the columns of the report to look like this

                    First 12 months   2nd 12 months  3rd 12 months

Product A     10,000                    15,025               26,780

Product B     36,999                    40,234               53,500

I am using the personal edition so I cannot open any QVS file so please just send suggestion in reply.

I really am desperate......any help is appreciated

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Sales in 12 Month Increments

Use Product as your dimension and three expressions:

First 12 Months: sum(if(sales_date>=release_date and sales_date<addyears(release_date,1),sales))

2nd 12 Months: sum(if(sales_date>=addyears(release_date,1) and sales_date<addyears(release_date,2),sales))

3rd 12 Months: sum(if(sales_date>=addyears(release_date,2) and sales_date<addyears(release_date,3),sales))

Change sales_date, release_date and sales to whatever is appropriate for your document.


talk is cheap, supply exceeds demand
2 Replies
MVP & Luminary
MVP & Luminary

Re: Sales in 12 Month Increments

Use Product as your dimension and three expressions:

First 12 Months: sum(if(sales_date>=release_date and sales_date<addyears(release_date,1),sales))

2nd 12 Months: sum(if(sales_date>=addyears(release_date,1) and sales_date<addyears(release_date,2),sales))

3rd 12 Months: sum(if(sales_date>=addyears(release_date,2) and sales_date<addyears(release_date,3),sales))

Change sales_date, release_date and sales to whatever is appropriate for your document.


talk is cheap, supply exceeds demand
Not applicable

Re: Sales in 12 Month Increments

AWESOME!!! Works GREAT THANKS!!!