topic Re: Compare the values of two numeric variables in QlikView

Compare the values of two numeric variables

salto — Thu, 16 Jan 2014 12:32:10 GMT

Hello,

another (basic?) question:

I have Expr1 and Expr2 as two variables. I want to compare them:

=if(($(Expr1))>($(Expr2)),$(Expr1),$(Expr2))

But QV will no return anything.

The same happens if I use rangemax for this.

Is there any way to compare variables?

Regards.

Re: Compare the values of two numeric variables

kiranmanoharrode — Thu, 16 Jan 2014 12:36:15 GMT

Hi,

Try this, give this in number tab

=if(Num($(Expr1))>Num($(Expr2)),$(Expr1),$(Expr2))

Regards,

Kiran Rode

+91 8976977897

Re: Compare the values of two numeric variables

salto — Thu, 16 Jan 2014 12:43:15 GMT

Hi Kiran,

thanks a lot for your fast answer,but the result still is a '-'

Is there a way to compare the values of two variables?

Re: Compare the values of two numeric variables

sundarakumar — Thu, 16 Jan 2014 12:47:06 GMT

What is the expression in $(Expr1) and $(Expr2),

and where are you using this if condition, in chart or script or text box?

-Sundar

Re: Compare the values of two numeric variables

nilesh_gangurde — Thu, 16 Jan 2014 12:58:54 GMT

Try this:

=if((CHR(39)$(Expr1)CHR(39))>(CHR(39)$(Expr2)CHR(39)),CHR(39)$(Expr1)CHR(39),CHR(39)$(Expr2)CHR(39))

-Nilesh

Re: Compare the values of two numeric variables

salto — Thu, 16 Jan 2014 13:01:00 GMT

Hello Sundar,

Expr1 and Expr 2 are document variables that have been set up like this:

Expr1:num(sum({<"Date"={"<=$(=date(DateID,'DD/MM/YYYY'))"}>} "Amount"))

Expr2:num(sum({<"Date"={"<=$(=date(DateID-30,'DD/MM/YYYY'))"}>} "Amount"))

And I was comparing them in text box. The values for Expr1 and Expr2 were correctly shown in other two text boxes.

But I was not using exactly the syntax above for the variables and it seems to be the reason for them not to be correctly compared.

Now they are correctly evaluated and compared with rangemax or with if(($(Expr1))>($(Expr2)),$(Expr1),$(Expr2))

Thanks a lot for your help!

Re: Compare the values of two numeric variables

salto — Thu, 16 Jan 2014 13:02:24 GMT

Thanks Nilesh for your answer.

I have solved my issue with the above explanation.

Best regards,

Re: Compare the values of two numeric variables

nilesh_gangurde — Thu, 16 Jan 2014 13:17:12 GMT

Great

-Nilesh

Re: Compare the values of two numeric variables

Thu, 16 Jan 2014 13:34:09 GMT

Salto,

Do your Expr1 contain a numeric value ?

if yes, remove the $ expansion sign.

let v1=10;
let v2 = 100;

let v1E= 'v1';

let v2E= 'v2';

let v3 = if(v1 > V2, 2, 3);
let v3E = if($(v1E) > $(v2E), 2, 3);

Both v3 and v3E are = 3

Fabrice

Re: Compare the values of two numeric variables

nizamsha — Thu, 16 Jan 2014 13:52:07 GMT

Below these 2 any one will suits according to ur condition

=if($(vExpr1)>$(vExpr2),$(vExpr2),$(vExpr1))

=if('$(vExpr1)'>'$(vExpr2)',$(vExpr1),$(vExpr2) )

Re: Compare the values of two numeric variables

salto — Thu, 16 Jan 2014 14:07:23 GMT

Hello Nizam, Fabrice,

thank you for your help, the issue is solved already.

Cheers!

Re: Compare the values of two numeric variables

Thu, 16 Jan 2014 14:09:06 GMT

Excellent

What was the answer ?

Fabrice

Re: Compare the values of two numeric variables

salto — Thu, 16 Jan 2014 14:15:06 GMT

Hi Fabrice,

it is explained (not very deeply anyway) in my third post in this thread: the expressions I was using for the variables were not EXACTLY the ones I had posted: they had more conditions and were formatted as currency.

Just to make my question easier to read, I simplified the expressions as below, removing non mandatory conditions and the currency formatting. I did the same in my QV document, just to give a try... and that did the job.

It works with the expressions written like this:

Expr1:num(sum({<"Date"={"<=$(=date(DateID,'DD/MM/YYYY'))"}>} "Amount"))

Expr2:num(sum({<"Date"={"<=$(=date(DateID-30,'DD/MM/YYYY'))"}>} "Amount"))

And I was comparing them in text box. The values for Expr1 and Expr2 were correctly shown in other two text boxes.

But I was not using exactly the syntax above for the variables and it seems to be the reason for them not to be correctly compared.

Now they are correctly evaluated and compared with rangemax or with if(($(Expr1))>($(Expr2)),$(Expr1),$(Expr2))

Best regards!