Dears,
I am trying to create a YTD, MAT, Rolling quarter dimension in qlik sense.
the table has the above headers:
- "M_year" ( field of connecting to other tables)
- "Master Calender Date" (The master date I want to corelate to M_Year)
- "YTD Start Date", "YTD End date", "MAT Start Date", "MAT End date", "RQ Start Date", "RQ End date"
I want to create "YTD" dimension to calculate as follows "YTD start date" to "YTD End date"
same for "MAT" & "RQ"
attached is the table I am using
Any help regarding this matter?
