How to create an expression calculate the quota?

[#1]

Can somebody explain how to create an expression which calculates the quota?

Here is an example of my data:

Date	Customer	Produkt	Measure	Value
03/2015	B	BA	sum	123
03/2015	B	BA	avg	4
03/2015	A	AB	sum	148
03/2015	A	AB	avg	5
04/2015	B	BA	sum	398
04/2015	B	BA	avg	13

I want to have two expressions in my chart, one showing the value Sum  of the selected product, for example AB, which is no problem for me to create, and another one showing the percentage of the value of all products (AB and BA).

Here: AB = 148 thats 22%(=148/669) of all products

Is this possible??

Thank you in advance!

[sunny_talwar]

You can do this:

Produkt as your dimension and the second expression would be:

=Sum(Value)/Sum(TOTAL Value)

HTH

Best,

S

[sunny_talwar]

If this is what you are trying to achieve then PFA

Best,

S

[Gysbert_Wassenaar]

Perhaps something like sum(Value)/sum(total <Produkt> Value). If not, please post a qlikview document that demonstrates the problem.

[CELAMBARASAN]

To get the percentage out of the selections

=Sum(Value)/Sum(Total Value)

To get the percentage out of all

=Sum(Value)/Sum(ALL Value)

[#6]

I thought that as well, but when i try this and select all products, it still doesn't show me 100%. So i have no idea whats wrong. But probably i have to search for the problem in my data.

[sunny_talwar]

You might have a problem like this:

Where your Produkt is missing and your value is given. If now I use the same formula I showed you earlier, I would get something like this: (with Suppress when null is Selected)

If I unselect suppress when null I would get:

I hope this will help you troubleshoot your problem

Best,

S