Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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?
Thanks,
H
Quarter Year:
='Q' & ceil(month(Date)/3) & ' - ' & year(Date)
Quarter Month:
='Q' & ceil(month(Date)/3) & ' - ' & date(Date, 'MMM')
Quarter Year:
='Q' & ceil(month(Date)/3) & ' - ' & year(Date)
Quarter Month:
='Q' & ceil(month(Date)/3) & ' - ' & date(Date, 'MMM')
='Q'&ceil(Month('11.3.2014')/3)&'-'&year('11.3.2014') ='Q'&ceil(Month('11.3.2014')/3)&'-'&month('11.3.2014')
Hi
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