topic Totals per Customer / Country in QlikView

Totals per Customer / Country

Thu, 01 Jul 2010 08:52:42 GMT

I want to calculate the % sales per customer compared to the total sales of his country ?¨

Please can someone advise how to do this ?

sparur — Thu, 01 Jul 2010 08:57:00 GMT

If I understand your task, you can create expression like this:

sum(Amount) / sum(TOTAL <Country> Amount)

and dimensions: Country, Customer

Thu, 01 Jul 2010 09:04:00 GMT

I do not want to use country as dimension ? Because he want a list of customers.

Thu, 01 Jul 2010 09:05:13 GMT

They want also to select sometimes one customer ?

sparur — Thu, 01 Jul 2010 09:15:02 GMT

so you shoul use AGGR function , see in attachment example

Thu, 01 Jul 2010 10:47:09 GMT

THX It's working correctly.

Thu, 01 Jul 2010 14:54:21 GMT

I think this may be the solution:

sum(Amount) / aggr(sum(Amount), Country)