topic Re: pivot table total column in QlikView

pivot table total column

sr_qlikview — Wed, 22 May 2013 23:30:35 GMT

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

sr_qlikview — Thu, 23 May 2013 01:31:25 GMT

can someone help

Sokkorn — Thu, 23 May 2013 02:10:06 GMT

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 — Thu, 23 May 2013 03:08:43 GMT

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

my expression is sum(sales)

total is nothing but sum of sales for all weeks