topic Re: Wrong result when comparing two numbers in QlikView

Wrong result when comparing two numbers

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'm quite new to qlikview and I have a strange result in my script

I try to compare two numbers in an "if" statement but I don't go inside the condition even if the condition seems true :

My first variable

TempMaxDate:

LOAD

Max (_comptaTimeStamp)as MaxDate

from $(vQVDPath)DATA_COMPTA.qvd (qvd);

Let vMaxQVDdate = Peek('MaxDate',0,'TempMaxDate');

Drop table TempMaxDate;

My second variable

Let vFileDate = num(date#(FileTime('$(file)'),'DD/MM/YYYY hh:mm:ss[.fff]'));

When I debug my code I get

But I don't enter in the if statement

Any Idea ?

Thank you

Re: Wrong result when comparing two numbers

sunny_talwar — Mon, 09 Jan 2017 17:31:09 GMT

Does this make any difference (not adding Num() function)?

If $(vFileDate) > $(vMaxQVDDate) then

.....

Re: Wrong result when comparing two numbers

Mon, 09 Jan 2017 17:35:43 GMT

I get this message

Re: Wrong result when comparing two numbers

sunny_talwar — Mon, 09 Jan 2017 17:49:12 GMT

How about this? Putting the expression within single quotes

If '$(vFileDate)' > '$(vMaxQVDDate)' then

Re: Wrong result when comparing two numbers

Mon, 09 Jan 2017 17:55:15 GMT

Yeah !

It worked, thank you very much Sunny, Even if I don't understand why my first try was wrong ...

If I understand I'm comparing two strings with your method ?

Re: Wrong result when comparing two numbers

sunny_talwar — Mon, 09 Jan 2017 18:32:15 GMT

To tell you the truth, I don't know what it's doing. May be someone else can guide us here

Re: Wrong result when comparing two numbers

swuehl — Mon, 09 Jan 2017 23:07:53 GMT

Try

IF vFileDate > vMaxQVDDate THEN

IMHO, using dollar sign expansion just adds potential issues with number literal formatting here (e.g. decimal separator needs to be a point for a constant number used in the script or expression). And using an implicit string interpretation / string comparison doesn't make it easier.

It should then also be enough to use

Let vFileDate = FileTime('$(file)');

Re: Wrong result when comparing two numbers

Tue, 10 Jan 2017 08:47:11 GMT

Hello Stefan and thank you for your answer, you're right !

I removed the $ and everything is ok even with Let vFileDate = FileTime('$(file)');

Thank' again