topic Relative sales in Pivot Chart in QlikView

Relative sales in Pivot Chart

Wed, 16 Feb 2011 16:16:50 GMT

Hi,

I am trying to create the following pivot chart with two dimension: salesman and market

my first expression is straight forward, sum(sales), the second expression should be calculating the % of sales for that market segment, relative to the other market segments. I tried sum(sales)/ sum(TOTAL sales) but that gives me relative to all other salesman. Any ideas?

Relative sales in Pivot Chart

Wed, 16 Feb 2011 16:28:29 GMT

Try this:

SUM(Sales) / SUM (TOTAL <Salesman> (Sales)

Sorry I missed the second dimension BRB also above should be SUM(Sales) / Sum (TOTAL <Salesman> Sales)

SUM(Sales) / Sum( TOTAL <Salesman , Market> Sales)

Relative sales in Pivot Chart

Wed, 16 Feb 2011 16:36:27 GMT

Thanks! Thought I had thought I tried set analysis but i guess not!