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: 
jalpashukla
Partner - Contributor III
Partner - Contributor III

Want to see max six months date from the selected date in date picker.

I have one table and one master calendar. If I select any date from the date picker, I should not be able to select any date for more than 6 months. The month range should be within 6 months. 

Exa. If I select 10-jan-2022, the dates should be visible only till Jul considering the last date as 10-jul-2022. 

Thank you in advance!

 

Qlik Sense Business Qlik GeoAnalytics  Qlik Data Gateway   Qlik Compose Qlik Compose for Data Lakes Qlik DataTransfer Qlik Application Automation Qlik Application Automation OEM 

2 Replies
vinieme12
Champion III
Champion III

As below

 

=sum({<Datefield={">=$(=MonthStart(Max(Datefield),-6)))<=$(=Date(Max(Datefield)))"}>}SomeMeasure)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
jalpashukla
Partner - Contributor III
Partner - Contributor III
Author

I tried your script but not sure how to apply this on date picker. It has four sections- Min date, max date, start date and end date. I also dnt have any measure to add. Can you please send me Screen shot or explain me in detail. I'm new to this. 

Thanks,

Jalak