Need Your help To know how can i present the maximum Date of the week instead of Week number,
i'm using Week(Transaction_date) as dimension but i need to present the max(date for each week) means week-end Date
kindly find the below screenshot:
To replace week Number in X axis with Week-end Date
You can use the WeekEnd function. Try this:
This fuction will return the last day of week, but in the most Qlik implementations, it is saturday. If friday is your last work week day, you may use this.
The 5 parameter set friday as a last day in the week.
View solution in original post