Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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

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

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!!!

Community Browser