Issue in using expression in stacked bar chart

Fri, 04 Jun 2010 04:45:54 GMT

Hi All,

Can Anybody help me out in this issue,

I am using one Stacked bar chart to do analysis of product.

I am taking 'year' and 'Product_category' as dimension and 'count of product in percentage' (Count of each product/Count of all the product)as expression . For that I am using the following Expression.

count( distinct if ( Volume > 0, Product))/count({$<Product=>} total distinct if ( Volume > 0, Product))

It shows 100% in chart If I select a particular year. But If I see for all the years, its taking "Count of each product / Count of product for all the year". I need an expression like, If we not select any particular year also it should count each product and do division for that particular year.

For eg:

Year	Product Category	Product in %	Count	I need like
2005	A	0%	0	0
2005	B	1%	2	1.503759
2005	C	0%	1	0.75188
2005	D	12%	38	28.57143
2005	E	1%	4	3.007519
2005	F	14%	43	32.33083
2005	G	15%	45	33.83459
2005	Total	43%	133	100%
2006	A	0%	0	0
2006	B	2%	5	2.777778
2006	C	0%	1	0.555556
2006	D	16%	49	27.22222
2006	E	2%	5	2.777778
2006	F	16%	49	27.22222
2006	G	23%	71	39.44444
2006	Total	58%	180	100%
2007	A	0%	1
2007	B	2%	6
2007	C	0%	1
2007	D	14%	43
2007	E	3%	9
2007	F	15%	48
2007	G	30%	92
2007	Total	65%	200
2008	A	0%	1
2008	B	0%	1
2008	C	0%	0
2008	D	6%	18
2008	E	5%	15
2008	F	1%	4
2008	G	20%	61
2008	Total	32%	100
2009	A	0%	0
2009	B	0%	0
2009	C	0%	0
2009	D	15%	45
2009	E	4%	13
2009	F	0%	0
2009	G	11%	34
2009	Total	30%	92
2010	A	0%	0
2010	B	0%	0
2010	C	0%	0
2010	D	13%	40
2010	E	1%	3
2010	F	0%	0
2010	G	1%	3
2010	Total	15%	46
Total		100%	Products: 310

If I am not selecting any particular year also, It should show me the 100% value for the products.

Please reply me soon,

Thanks in Advance!

Kirthi

topic Issue in using expression in stacked bar chart in QlikView

Issue in using expression in stacked bar chart