topic Re: Growth formula in QlikView

Growth formula

Wed, 19 Jul 2017 16:43:20 GMT

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)))]

Wed, 19 Jul 2017 17:27:08 GMT

anyone?

Anonymous — Wed, 19 Jul 2017 17:52:38 GMT

Can't you just put fabs() around your denominator?

Wed, 19 Jul 2017 17:59:17 GMT

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

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

like the above? it didnt work.

Wed, 19 Jul 2017 18:42:36 GMT

just to make sure what i am looking for:

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)))]

Anonymous — Wed, 19 Jul 2017 18:45:41 GMT

I mean like this

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

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

sunny_talwar — Wed, 19 Jul 2017 19:06:47 GMT

What is FxLY here? and what is B1, B2 here? are these all field names?

Wed, 19 Jul 2017 19:41:58 GMT

it worked. thank you.