Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview formula

Hi, how can I achieve following formula in qlikview that works in excel.

(x)^(1/6)

which is 6th root of  x where x is any integer. for eg. if x is 64 then x^(1/6) gives 2.

Thanks

Lax

1 Solution

Accepted Solutions
salto
Specialist II
Specialist II

Hello,

check the pow(x, 1/6) function.

Hope this helps.

View solution in original post

4 Replies
salto
Specialist II
Specialist II

Hello,

check the pow(x, 1/6) function.

Hope this helps.

Not applicable
Author

Hi Laxmikant,


Pow(64,1/6) gives you 2.

Thanks SALTO.

Regards,

Vijay

jagan
Partner - Champion III
Partner - Champion III

Hi,

Try Pow() like this

=Pow(x, 1/6)

=pow(64, 1/6) -- will return 2

Regards,

Jagan.

Not applicable
Author

thanks