topic Re: Percentage over two dimensions in a pivot table in QlikView

Percentage over two dimensions in a pivot table

Wed, 11 May 2011 20:03:45 GMT

Dear users,

I would like to know if it's possible to calculate a % of the total of one dimension when 2 dimensions are defined in Qlikview.

I have one dimension which is called 'Prodline' (lowest level) and the other 'Category' (highest level). In the image you can see that I have calculated a percentage of the client total over the dimension 'Category'. The 10% of '1e lijn' for 'Category' abc is based on the formula "(Sum (count_session))/(sum( TOTAL count_session))" which is now 28 (1e lijn)/283 (total) = 10% where I would like to base this on 28/69(Total of 1e lijn). How can I manage this?

Please advice.

Regards,

Rishi

Re: Percentage over two dimensions in a pivot table

johnw — Wed, 11 May 2011 23:32:58 GMT

If I understood the question, one of these. I wasn't clear which you wanted.

sum(count_session)/sum(total <Category> count_session)
sum(count_session)/sum(total <ProdLine> count_session)

Re: Percentage over two dimensions in a pivot table

Thu, 12 May 2011 07:51:50 GMT

Thanks John,

That's what I meant! Thanks a lot!

Great Regards,

Rishi