Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
sunainapawar
Creator
Creator

Max Date of current Quarter if date column has date till future

Hello All,

I have one small scenario. I have a date column which has end date  till future like 01-02-2040, 03-02-2045.

This is basically a contract end date. So this can have future values. Now i have to get the max date of Current Qtr i.e,., 

2021-2022 . Max date should be like till today. So whichever Contracts have end date of current Qtr till today(26-05-2021) must be shown.

I know how to get a max based on date filed but since End date has future dates, not sure how to get the count of contracts expired till date.

Please assist.

 

1 Solution

Accepted Solutions
canerkan
Creator
Creator

Hi Sunainapawar,

i am not sure if this is what you are looking for, but try making two more fields in the load script. For Quarter and Year of EndDate

  • Ceil(Month(EndDate)/4) as Quarter
  • Year(EndDate) as Year

and then simply use these fields to compare with today's quarter and year in set analysis like:

Count({$<Quarter = {"=Ceil(Month(Today())/4)"}, Year = {"=Year(Today())"}>}ContractID)

 

Regards,

Can

 

View solution in original post

2 Replies
canerkan
Creator
Creator

Hi Sunainapawar,

i am not sure if this is what you are looking for, but try making two more fields in the load script. For Quarter and Year of EndDate

  • Ceil(Month(EndDate)/4) as Quarter
  • Year(EndDate) as Year

and then simply use these fields to compare with today's quarter and year in set analysis like:

Count({$<Quarter = {"=Ceil(Month(Today())/4)"}, Year = {"=Year(Today())"}>}ContractID)

 

Regards,

Can

 

View solution in original post

sunainapawar
Creator
Creator
Author

Hello Canerkan,

Thanks for the response, Actually i was looking for same. I solved it using today() in the expression.