Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
PM2
Contributor
Contributor

Filtering on date to get particular month data

Hi community,

Please help me in getting the output of a particular month from an excel file having data from 2001-2020.

I want to extract only Jan 2020 data from the file.

Below is the script have written

Load

Opendate

Feom xls file

Where Opendate>=Date#('01-Jan-20','DD-MMM-YY')

This is not giving me only jan 20 month data.

4 Replies
Vegar
MVP
MVP

Your script is loading all data larger than January 1 2020.

You can do like this to set an upper and lower limit. (Assuming that Opendate is a date field in excel)

LOAD *

WHERE MonthName(Opendate)= MonthName(makedate(2020,1))

PM2
Contributor
Contributor
Author

Hi Vegar,

Thanks but 0 lines fetched on reloading.

In my excel the date is in cuatom format dd-mmm-yy.

I have script

Load

*Resident Data

Where ( in condition on getting only jan month 20 data). 

On applying where condition mentioned by you 0 lines fetched. I am sorry but new to qlikview.😟

PM2
Contributor
Contributor
Author

Hi @Vegar 

not getting the output. 0 lines fetched. Column in excel in which dates mentioned is in custom format DD-MMM-YY.

Please help😟

Vegar
MVP
MVP

Could you post a sample excel and QV-docukent? It does not need to be the same data, but it needs a sample where the date fileter issue can be tested.