Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

What's the expression for delta?

Hello,

I have data similar to this chart. I want to find the delta and i'm not sure how to form the expression in the table. So:

Inventory2011 - Inventory 2010 / Revenue2011 - Revenue2010

How can the change over year for EACH company? I already have the expression of Inventory to Revenue along with some other simple ratios. Just not sure how the expression should look.

Thanks!

Company
Year
Revenue
Inventory
Company A2011$8$2
Company A2010$10$1
Company A2009$12$3
Company A2008$6$2
Company A2007$13$2
Company B2011$10$5
Company B2010$11$3
Company B2009$9$2
Company B2008$7$6
Company B2007$15$2
Tags (1)
2 Replies
Not applicable

Re: What's the expression for delta?

Hi,

May this will work?

Regards,

Kiran Rokkam.

Not applicable

Re: What's the expression for delta?

Almost. I'm looking for Inventory2011 - Inventory 2010 / Revenue2011 - Revenue2010

2-1 / 8-10 = -.50%

So i just need that one percentage for each company. (only one column that gives me the percentage change over each year)

Community Browser