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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to fetch last two months data

Hiii,I am uploading the excel sheet that contains data from 01/04/2012 to 04/30/2012 date.so i want  the data that lies between 02/01/2012 to 03/31/2012

Please help me out

1 Reply
MayilVahanan

HI,

     Load * from xlfile where Date >='02/01/2012' and Date <='03/03/2012';

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.