Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Change formula

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

1 Reply
Not applicable

Re: Change formula

Hi Amv,

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