Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
How do I show the Week Number from the below expression. No its shows the Week end date & year
=Date(WeekEnd([Estimated Pre-Approval Date]),'DD/MMM/YY')
now its shows as for current week -- 24/Jul/21. But i want as "Week 24"
Please help
@MPS did you try , 'Week ' & week([Estimated Pre-Approval Date])
Hi @MPS ,
You shall check the below link, if you are looking for week Number:
https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...
If you would like to check the week starting or end then you are right/good.
https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/DateAnd...
Hope this will help!
Regards,