Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharthsoam
Contributor

How to get the maximum date for a specific quarter

I want to fetch the maximum date with respect to quarter selections. If I select quarter Q2 then it should give me the last date for that quarter. For example when I select quarter Q2 it should give me '31-Jul-2017'.

Please suggest me how to do it

6 Replies
shraddha_g
Honored Contributor III

Re: How to get the maximum date for a specific quarter

Date(Max(DateField),'DD-MMM-YYYY') or Date(QuarterEnd(Max(DateField)),'DD-MMM-YYYY')

siddharthsoam
Contributor

Re: How to get the maximum date for a specific quarter

Hi Shraddha thanks for coming once again

I want to return last date of quarter end with respective to selection in quarter filter. I have a quarter filter at frontend

shraddha_g
Honored Contributor III

Re: How to get the maximum date for a specific quarter

Do you have DateField created?

If yes, Date(QuarterEnd(Max(DateField)),'DD-MMM-YYYY')

OmarBenSalem
Esteemed Contributor

Re: How to get the maximum date for a specific quarter

for ur date filter :

=aggr(max(total<quarter> date),date)

try it and tell me what happens

mark6505
Valued Contributor III

Re: How to get the maximum date for a specific quarter

Hi,

Not sure if i am over simplfiying this, but if you have your date field created and you want the date shown to be driven by selection would it not just be MAX(Date)?

Mark

OmarBenSalem
Esteemed Contributor

Re: How to get the maximum date for a specific quarter

Capture.PNG

Capture.PNG

Community Browser