How to use power function in set analysis?

Anonymous — Sun, 15 Nov 2015 17:02:30 GMT

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

Re: How to use power function in set analysis?

sunny_talwar — Sun, 15 Nov 2015 17:11:02 GMT

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

)

topic Re: How to use power function in set analysis? in QlikView

How to use power function in set analysis?

Re: How to use power function in set analysis?