topic Need to show Max date for each week Data in App Development

Need to show Max date for each week Data

m_alsoby — Sat, 16 Nov 2024 21:02:58 GMT

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

Re: Need to show Max date for each week Data

pedrobergo — Mon, 15 Apr 2019 11:05:19 GMT

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

Re: Need to show Max date for each week Data

m_alsoby — Mon, 15 Apr 2019 11:20:27 GMT

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