topic Re: Returned Value of a Formula Not Matching in QlikView

Returned Value of a Formula Not Matching

mphekin12 — Wed, 26 Feb 2014 15:13:58 GMT

Hello,

I’m hoping someone has seen this problem before and can suggest a solution. I have a formula within a chart (Straight Table) that returns a value called Mix Builder which is highlighted in yellow on the attached snapshot. If I use the same formula in a text box outside of the chart to display the Mix Builder, which is highlighted in green, the numbers do not match.

I believe the reason for this is due to the fact that we are multiplying each line item by a % of Total Sales within the chart, but outside
of the chart, that number becomes 100%. Can anyone suggest a way to make these two numbers match? I really need to use this number outside of the chart and it is imperative that they match.

Any information would be appreciated!

Re: Returned Value of a Formula Not Matching

alexandros17 — Wed, 26 Feb 2014 15:19:04 GMT

Aggr by the same dimension of the chart ...

Re: Returned Value of a Formula Not Matching

mphekin12 — Wed, 26 Feb 2014 15:54:30 GMT

Thanks for the reply Alessandro but I'm still not getting the correct answer. The % of Total Sales is still 100%.

Re: Returned Value of a Formula Not Matching

Anonymous — Wed, 26 Feb 2014 16:03:53 GMT

Hi,

where do you come up with 35.842 ?

is it a weighted average %?

Antoine

Re: Returned Value of a Formula Not Matching

mphekin12 — Wed, 26 Feb 2014 16:07:59 GMT

It is the Profit (which I didn't show on screenshot) / Sales.

Re: Returned Value of a Formula Not Matching

Anonymous — Wed, 26 Feb 2014 16:18:49 GMT

Then I think your error is in the % of sales column.

look:

$ 80.174.229,00	25,255	23,20%	23730770,04	=+$B$9C1F1/100
$ 21.923.464,00	5,103	6,35%	7150995,488	=+$B$9C2F2/100
$ 55.260.982,00	15,473	15,99%	21917058,07
$ 46.483.843,00	13,166	13,45%	18774359,35
$ 117.958.437,00	33,283	34,14%	44410171,95
$ 14.051.721,00	4,699	4,07%	4880303,221
$ 9.606.138,00	2,729	2,78%	2953022,883
$ 52.868,00	0,293	0,02%	22673,49916
$ 345.511.682,00	100,001	100,00%	123839354,5

Re: Returned Value of a Formula Not Matching

Wed, 26 Feb 2014 16:23:46 GMT

Possible to attach a sample file with few records.

Re: Returned Value of a Formula Not Matching

mphekin12 — Wed, 26 Feb 2014 16:29:06 GMT

Eruditio,

I only posted the columns that were in the formula that I am trying to match up. The numbers in the % of Sales column are correct.

Thanks!

Re: Returned Value of a Formula Not Matching

mphekin12 — Wed, 26 Feb 2014 16:29:36 GMT

Ajay,

Unfortunately there isn't a way for me to attach a sample file.

Thank you!