Where clause against a QVD not working

[meckeard]

I have records in a QVD that look like this:

AccountNumber  |  Bal_Date  |  Balance

---------------------------------------------------------------------------

123456                   | 43585            | 1000.00

123456                   | 43585            | 2000.00

123456                   | 43585            | 3000.00

I don't know why the values for Bal_Date is in that format but Qlik converts 43585 to 4/30/2019 under Settings --> Document Properties --> Number --> Date.  

Since this QVD has so many records, I only want to load any where Bal_Date = 4/30/2019 or 43585 but it isn't working.  It seems to return the 4/30/2019 records but other records as well.  These other records have a value for AccountNumber but nothing for the other 2 fields.   I tried formatting using Date and Date# but that didn't help.  What am I doing wrong?

[rwunderlich · Accepted solution]

What is your where clause?  I expect it should be:

Where Bal_Date = MakeDate(2019,4,30)

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[meckeard]

Rob,

That did it!  Thanks!