Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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