Two identical timestamps are compared in QlikView, but the logical operation indicates that the value are not equal.
In QlikView a properly formatted timestamp is stored as a decimal value. The visual time stamp is represented by an underlying decimal value. By using the Num() funciton and expanding all available decimal value it is possible to see that the numerical values are different.
In QlikView all decimal values are stored as floating point values, which by definition are not exact value. This means that a floating point value can always fluctuate in value on the last decimal. The fluctuation can occur after any operation or processing of the value, including the actual load from data source.
References to more details about floating point values;
IEEE 754 Standard;
The easiest way is to compare the actual timestamp text instead of the underlying decimal value. This can be done by using the Text() function.
QlikView is optimized for processing of numerical values, so the text comparison could possibly give a negative performance impact on large data quantities with many distinct values. In such case it could be better to try and perform the comparison with integer values. This can be done by multiplying the decimal value and thereafter using Floor() to remove the decimal part of the value.