Discussion board where members can get started with Qlik Sense.
I have differents dates and i want to get only last friday (16/11/2018):
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?
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.
Where Date(Floor("Web - Date expedition"))= Date(Weekstart(Today())-3)
Where Date(Floor(Date#("Web - Date expedition", ''DD/MM/YYYY hh:mm:ss'')))= Date(Weekstart(Today())-3)