Discussion board where members can get started with QlikView.
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.
May this will work?
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)