topic Re: Filtering on date to get particular month data in QlikView

Filtering on date to get particular month data

PM2 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Filtering on date to get particular month data

Vegar — Wed, 25 Mar 2020 06:02:48 GMT

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

Re: Filtering on date to get particular month data

PM2 — Wed, 25 Mar 2020 06:17:30 GMT

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

Re: Filtering on date to get particular month data

PM2 — Wed, 25 Mar 2020 07:08:09 GMT

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😟

Re: Filtering on date to get particular month data

Vegar — Wed, 25 Mar 2020 10:16:17 GMT

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.