Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
jmialoundama
Contributor II

Get last friday

Hello , 

I have differents dates and i want to get only last friday (16/11/2018):

Capture.JPG

When i load this on my script , it's doesnt work : 

LOAD 
"Date expedition",
FROM [lib://QVD_Rec (omnium_dec1)/DWH\F_EXPORT_CDE_WEB.QVD](qvd)
Where Date("Web - Date expedition")= Date(Weekstart(Today())-3)

And yet this expression returns to me well the date of the last Friday, ie the 16/11/2018. So I do not see what's wrong with my script?

Labels (3)
2 Replies
Luminary
Luminary

Re: Get last friday

Please, remember to post questions related to the product in the correct discussion board.

Here is the list of discussion board for qlik products,  https://community.qlik.com/t5/Qlik-Products/ct-p/qlik-products

 This post will be moved to the correct discussion board soon.

Thanks, Pablo 

andrey_krylov
Valued Contributor

Re: Get last friday

Try this

Where Date(Floor("Web - Date expedition"))= Date(Weekstart(Today())-3)

or this

Where Date(Floor(Date#("Web - Date expedition",  ''DD/MM/YYYY hh:mm:ss'')))= Date(Weekstart(Today())-3)