Using WeekName() function and noting what dates begin and end each week

shinnickr — Mon, 04 Dec 2017 21:26:57 GMT

Hi there,

Sorry for the confusing title....

Right now I am using the WeekName() function to call the week number, and using it in a bar chart. What I'd like to do is have a pop-up text when someone mouses over a week it notes what days begin and end the week moused over.

For example:

The bar chart shows '2017/01' meaning the first week of 2017. So, I'd like 'Week is from 1-2-2017 to 1-8-2017' to pop-up as text when someone mouses over the bar.

I'm sure I have to do something with WeekStart() and WeekEnd(), but I can't get the syntax correct.

Any help would be appreciated. Thank you!

Re: Using WeekName() function and noting what dates begin and end each week

sergio0592 — Mon, 04 Dec 2017 22:03:08 GMT

Hi,

In a bar chart, put WeekName(Date) as dimension.

As expression, put your expression and as a second expression (wich contains Date Start and End Date):

aggr(WeekStart(Date),Date)&' to '&aggr(WeekEnd(Date),Date)

Unckeck bar and check 'Text as pop-up'

Is it what you expected?

topic Using WeekName() function and noting what dates begin and end each week in QlikView

Using WeekName() function and noting what dates begin and end each week

Re: Using WeekName() function and noting what dates begin and end each week