3 Replies Latest reply: Jan 27, 2012 8:56 AM by Stefan Wühl

Calculating Share

In qlick view , how can one set an expression where QV could calculate the share of a number in one dimension of the total of the dimension above it , in a pivot table .

i.e. inside the category TVs , we have brands , how can one set an expression to calculate the sales share of this brand in the total sales of the category ?

• Re: Calculating Share

If you have two dimensions, Category and Brand, and your sales field is called Sales, I think it's just

=sum( Sales) / sum(total<Category> Sales)

as expression, i.e. you just need an appropriate total qualifier with dimension list. Please check also the Help.

Then you could format the share e.g in number tab as percentage.

Regards,

Stefan

• Calculating Share

Yes , also , i have a y-axis value as well or a column dimension , which is Branch , and the formula above would only give me the share of the sales of one dimension over the total of the other , but it would not give me the share depending on the y-axis dimension . i should've clarified it better .

• Calculating Share

Maybe an example would help me to understand - it's still a bit unclear to me, but I still think the total qualifier should be the one here,

either try

=sum(Sales) / sum(total<Category, Branch> Sales)

or

=sum(Sales) / sum(total<Branch> Sales)

just include in the total qualifier field list all dimensions that you need to group by.