Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
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 - Master III
Partner - Master III

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 - Master III
Partner - Master III

could you attach that QVD file to look at?