topic Re: Percentage Computation in QlikView

Percentage Computation

marco_puccetti — Tue, 14 Apr 2015 10:28:41 GMT

Hello i need to compute in a table the percentage of increase\decrease from 2 date related to two years. In this case i have these datas:

Column 1 Column 2 Delta %

4 4 0%

The formula i have used is this: Column(1) - Column(2) / Column(1)

but it returns me 300%.

If i insert the single datas, in the column it returns the correct data.

Can you explain why or to solve it?

Thanks

Anonymous — Tue, 14 Apr 2015 10:36:06 GMT

Try simply:

Column(2) / Column(1)

sunny_talwar — Tue, 14 Apr 2015 10:42:08 GMT

Shouldn't it be Column(2)/Column(1) - 1? But this would give the same result as above, no??

Is it possible to share a sample application where you see this behavior?

Best,

Sunny

jsanchezh — Tue, 14 Apr 2015 10:46:34 GMT

Hello,

I think you left a pair of parentheses out of your expression so, what you are doing is (for example 300% case)

1) Column(1) --> 4

2) Column(2)/Column(1) ---> 1

3) 4-1= 3

Your expression should be: (Column(1) - Column(2)) / Column(1)

Greetings

alexandros17 — Tue, 14 Apr 2015 10:46:56 GMT

Ciao Marco try with:

(Column(1) - Column(2)) / Column(1)

let me know

manojkulkarni — Tue, 14 Apr 2015 10:48:01 GMT

try

it should be (Column(1) - Column(2) ) / Column(1)

marco_puccetti — Tue, 14 Apr 2015 10:54:49 GMT

Thanks now it works!!

Marco