Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Totals in pivot table

Hi All,

I have a pivot table chart which has 3 dimensions. (country. business, name)

i want to only show data which is not equal to yes in 5 indiviudal field expressions.

which creates the following correct chart:

CountryBusienssNamefieldafieldbfieldcfieldd
UKUKAANON/ANO
UKUKABNO
UKUKBABCNO<not declared>
FRANCEFRANCEADEFNO
GERMANYGERMANYAGHYNONONONO
GERMANYGERMANYBGERWNO

As this is a pivot table when it is collapsed i want it to count the total number of rows with data in for that country

So the above table collapsed would look like

CountryBusienssNamefieldafieldbfieldcfieldd
UKUKAA2121
FRANCEFRANCEADEF1
GERMANYGERMANYAGHY1121

I do not know how to get the table to look like the above collapsed as the data is not numeric and the total part on the expression in properties is greyed out.

Any help would be appreciated.

Thanks,

Laura

0 Replies