Discussion board where members can get started with Qlik Sense.
Can any one please help me on this.
I have a date field like below in Time stamp format.
How to extract the Date, Quarter and Monthyear from below field.
Thanks in advance
Go to Solution.
load dateField , (Date(monthstart(dateField), 'MMM-YYYY')) as MonthYear,
'Q' & ceil(month(dateField)/3) as Quarter;
load date(Timestamp#(timestampField,'DD/MM/YYYY hh:mm')) as dateField;
load * Inline [