Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Thank you. i now know to set the date period
Please ILI,
mark the correct answer to close de topic.
thanks