Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date functions

Hi ,all i want to make date into partitions also rejoin that partions ,

Give me some idea about date function

Labels (1)
12 Replies
PradeepReddy
Specialist II
Specialist II

Hi Uday

Quarter :   'Q'&Ceil(Month(Date)/3)   AS  Quarter

Like above expression, you can achieve the rest of the scenarios as well...

Thanks, Pradeep

MK_QSL
MVP
MVP

write below in script.

'Q' & Ceil(Month(Date)/3) as Quarter

jagannalla
Partner - Specialist III
Partner - Specialist III

You can find lot of information on Master Calendar qvw file. Please find through attachment, you can open in personal addition also.