topic Re: macro exp into qlikview chart exp.need help please?? in QlikView

macro exp into qlikview chart exp.need help please??

Mon, 07 Jul 2014 02:17:45 GMT

hi all,

Can someone help me out the conversion of following macro exp into qlikview chart exp.

which of the following is correct??

(a3 * K ^ 3)= pow((a3 * K),3)

(a3 * K ^ 3)= (a3 *pow( K , 3))

regards,

Sahana

Re: macro exp into qlikview chart exp.need help please??

jagan — Mon, 07 Jul 2014 03:27:15 GMT

Hi,

Try like this in qlikview

=pow((a3 * K),3)

=a3 * pow(K,3)

Regards,

Jagan.

Re: macro exp into qlikview chart exp.need help please??

Mon, 07 Jul 2014 04:07:31 GMT

hi Jagan thanks for the response.

but I want to know which of the two expressions are correct?? ie in between power and multiplication which comes first so that accordingly we can put the brackets.

regards,

Sahana

Re: macro exp into qlikview chart exp.need help please??

tresB — Mon, 07 Jul 2014 04:49:37 GMT

'^' has the greater precedence than '*' . So,correct one is- (a3 *pow( K , 3))

Re: macro exp into qlikview chart exp.need help please??

jagan — Mon, 07 Jul 2014 05:27:43 GMT

Hi Sahana,

This is the correct expression

(a3 * K ^ 3)= (a3 *pow( K , 3))

Regards,

Jagan.

Re: macro exp into qlikview chart exp.need help please??

Mon, 07 Jul 2014 07:13:16 GMT

thanks a lot