To Add total count in the Pivot table - Qlik Community

dineshkumar_e · ‎2018-03-21

Dear Qlik Experts,

I am new to qlik sense.

we have come up with a requirement to add total count in the pivot table.

Currently we are showing the count of each product against specific country.

In the same row we require the total count for all the products against the specific country.

Please help us to achive this scenario.

Advance Thanks..!

CountryName		Products
	TotalCount
		Red	Blue	White	Black
India		10	3	2	8
USA		7	5	4	6

jwjackso · ‎2018-03-21

Turn on "Show totals" for both CountryName and Products

dineshkumar_e · ‎2018-03-22

Thanks a lot Jerry..

It is working now.

CarmenReilly · ‎2018-03-22

Hi Dinesh - glad the issue has been resolved!

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.