topic % of Total in QlikView

% of Total

pkelly — Thu, 19 May 2011 16:00:23 GMT

Hi ...

I am trying to achieve the following

Sales = sum(sin_Sales)

How do I calculate the % Total based on the sub total for each %ProductFamilyKey

I have tried playing around with the aggr function with no success so far.

Any assistance greatly appreciated.

Regards

Paul

IAMDV — Thu, 19 May 2011 16:02:55 GMT

Paul - Please can you post the QV document with sample data?

Cheers - DV

Thu, 19 May 2011 16:09:10 GMT

If "Perc of Total" means "Perc of Province", you can write:

= sum(sin_Sales) / sum(Total <Province> sin_Sales)

Or "give me the sales for each Family/Province in percent on the total for the current Province".

Hope it helps!

pkelly — Fri, 20 May 2011 06:43:56 GMT

Thanks Chiesa that did the trick...