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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
upaliwije
Creator II
Creator II

Where condition in QVD file

I am loading data from a QVD file with a where condition as follows

Load *

......

(qvd)

WHERE NOTE>=100  AND NOTE<=1000 AND  YEAR>=2014 and MONTH=1;

This where condition I want to modify as follows

WHERE NOTE>=100  AND NOTE<=110 and NOTE>=120  AND NOTE<=1000 AND  YEAR>=2014 and MONTH=1;

Is this possible ? pls educate me.

11 Replies
kamalqlik
Partner - Specialist
Partner - Specialist

Hi Please apply the below logic.

where ((note >=100 and  note <=110) or (note >=120 and note <=1000)) and year >= 2014 and month=1;

Regards,

Kamal

upaliwije
Creator II
Creator II
Author

Thanks