Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
meckeard
Contributor III
Contributor III

Where clause against a QVD not working

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?

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

2 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Contributor III
Contributor III
Author

Rob,

That did it!  Thanks!