Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
As below
=sum({<Datefield={">=$(=MonthStart(Max(Datefield),-6)))<=$(=Date(Max(Datefield)))"}>}SomeMeasure)
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