Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Formula Help Growth Calc

I have standard formula:

=[$(=$(lTranslation(132,YOY $ vs FxLY)))]

/[$(=$(lTranslation(65,FxLY Sales)))]

which does the trick for positive growth but what if FxLY sales are negative and YOY positive?

how would you write something like this:

if FxLY is negative than calculate =(B1-B2)/ABS(B2) otherwise =[$(=$(lTranslation(132,YOY $ vs FxLY)))]/[$(=$(lTranslation(65,FxLY Sales)))]

where B1 =[$(=$(lTranslation(132,YOY $ vs FxLY)))]

and B2 = [$(=$(lTranslation(65,FxLY Sales)))]