Qlik Community

Qlik Sense App Development

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

victor_greffet
New Contributor III

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
prat1507
Valued Contributor

Re: Last sunday

Maybe this

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

Regards

Pratyush

3 Replies
shraddha_g
Honored Contributor III

Re: Last sunday

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

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

prat1507
Valued Contributor

Re: Last sunday

Maybe this

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

Regards

Pratyush

victor_greffet
New Contributor III

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