topic Expression result based on value in QlikView

Expression result based on value

Fri, 21 Mar 2014 10:01:28 GMT

Hi,

I would like to create an expression which the result would be dependent on max value.

For example:

if the max value of the expression would be 0.001, then multiply the value by 10 until the value reach 1 (in this case, multiply by 1000),

but if the max value would be 0.1, then only multiply by 10.

How can i do this in an expression without creating 10 if clauses?

Thank you,

Emílio

Gysbert_Wassenaar — Fri, 21 Mar 2014 10:47:18 GMT

0.001 * pow(10, -floor(log10(0.001))) = 1. Replace 0.001 with the expression that returns the value you want multiplied.

Fri, 21 Mar 2014 10:49:56 GMT

Thks ,

Regards,

Emílio