Discussion board where members can get started with QlikView.
I'm using the expression in bold to find the average days of inventory for multiple companies. It works when i select one company, but when i select two companies the formula doesn't work.
Basically, i want to take a company's (2010 inventory + 2011 inventory) /2) /(COGS)*365 What do i need to change in my expression so that it also works when i select two companies? Thank you.
if(Year=Below(Year),(([Total Inventory]+Below([Total Inventory]))/2)/([COGS]))*365
If you add the dimension "Year" in your chart, this will work
But I think you need to understand your formula, press F1 and search what makes each formula of your expression