Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

beck110979
Valued Contributor III

Calculation with roots

Hi Folks,

i have a question, how to solve the issue with calculcation of roots (please see attached screenshot)

my values are:

J = 10000

B = 100

E = 80

L = 0,10

Does anybody have any idea?

thanks a lot

Beck

5 Replies

Re: Calculation with roots

You can use Pow() or Sqrt() function. For example

Pow(2, 0.5)

or

Sqrt(2)


Capture.PNG

sasiparupudi1
Honored Contributor III

Re: Calculation with roots

may be this?

beck110979
Valued Contributor III

Re: Calculation with roots

Thanks a lot Sunny, i will try and will report you

beck110979
Valued Contributor III

Re: Calculation with roots

Thanks a lot Sasidhar,

do you have this issue in Qlik Sense-file. i am not able to open your Qlik View -file

Thanks a lot

Beck

sasiparupudi1
Honored Contributor III

Re: Calculation with roots

If you create variables

J,B,E,L

with values

10000,100,80,0,10

then , you may use the below expression

sqrt((2*B*J)/(E*L))

hth

Community Browser