topic Summarize dimension columns in QlikView

Summarize dimension columns

Fri, 05 Oct 2012 11:35:48 GMT

Hi!

I'm trying to summarize columns which represent a dimenion. I want to create a chart that looks somewhat like this:

Salesman	Monday	Tuesday	Wednesday	Thursday	Friday	Total
Elvis Presley	4	3	1	0	4	12
Don Draper	1	2	3	4	0	10

I've succeeded with everything but the Total-column.

My problem is that the weekdays are a dimension which I moved so that it would show as columns. I therefore only have one expression, the sum of sales. Which then gives me the sum for each salesman every day day. But I can't figure out how to at an extra column with "Total".

Any suggestions?

Re: Summarize dimension columns

Fri, 05 Oct 2012 12:09:09 GMT

i attach a vd see.

REGARDS

Re: Summarize dimension columns

Fri, 05 Oct 2012 12:26:44 GMT

Thanks for your reply

I dont really understand how your example would help me. I have a sum expressions which sums up the sales for each salesman and then presents it per weekday. I would then like to add a column which would summarize all the other columns. So regardless if I choose to see only 2 days or the whole week, I would see the totalt of all the columns which are visible.

Re: Summarize dimension columns

perumal_41 — Fri, 05 Oct 2012 12:45:29 GMT

Hi,

I have attached one application, this solved ur problem

Re: Summarize dimension columns

Fri, 05 Oct 2012 13:40:21 GMT

I finally figured out how to solve it. in the Style-tab i unchecked the box "indent". This then gave me the oppertunity to check the "partial sum" box for my "weekday"-dimension which was greyed out before. I then checked the indent-box again and it works