Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sr_qlikview
Creator
Creator

pivot table total column

i have 4 dimenions  ex: A,B,C,D, and 5 dimension is Month end (date) and expression is sum(sales)

My month end goes horizontal (means each monthend date as column).

Now if want a total COLUMN which is sum of sales for A,B,C,D ignoring months dimension in other words total of all months

3 Replies
sr_qlikview
Creator
Creator
Author

can someone help

Sokkorn
Master
Master

Hi sr_qlikview,

It a little bit confused your requirement. Can you manipulate data in Excel what is your source and what is you looking for then post here.

Regards,

Sokkorn

sr_qlikview
Creator
Creator
Author

Dim1Dim2Dim33/1/20133/8/20133/15/2013Total
Aa1aa11034
Aa2aa22248
Aa2aa30257
Aa3aa464212
Bb1bb12428
Bb2bb226715

i have 4 dimensions, dim1,dim2,dim3,weekendate

my expression is sum(sales)

total is nothing but sum of sales for all weeks