Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

How to find in which Quarter the given date falls.

I want to find Quarter in which given date falls.Any help is appreciated.

Thanks,

Supriya

Tags (1)
1 Solution

Accepted Solutions

Re: How to find in which Quarter the given date falls.

Use a master calendar to create a quarter field and your date will be linked to the quarter field.

Creating A Master Calendar

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

2 Replies

Re: How to find in which Quarter the given date falls.

Use a master calendar to create a quarter field and your date will be linked to the quarter field.

Creating A Master Calendar

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

brunobertels
Valued Contributor

Re: How to find in which Quarter the given date falls.

Hi

Just use the quatername() function

For exemple you have a date field called "date"

add this : quatername(date)

Hope it helps

Bruno

Community Browser