Date picker > Customised Range

[elaineng]

Field Formula

=Date(Floor(BookDate),'DD/MM/YYYY')

I would like to customise Last $ days to Last Week (Mon - Sunday of BookDate), is that possible?

[Rohan]

Hi,

Please check the image, there is a option just below for the value to be assigned to $ :

Thanks & Regards,

Rohan. 

[elaineng]

Sorry, don't get you. is not last x days. Is always Last Week, which is always Last Monday to Last Sunday regardless which Weekday I am in.

[G3S]

this might help:
https://help.qlik.com/en-US/sense/February2023/Subsystems/Hub/Content/Sense_Hub/Scripting/DateAndTim...

or

if (BookDate >=weekstart (week(today())-1)and BookDate <=weekend (week(today())-1),BookDate)

[elaineng]

HI @Rohan 

I don't want to hard code in my columns. But make available in date picker as a selection for user to select. User is not using Last 7 days. I would like to replace with Last Week.

[Rohan]

Hi,

It seems you will have to customize the extension the itself to add such a range. or you can use a Qlik button & toggle your equations based on the variable set by this Qlik Button.

Thanks & Regards,

Rohan.