Using sum between different dimensions

Thu, 08 Aug 2013 10:50:15 GMT

Hello everybody,

I've the following issue.

I want to show the two values the sum of sales-data and the sum of fielddays in a pivot-table.
The first one (sales data) is linked to a company, the second one (fielddays) is just linked to a salesrep.
Now, when I show this data in the pivot table, everything is summed up clearly by the salesrep on the top level.

Doing the drill-down to a lower hierachy, like the customer-level, only the sum over the sales data is visible; the sum over the fielddays is 0.

My goal is now to show the sum also in the column of the fielddays - even if it's only available for a salesrep.

Normally this should be a standard functionality in qlikview (well I think so), but I also think, that this might be as a result of my data model.
Here a fact-table is used, where different measures are loaded into one big 'file', just seperated by a type - in order to be handled by one date-field or one product-field etc.

So is there a way to solve my issue. I've tried it with the total-function, but didn't get the proper result.

Attached you'll find the used qvw.

Thank you in advance.

Otto

Re: Using sum between different dimensions

Gysbert_Wassenaar — Thu, 08 Aug 2013 11:29:06 GMT

Try: sum(aggr(nodistinct sum( Fielddays),Salesrep))

Re: Using sum between different dimensions

Thu, 08 Aug 2013 11:47:55 GMT

Hi Gysbert,

thank you very much. that works great.

Otto

topic Re: Using sum between different dimensions in QlikView

Using sum between different dimensions

Re: Using sum between different dimensions

Re: Using sum between different dimensions