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,

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.

 

2 Replies
Highlighted
Partner
Partner

Re: Filtering on date to get particular month data

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

Highlighted
Digital Support
Digital Support

Re: Filtering on date to get particular month data

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.