Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Count as Partial sum in Pivot Chart under a Dimension

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.

YearDimensionAValue
2013AYes
BYes
Total 2
2014AYes
BYes
CYes
DYes
EYes
FYes
Total 6
Total 8

is this possible?

Thanks.

1 Solution

Accepted Solutions
mov
Esteemed Contributor III

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

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

View solution in original post

2 Replies
mov
Esteemed Contributor III

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

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

View solution in original post

Not applicable

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

Michael that worked perfectly.  Many thanks!