topic Create Monday-Friday week column for grouping. in QlikView

Create Monday-Friday week column for grouping.

proctors — Sat, 16 Nov 2024 04:38:11 GMT

Im using one of the widely available Master Calendars available for QV but what our users need is a date formatted with such as Monday dash Friday foot each week. For example,
For 2019, we would have 1/7-1/11. Can we do this in the load script?

Re: Create Monday-Friday week column for grouping.

jonathandienst — Tue, 29 Jan 2019 05:42:42 GMT

Like this:

LOAD ...
    Date,
    Date(WeekStart(Date) + 1, 'M/DD') & '-' & Date(WeekStart(Date) + 6, 'M/DD') as Week,
    ...

Re: Create Monday-Friday week column for grouping.

proctors — Tue, 29 Jan 2019 16:45:18 GMT

This is great. Now, if I wanted to then create a Chart where the columns were the next 5 weeks(based off of today), how would I do that?

For example

	1/07-1/12	1/14-1/19	1/21-1/26	…
Person 1
Person 2
Person 3

Re: Create Monday-Friday week column for grouping.

jonathandienst — Wed, 30 Jan 2019 05:14:16 GMT

Include the set expression in the table expressions. Something like this:

Sum({<Date = {">=$(=Today()) <=$(=Today()+35)"}>} ...

Re: Create Monday-Friday week column for grouping.

proctors — Wed, 30 Jan 2019 05:23:47 GMT

Ok, so that gave me one column, however, I'm not sure how to make the weekly columns including the labels that you helped me create for the week. Also, what is the "35"?