Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Roliba001
Contributor III
Contributor III

6 Months Range - Sep to Feb

Hi,

I need to creat two date ranges variables

vWinter - between March and August       (Example - March16 until August16)

vSummer - between September and February from next year  (Example - September16 until February17)


Anyone can help me to creat them?




2 Replies
Anil_Babu_Samineni

Can we know, How your data looks like. And What is the Maximum date records you have?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Colin-Albert

Effectively you are using a financial (fiscal) year that runs March - Feb or Sept - Aug.

This posts shows how you can implement this  Fiscal Year