Create month year and week date in qlik

[Aspiring_Developer]

Hi All ,

I have below data fields :-

Left(Year(YearName(TempDate,0,4)),5) & '-'& IF(Month(TempDate)<=3, Month(TempDate)+9, Month(TempDate)-3) as Fiscal_Month_Year

IF(Month(TempDate)<=3, Month(TempDate)+9, Month(TempDate)-3) as New_Fiscal_Month_Num,

Dual(Month(TempDate), IF(Month(TempDate)<=3, Month(TempDate)+9, Month(TempDate)-3)) as New_Fiscal_Month,

Below is the output:-

I am trying to create Month year filter in this format :- MMM-YY . I used monthname and date filter but it is giving me dates Apr-1988 . 

And for week , I  am trying to create dates for that week , for example week 40 then it should show the dates for week 40 in the dimension.

Can anyone please help me ? @sunny_talwar 

Thanks in advance

[Ryan_McGregor · Accepted solution]

Hello there, 

For the Month / Year filter, you could use this:

(Dual(Month(TempDate), IF(Month(TempDate)<=3, Month(TempDate)+9, Month(TempDate)-3))&'-'&right(Year(TempDate),2)) as MonthYearFilter

As for the Week, you can use this:

WeekStart(TempDate)&'-'&WeekEnd(TempDate) as WeekFilter

Hope this helps,

Ryan