Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I was trying to use power function in set analysis.I know that the formula but i don't know how to represents power in qlikview.
For example i have to calculate like (a+b)^1/(b-a)-1.
Here a=Sum({<year={'2014'}>}sales),b=Sum({<year={'2015'}>}sales) then how to represents above expression with a,b values and how to put power function here and here power n value should be 1/(b-a)
Thanks for your help in advance.
Yuvi
I would use Exp and log functions to do this. May be something like this:
Log(
( (1/(b-a)) * Exp((a+b)) )
)
Log(
( (1/(Sum({<year={'2015'}>}sales) - Sum({<year={'2014'}>}sales))) * Exp((Sum({<year={'2015'}>}sales)+Sum({<year={'2014'}>}sales))) )
)