topic Re: Expression error in QlikView

Expression error

Fri, 31 Oct 2014 11:06:49 GMT

Dear All,

My Table like below,

BCOD	GRO_PRE	GRO_PRE2013	GROWTH
B100	19680838	17654977	0
BA00	52404853	49525432	0
BB00	13496248	8713215	0
BW00	63788987	56007141	0
MN00	15523671	12800484	0
NE00	48696306	47316803	0
PS00	14029948	11379238	0
WW00	10906811	8771312	0
Total	238527663	212168602	0

I want to calculate the growth. the expression I have used is as follows.

SUM('GRO_PRE'-'GRO_PRE2013')*100/GRO_PRE2013

But output was not calculated.

Please help in this regard.

Regards,

Priyantha

Re: Expression error

Fri, 31 Oct 2014 11:13:42 GMT

Hi,

Try this it will work

(SUM(GRO_PRE) - Sum(GRO_PRE2013))*100/GRO_PRE2013

Re: Expression error

MK_QSL — Fri, 31 Oct 2014 11:13:47 GMT

Try

((SUM(GRO_PRE)-SUM(GRO_PRE2013))/GRO_PRE2013)*100

NUM(((SUM(GRO_PRE)-SUM(GRO_PRE2013))/GRO_PRE2013),'#0.00%')

Re: Expression error

Fri, 31 Oct 2014 14:24:20 GMT

Attached

Re: Expression error

Fri, 31 Oct 2014 14:44:31 GMT

Hi Priyantha,

An optimal way to calculate the growth would be:

sum(GRO_PRE) / sum(GRO_PRE2013) - 1

Re: Expression error

Anonymous — Fri, 31 Oct 2014 15:20:47 GMT

Hi,

your problem is the qoutes.

Re: Expression error

Sun, 02 Nov 2014 06:31:47 GMT

Hi Jannet,

I used the quotes due to "GRO_PRE" and the "GRO_PRE2013" are also calculated though expressions.

Regards,

Priyantha.

Re: Expression error

anbu1984 — Sun, 02 Nov 2014 06:39:46 GMT

Are these "GRO_PRE" and the "GRO_PRE2013" label names of expressions?

Re: Expression error

its_anandrjs — Sun, 02 Nov 2014 06:41:53 GMT

Try like below expression and remove single quotes but you can use double quotes

SUM(GRO_PRE - GRO_PRE2013 )*100 / GRO_PRE2013

SUM("GRO_PRE" - "GRO_PRE2013" )*100 / "GRO_PRE2013"

Where you get error in the expression

Regards

Anand

Re: Expression error

Sun, 02 Nov 2014 06:49:46 GMT

YES

Re: Expression error

its_anandrjs — Sun, 02 Nov 2014 06:52:24 GMT

You can use at is the label name that you provide to the expressions GRO_PRE and GRO_PRE2013 in the formula which is refers the expressions.

SUM("GRO_PRE" - "GRO_PRE2013" )*100 / "GRO_PRE2013"

Regards

Anand