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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Confusion with InQuarter function

Hi,

I am trying to using the InQuarter function to detect a date which is in the previous quarter. So using a basedate of 12/31/2009 I would like to recognise 09/30/2009 as date in the previous quarter. Using the formula below, this is not happening. Would anyone know why this is the case?

Thanks for your help

=InQuarter('2009-12-31','2009-09-30',-1)

1 Solution

Accepted Solutions
vgutkovsky
Master II
Master II

Just reverse your dates: =InQuarter('2009-09-30','2009-12-31',-1)

Regards,

View solution in original post

2 Replies
vgutkovsky
Master II
Master II

Just reverse your dates: =InQuarter('2009-09-30','2009-12-31',-1)

Regards,

Not applicable
Author

Thanks Vlad. It looks I misunderstood the function.