Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
rajeshlingutla1
Contributor

How to use power function in set analysis?

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

1 Reply

Re: How to use power function in set analysis?

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

)