topic Re: How to create an expression calculate the quota? in QlikView

How to create an expression calculate the quota?

Fri, 20 Nov 2020 18:02:30 GMT

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!

Re: How to create an expression calculate the quota?

sunny_talwar — Mon, 23 Mar 2015 10:37:55 GMT

You can do this:

Produkt as your dimension and the second expression would be:

=Sum(Value)/Sum(TOTAL Value)

HTH

Best,

Re: How to create an expression calculate the quota?

sunny_talwar — Mon, 23 Mar 2015 10:40:48 GMT

If this is what you are trying to achieve then PFA

Best,

Re: How to create an expression calculate the quota?

Gysbert_Wassenaar — Mon, 23 Mar 2015 10:41:24 GMT

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

Re: How to create an expression calculate the quota?

CELAMBARASAN — Mon, 23 Mar 2015 10:46:19 GMT

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)

Re: How to create an expression calculate the quota?

Mon, 23 Mar 2015 11:03:59 GMT

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.

Re: How to create an expression calculate the quota?

sunny_talwar — Mon, 23 Mar 2015 11:11:44 GMT

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,