Need to show Max date for each week Data

[m_alsoby]

Hello Gents, 

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

[pedrobergo · Accepted solution]

Hi,

You can use the WeekEnd function. Try this:

WeekEnd(Transaction_date)

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.

WeekEnd(Transaction_date,0,5)

The 5 parameter set friday as a last day in the week.

[],

Pedro

[m_alsoby]

Thanks a lot dear this is really helpful,
Appreciating your support 🙂