Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Want caculate Growth% in backend not in front end?


Hi All,

I want to calculate growth% in backend only, how can write expreession at backend.

Formulae:

Growth%=((Max year Qty-Prev year Qty)/Prev year qty)*100.

Input:

LocationYearQty
A201210
A201350
A201420
B201220
B201360
B201480
C2012100
C201340
C2014200

Output:

LocationGrowth%-2013Growth%-2014
A
B
C

Note;

Don't want to caculate at froent end need at backend only.

2 Replies
gupta_n8
Valued Contributor II

Re: Want caculate Growth% in backend not in front end?

PFA

The solution would help you out......

Regards

Nitin

Not applicable

Re: Re: Want caculate Growth% in backend not in front end?

Hi Nitin,

tx for response.

can u plase check my application. here i m not getting growth for 2013 year.

i used your formula.

Thanks,

Ashok.

Community Browser