7 Replies Latest reply: Jun 24, 2016 7:27 PM by Marco Wedel RSS

    Comparing these two numbers

    Matt Maino

      I am using Qlikview to do some data validation between two systems. For the first system I am importing a csv file, and for the second I am bringing in data from an excel file. I am running into an issue when comparing a dollar amount field. The first system has leading zeroes in it's dollar amount field, it looks like this: 000000000000865.55, and the second system does not have the leading zeroes so it looks like: 865.55. Qlikview is telling me that these two values are not equal and I can't seem to get it to understand that they are. I have tried num() and ltrim() and they both do not work. Is there any way for me to do this? Thanks