topic Re: Qlikview formula in QlikView

Qlikview formula

Mon, 02 Dec 2013 08:54:20 GMT

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

salto — Mon, 02 Dec 2013 08:59:19 GMT

Hello,

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

Hope this helps.

Mon, 02 Dec 2013 09:25:12 GMT

Hi Laxmikant,

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

Thanks SALTO.

Regards,

Vijay

jagan — Mon, 02 Dec 2013 09:26:16 GMT

Hi,

Try Pow() like this

=Pow(x, 1/6)

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

Regards,

Jagan.

Mon, 02 Dec 2013 09:41:43 GMT

thanks