Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Last sunday

Hi community,

I'm trying to store the last sunday in a variable called vLastSunday using makedate function, the format has to be DD/MM/YYYY.

Do you have an idea ?

Thanks,

Victor

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: Last sunday

Maybe this

=Date(WeekStart(Today())-1,'DD/MM/YYYY')

Regards

Pratyush

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: Last sunday

Calculate a field with DayName() and use that field in set analysis.

Date(Max({<DayName = {'Sun'}>} DateField),'DD/MM/YYYY')

Highlighted
Specialist
Specialist

Re: Last sunday

Maybe this

=Date(WeekStart(Today())-1,'DD/MM/YYYY')

Regards

Pratyush

View solution in original post

Highlighted
Partner
Partner

Re: Last sunday

Thanks for your answer,

I tried your solution but i was not very adapted to my app.

I finally did :

makeweekdate(year(today(1)) , week(today(1))-1  , 6 )

and it works well