Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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)
Thanks John,
That's what I meant! Thanks a lot!
Great Regards,
Rishi