Create month year and week date in qlik

Aspiring_Developer — Thu, 21 Mar 2024 17:50:57 GMT

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

Re: Create month year and week date in qlik

Ryan_McGregor — Thu, 21 Mar 2024 20:35:24 GMT

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