Discussion Board for collaboration related to QlikView App Development.
I have the following to derive the date, which is working fine:
Date(Date#([FY KPI], 'DD-MM-YYYY')) as FYKPIDate
I tried the following to derive the monthyear but it does not seem to work:
Date(MonthStart(Date#([FY KPI])), 'MMM-YY') as FYKPIMonthYear
How about this
date(monthstart(yourfieldyear), 'MMM-YYYY') as FYKPIMonthYear