Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dineshkumar_e
New Contributor

To Add total count in the Pivot table

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
RedBlueWhiteBlack
India 10328
USA 7546
3 Replies
jwjackso
Contributor III

Re: To Add total count in the Pivot table

Turn on "Show totals" for both CountryName and Products

Pivot.PNG

dineshkumar_e
New Contributor

Re: To Add total count in the Pivot table

Thanks a lot Jerry..

It is working now.

cri
Contributor

Re: To Add total count in the Pivot table

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.

Community Browser