Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I need to apply the formula :Quarter(LastDay of Max(Date)) Please let me know it can be done in Qliksense.
Please advise
Regards
RK
Hi,
Check this formula:
Q' & Ceil(Month(Date)/3) as QUARTER
From this post: https://community.qlik.com/t5/New-to-QlikView/To-find-Quarter-from-Date/td-p/1447723
Jordy
Climber
what is meant by Q' i didn't understand.Please let me know
Try this:
Dual('Q'&Num(Ceil(Num(Month(Max([Date])))/3)),Num(Ceil(NUM(Month(Max([Date])))/3),00))
QuartersMap:
MAPPING LOAD
rowno() as Month,
'Q' & Ceil (rowno()/3) as Quarter
AUTOGENERATE (12);
main:
load *,
ApplyMap('QuartersMap', month(TempDate), Null()) as Quarter
resident FirstTableName;