topic Re: Cumulative Bar Chart in QlikView

Cumulative Bar Chart

Wed, 28 Nov 2012 14:18:38 GMT

Hi,

I am looking to create a cumulative bar chart with a set of data. I've looked at other posts, but nothing seems to fit my circumstances.

I have a range of products and their installed dates:

Dimensions: Year, Month and Product Name

Expression: rangecount(above( TOTAL Count(EmployerProduct_id), 0, rowno(Total)))

The chart is set to 'Full Accumulation'

Essentially the issue I have is that where there has been no install taken place for any given day (which I converted into Year, Month), this does not show an accumulation of that record in that month (see .png attachment of screenshot).

I'd prefer not to use an inline table to populate the days where no install has taken place with a product record of '0' (which won't work anyway since I am counting the records, not summing) as new products are added to this periodically and it is a large enough data table already.

Can anyone help? Please let me know if you require further information.

Your help is appreciated!

Thanks,

Re: Cumulative Bar Chart

Sat, 01 Dec 2012 15:19:00 GMT

could you prepare small sample qv file with your data ?

Re: Cumulative Bar Chart

Fri, 14 Dec 2012 12:21:52 GMT

Hi Pari,

Please find attached a sample fo the data. The second graph is the cumulative chart, but as you can see where there have been no installations in certain year/months, it does not accumulate the product from the previous months.

In addition, once this is done I need to find a way to then take a product away from the chart at the point of it being decommissioned so that I can see a true reflection of the installed base for whatever month I am looking at. So if product A20 was installed in May 2007 but then decomissioned in May 2012 I would want to see it from May 2007-May 2012 in my chart but not beyond June 2012.

Thanks.

Re: Cumulative Bar Chart

Fri, 21 Dec 2012 11:05:08 GMT

sorry for late response...

1. You should create separate table for calendar with all the possible values CalcYM

2. ....still working on it....

Re: Cumulative Bar Chart

Fri, 21 Dec 2012 11:17:04 GMT

No problem, thanks!

I was afraid you would say that! So there seems to be no other way... Just to be clear I would need to create circa 500 records for every calendar day since 1970 and then maintain these when a new product comes along?

Thanks again.

Re: Cumulative Bar Chart

Fri, 21 Dec 2012 11:55:02 GMT

as i look at your data table, I suggerst to do crosstable load to make the table like:

Product_Name	Date	Status	Date	Type
A87	24010	In Service	14/01/2007	Calc
A87	24010	In Service	14/01/2007	CAT
A87	24010	In Service	Null	Commission
A87	24010	In Service	Null	Deliver
A87	24010	In Service	Null	Install
A87	24010	In Service	11/09/2006	Ship
A87	34986	In Service	16/01/2007	Calc
A87	34986	In Service	Null	CAT
A87	34986	In Service	Null	Commission
A87	34986	In Service	Null	Deliver
A87	34986	In Service	Null	Install
A87	34986	In Service	16/01/2007	Ship
A65	14301	Decommissioned	17/01/2007	Calc
A65	14301	Decommissioned	Null	CAT
A65	14301	Decommissioned	Null	Commission
A65	14301	Decommissioned	17/01/2007	Deliver
A65	14301	Decommissioned	17/01/2007	Install
A65	14301	Decommissioned	Null	Ship
A66	30855	In Service	17/01/2007	Calc
A66	30855	In Service	Null	CAT
A66	30855	In Service	Null	Commission
A66	30855	In Service	17/01/2007	Deliver
A66	30855	In Service	17/01/2007	Install
A66	30855	In Service	Null	Ship
A24	97241	In Service	26/01/2007	Calc
A24	97241	In Service	Null	CAT
A24	97241	In Service	Null	Commission
A24	97241	In Service	08/05/2006	Deliver
A24	97241	In Service	26/01/2007	Install
A24	97241	In Service	Null	Ship

or even delete rows with Date=null

then try to create simple calendar (starting from 01-01-1970) with:

Date	YM
01/01/1970	19701
02/01/1970	19701
03/01/1970	19701
04/01/1970	19701
05/01/1970	19701
06/01/1970	19701
07/01/1970	19701
08/01/1970	19701
09/01/1970	19701
10/01/1970	19701
11/01/1970	19701
12/01/1970	19701
13/01/1970	19701
…	…
…	…
…	…