Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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