Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

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.

jchang_snwl
New Contributor II

pivot table sum(total) question

Hello,

I have a table like this

WeibullInput.PNG

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

WeibullIn.PNG

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

WeibullIn.PNG

How to do it?

thanks,

Josh

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