How to use power function in set analysis?

[Anonymous]

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

[sunny_talwar]

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

)