topic Dimensionality in QlikView

Dimensionality

Tue, 04 Jan 2011 11:58:55 GMT

Hello,

I need to use the sub-total of a column in a calculation for a new column. I have tried using dimensionality but it isn't working as I want it to. The last column in the image below is Expected Contribution. The column I need to create is Actual Contribution which would be calculated by saying the Sales per Salesman / the sub-total of the Warehouse the Salesman is grouped under.

For the image below, it would be 82 / 165 and then 83 / 165.

Thanks for your help in advance,

Shane

Dimensionality

lironbaram — Tue, 04 Jan 2011 12:08:37 GMT

hei

attach is an example of what you asked for

you calculate the sub total in the expression

Dimensionality

Tue, 04 Jan 2011 12:32:47 GMT

Roi,

Thanks. I've adapted it though and it's not working. I've attached a sample. I would really appreciate it if you could have a look at it and tell me where I'm going wrong.

Thanks,

Dimensionality

lironbaram — Tue, 04 Jan 2011 12:53:08 GMT

hei attach is the sample working

you cant do a applay total when you use a column name

i change it to the actual formula have a look

Dimensionality

Tue, 04 Jan 2011 13:18:45 GMT

Roi, thank you for your time. It's 100%.