Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

Date Functiom

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

4 Replies
JordyWegman
Partner
Partner

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

Work smarter, not harder
RKULKARNI4
Contributor III
Contributor III
Author

what is meant by  Q' i didn't understand.Please let me know

 

Almen
Creator
Creator

Try this:

 

Dual('Q'&Num(Ceil(Num(Month(Max([Date])))/3)),Num(Ceil(NUM(Month(Max([Date])))/3),00)) 
Chanty4u
Champion III
Champion III

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;