5 Replies Latest reply: Jan 28, 2015 12:05 PM by Joe Crane RSS

    Dates not matching up in front and back end

    Joe Crane

      First of all, I would like to express how much I despise how QlikView handles dates. The majority of my problems stem from date formatting and the stupid way scripting seems to handle it. Anyway, I have an issue right now where I should have a much greater count of rejoin dates based on the script below (see RejoinFlag line):

      The only problem is that when the script runs I don't have the rejoin counts I should have:


       

      If you look, alllllll those white 201403's on the right should be counted in the sum of rejoins on the left (notice I formatted them EXACTLY the same as I did in the script). Why can't the script compare the numbers casted as such even though they look identical on the front end?? Any help regarding this would be greatly appreciated.

       

      Thanks,

       

      Joe