topic Re: exponential expression in function in QlikView

exponential expression in function

Wed, 24 Apr 2013 13:25:09 GMT

Hello dear community,

i it possible to use exponential expressions in functions (diagrams, tables etc. ?)

var2^2 is not working.

The community search didnt bring up anything besides exponetially formatted numbers (f.e. 123e2)

After a search for exponent or similar, the reference manual only mentions exp(), but this one is based on log e and returns not the desired results.

Also, the syntax is (as always) only mentioned rudimentary.

Is it possible to use exponent expressions ? If so, how ?

Gysbert_Wassenaar — Wed, 24 Apr 2013 14:45:48 GMT

You're probably looking for pow: pow(x,y)

Thu, 25 Apr 2013 08:16:50 GMT

Gysbert Wassenaar wrote:
You're probably looking for pow: pow(x,y)

Yes, that works. The reference manual was not that helpfull there.

exp() seemed to be the right one, but uses "e" as a base value, so you can only insert the exponen.

At pow() the word "exponent" wasnt even mentioned.

"Returns x to the power of y." makes only sense in hindsight to me. power ?

pow(value, exponent) would have been more helpfull.

explaining the function with more than 10 words each would be extremely helpfull. maybe at least 3 sentences.