Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

New Contributor II

pivot table sum(total) question


I have a table like this


A pivot table has lastShipDateYW and Time2FWeek as dimensions. The expression is the total count of unique subsetID


I would like to know how to add a column which has total count of subsetID in lastShipDateYW and a row which has total count of Time2FWeek, like


How to do it?



1 Reply

Re: pivot table sum(total) question

Josh - You don't expect to provide you with a sample to this without looking at an application. I don't even know your data well enough and the images makes it even more complicated. Look at these threads and see if you can provide a sample

QlikCommunity Tip: How to get answers to your post?

Qlik Community Tip: Marking Replies as Correct or Helpful

Uploading a Sample