Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
victor_greffet
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

1 Solution

Accepted Solutions
prat1507
Specialist
Specialist

Maybe this

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

Regards

Pratyush

View solution in original post

3 Replies
shraddha_g
Partner
Partner

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

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

prat1507
Specialist
Specialist

Maybe this

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

Regards

Pratyush

View solution in original post

victor_greffet
Partner
Partner
Author

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