Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Keitaru
Creator
Creator

Marking last week of a month.

Hi Experts

So I have a Pivot table that shows some data broken down by their dimensions and weeks
Want to know if I can have the last week of each month high lighted like such?

Color Coumns.PNG

Labels (2)
2 Replies
Vegar
MVP
MVP

First you will need to define what is the last week in a month? A week can begin in one month and end in another? Is it the first week in that month or the last in the previous?

Keitaru
Creator
Creator
Author

I've attached the sample data set. The reason I'm doing this is because I want to be able to identify if there is a trend for rise in certain number of problems generated on a weekly basis and is this trend consistent to last week of the month based on date to test a hypothesis.