topic Re: pivot table sum(total) question in QlikView

pivot table sum(total) question

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hello,

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?

thanks,

Josh

Re: pivot table sum(total) question

sunny_talwar — Tue, 27 Sep 2016 17:15:32 GMT

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