Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
iliaisyah
Contributor III
Contributor III

mmm-yyy to year

My excel have a date format mmm-yyy but in qlikview i want to make a list box of year n month. is it possible?

4 Replies
sunny_talwar

May be this

Month(Date) as Month,

Year(Date) as Year

or

Month(Date#(Date, 'MMM-YYYY')) as Month

Year(Date#(Date, 'MMM-YYYY')) as Year

PabloTrevisan
Partner - Creator II
Partner - Creator II

You have to check if qlik is reading this excel data as DATE or STRING, try to use the date function with the mask you have this way:


Month (Date (datefield, 'MMM-YYY')) AS MONTH,

Year (Date (datefield, 'MMM-YYY)) AS YEAR'


OR

DATE (datefield, 'MMM') AS MONTH,

DATE (datefield, 'YYY') AS YEAR

iliaisyah
Contributor III
Contributor III
Author

Thank you. i now know to set the date period

PabloTrevisan
Partner - Creator II
Partner - Creator II

Please ILI,

mark the correct answer to close de topic.

thanks