# New to Qlik Sense

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

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for
Did you mean:
Creator

## Get Current Qtr from different date fields

Hi - I have to get current Qtr and next Qtr from 2 different date fields from 2 diff. tables.How can I do that ?I have the attached MC.

Table1:

ID Date1

1  7/9/2020

2 7/9/2019

3 7/9/2021

Table 2:

ID Date2

1  6/9/2020

2 6/9/2019

3 6/9/2021

Then I have to replace the Qtr in the expression below.

I have 8 Expressions which should autoupdate for the rolling next 24 months.

Exp1 -

=if(year([Date1])=2020 and 'Q' & ceil(month([Date1])/3) ='Q3'

and

year([Date2])=2020 and 'Q' & ceil(month([Date2])/3) ='Q3','Current'

Exp2 -

=if(year([Date1])=2020 and 'Q' & ceil(month([Date1])/3) ='Q4'

and

year([Date2])=2020 and 'Q' & ceil(month([Date2])/3) ='Q4','Next1'

Exp3 -

=if(year([Date1])=2021 and 'Q' & ceil(month([Date1])/3) ='Q1'

and

year([Date2])=2021 and 'Q' & ceil(month([Date2])/3) ='Q1','Next2'

Thank you very much.

Labels (9)

0 Replies