Qlik Community

Qlik Sense App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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:

To replace week Number  in X axis with Week-end DateTo replace week Number in X axis with Week-end Date

 

1 Solution

Accepted Solutions
Highlighted
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
Highlighted
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

Highlighted
Contributor III
Contributor III

Re: Need to show Max date for each week Data

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