Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
mohbeen_deen
Contributor III
Contributor III

Getting months from fields that have dates as 2017/01/01

Hi guys, I have a two fields that have dates ranging from January 2017 up until May 2018 in the following format 2017/01/01. I want to display leave taken in a monthly view. How do I get these dates to reflect as months (May 2018) in terms of creating an expression?

1 Solution

Accepted Solutions
Anil_Babu_Samineni

May be MonthStart() helps

MonthStart(Your expression of January 2017)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

2 Replies
Anil_Babu_Samineni

May be MonthStart() helps

MonthStart(Your expression of January 2017)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

mohbeen_deen
Contributor III
Contributor III
Author

Thanks Anil, it works