topic Column(X)/Column(Y) problem in QlikView

Column(X)/Column(Y) problem

Fri, 10 Jul 2009 04:19:10 GMT

Hello,

I have a table chart with two expressions that are using the accumulated option (12 steps).

I want to add a third expression which is Column(2)/Column(1). Doing that, the value returned on each row are not the value I am looking for instead it displays something else. (This is not a rounding issue)

I just want to divide the two numbers that are listed in Column 1 and 2 correctly. Anyone have any idea?

Column(X)/Column(Y) problem

prieper — Fri, 10 Jul 2009 04:32:19 GMT

Hi,

sounds quite strange - can you please post an example of your file?

/Peter

Column(X)/Column(Y) problem

Fri, 10 Jul 2009 05:25:41 GMT

I have a hard time recreating the problem with fake data and I rather not upload our GL.

Here is a picture to explain the problem further though:

I want the third column to say 23.5 for March, not 25.4

The expression just look like:


=column(2)/column(1)

Column(X)/Column(Y) problem

Anonymous — Fri, 10 Jul 2009 07:56:00 GMT

What are the expressions in these two columns?

Column(X)/Column(Y) problem

Fri, 10 Jul 2009 20:02:39 GMT

The first one is:




=
sum(Unit)

The second one is:


=(
sum(calc_NetSales)-sum(calc_MarginFixedCostPart)-sum(calc_MarginVariableCostPart))

Both is set to Accumulate 12 Steps back.

Thank you so much for your help!

Column(X)/Column(Y) problem

Fri, 10 Jul 2009 20:16:20 GMT

Did you try to replace the expression by Expression 2 / Expression1 ?

Is it better or not ?

Column(X)/Column(Y) problem

Fri, 10 Jul 2009 20:20:13 GMT

It gives me the same result, so no difference.

Column(X)/Column(Y) problem

Anonymous — Fri, 10 Jul 2009 20:24:54 GMT

I'm pretty much sure that this is because "accumulate".
See what happens if you do not use it.
(If it's the case - I don't have a solution at this time.)

Column(X)/Column(Y) problem

Fri, 10 Jul 2009 20:33:33 GMT

Ok. I'll guess I have to use another way to accumulate the first two columns instead.

Column(X)/Column(Y) problem

Fri, 10 Jul 2009 20:34:14 GMT

Hello ,

If you are using the straight table then go into the Expressions tab on the chart properties and from the total mode select the expression total the default will be sum of rows and it should work.

Let me know how it goes

Talha

Column(X)/Column(Y) problem

Fri, 10 Jul 2009 20:42:10 GMT

That doesn't seem to affect the individual row values though?

/Fredrik

Column(X)/Column(Y) problem

stephencredmond — Fri, 10 Jul 2009 20:55:21 GMT

Hi,

I did a test on this and can replicate the problem. What it is doing is dividing the actual results rather than the accumulated results.

If you change your expressions to include the accumulations in them, then it works (well, it works for me):


RangeSum(Above(Sum(Unit),0,12))


RangeSum(Above((sum(calc_NetSales)-sum(calc_MarginFixedCostPart)-sum(calc_MarginVariableCostPart)),0,12))

Regards,

Stephen

Column(X)/Column(Y) problem

Fri, 10 Jul 2009 21:04:25 GMT

Thank you very much!

That solution is perfect for me.