Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

Re: Filtering on date to get particular month data

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))

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Contributor
Contributor

Re: Filtering on date to get particular month data

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.😟

Highlighted
Contributor
Contributor

Re: Filtering on date to get particular month data

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😟

Highlighted
Partner
Partner

Re: Filtering on date to get particular month data

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.

Plees ekskuse my Swenglish and or Norweglish spelling misstakes