I have a date field in my Fact table. Now using the DATE I need to create Quarter - Year and Quarter - Month.
Can someone help me with the script?
='Q' & ceil(month(Date)/3) & ' - ' & year(Date)
='Q' & ceil(month(Date)/3) & ' - ' & date(Date, 'MMM')
Looks like you may well need to be introduced to the concept of a Master Calendar.
Search this QlikCommunity for Master Calendar and you'll get plenty of hits.
Best Regards, Bill
Retrieving data ...