Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
elaineng
Contributor III
Contributor III

Date picker > Customised Range

elaineng_0-1684127433052.png

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?

 

Labels (3)
5 Replies
Rohan
Specialist
Specialist

Hi,

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

Rohan_0-1684128802886.png

Thanks & Regards,

Rohan. 

 

elaineng
Contributor III
Contributor III
Author

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
Creator III
Creator III

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
Contributor III
Contributor III
Author

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.

elaineng_1-1684129771296.png

 

 

Rohan
Specialist
Specialist

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.