Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
R_Mendoza
Contributor III
Contributor III

Load data

Hello everyone,
I have a problem loading the data:
"the condition "WHERE" does not work"

where am I wrong??? Thanx.

 

[Final]:
LOAD *
FROM [lib://QVD Extraction (server_qliksense)/final.qvd] (qvd)
Where Year(%Date) >= Year(Now()) - 4;

R_Mendoza_1-1589956019568.png

R_Mendoza_0-1589956548136.png

 

 

3 Replies
agigliotti
Partner - Champion
Partner - Champion

your WHERE clause seems to be correct.
How does your field name %Date looks like?

R_Mendoza
Contributor III
Contributor III
Author

R_Mendoza_0-1589963016236.png

 

agigliotti
Partner - Champion
Partner - Champion

could you attach that QVD file to look at?