Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
frizqie17
Contributor
Contributor

Load data previous month based on date column

Hello,

 

I have a table that contain a column 'last update' which formated as a date (MM/DD/YYYY). I want to extract the data from previous month until now based on 'last update' column. How's the script should be?

 

Thanks.

2 Replies
lotfiblo
Contributor III
Contributor III

Hi @frizqie17 ,

You can do this:

LOAD *
from YouDatasource
Where [last update] >= MonthStart(Today(), -1);

 

Best,

Lotfi

Use Qalyptus for your Qlik Sense and QlikView Reporting
Connect with me on Linkedin
frizqie17
Contributor
Contributor
Author

Ok Thanks @lotfiblo , i'll try it