Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
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
MVP
MVP

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
R_Mendoza
Contributor III
Contributor III
Author

R_Mendoza_0-1589963016236.png

 

agigliotti
MVP
MVP

could you attach that QVD file to look at?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it