Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-10-31 07:06 AM

Expression error

Dear All,

My Table like below,

BCOD GRO_PREGRO_PRE2013GROWTH
B10019680838176549770
BA0052404853495254320
BB001349624887132150
BW0063788987560071410
MN0015523671128004840
NE0048696306473168030
PS0014029948113792380
WW001090681187713120
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

932 Views
0 Likes
10 Replies
its_anandrjs
Champion III
Champion III
‎2014-11-02 01:52 AM

In response to

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

92 Views
0 Likes