topic Re: Count as Partial sum in Pivot Chart under a Dimension in QlikView

Count as Partial sum in Pivot Chart under a Dimension

Mon, 07 Apr 2014 11:08:20 GMT

Hi,

Not sure this is possible but thought I would ask the question.

I have a pivot chart where the year split is important. I simply would like to count the number of 'Yes' values (essentially all rows) by year and display the count in the 'Value' column.

Year	DimensionA	Value
2013	A	Yes
	B	Yes
	Total	2
2014	A	Yes
	B	Yes
	C	Yes
	D	Yes
	E	Yes
	F	Yes
	Total	6
Total		8

is this possible?

Thanks.

Re: Count as Partial sum in Pivot Chart under a Dimension

Anonymous — Mon, 07 Apr 2014 13:47:09 GMT

It is possible by using conditional expression for Value, where condition is based on dimensionality() - see attached.

Re: Count as Partial sum in Pivot Chart under a Dimension

Mon, 07 Apr 2014 14:11:02 GMT

Michael that worked perfectly. Many thanks!