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,

IN EXCEL I HAVE DATE FORMAT IN CUSTOM AS DD-MMM-YY from 2001 to 2020

IN QLIKVIEW I WANT EXTRACT DATA ONLY FOR Jan 20 month.

Load

*Resident Data

Where MonthName(Opendate)= MonthName(MakeDate(20,'Jan'))

0 lines fetched. Please help in getting the output.

Re: Filtering on date to get particular month data

ashishkalia — Wed, 25 Mar 2020 07:37:00 GMT

Hi @PM2 ,

In your condition:
Where MonthName(Opendate)= MonthName(MakeDate(20,'Jan'))
In Year: Instead of 20 put 2020
In Month: Put Month Number without any quotes.

Where MonthName(Opendate)= MonthName(MakeDate(2020, 01))

This will help.

Regards,
AK

Re: Filtering on date to get particular month data

Brett_Bleess — Tue, 21 Apr 2020 15:59:32 GMT

Did Ashish's suggestion work for you? If so, be sure to close out your thread by using the Accept as Solution on his post to give him credit for the help and let the other Members know it worked.

You may want to check the following Design Blog posts too, might be helpful with things:

https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849

https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157

If you want to look around yourself, use the following link to search just that area:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett