Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
m_alsoby
New Contributor III

Need to show Max date for each week Data

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:

Week Number.pngTo replace week Number in X axis with Week-end Date

 

1 Solution

Accepted Solutions
Partner
Partner

Re: Need to show Max date for each week Data

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

 

View solution in original post

2 Replies
Partner
Partner

Re: Need to show Max date for each week Data

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

 

View solution in original post

m_alsoby
New Contributor III

Re: Need to show Max date for each week Data

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