topic Set different day on Week in QlikView

Set different day on Week

Mon, 14 Jun 2010 19:35:20 GMT

Hi All

Someone knows how to change the week only for one project (without change the operative system) ?

The manual says "use day function" but in which way ?

I need to change the number of the week.

In this project each week start on Friday instead of Monday.

Normally

31-Jan-2010,Sunday,Week4

01-Feb-2010, Monday, Week5

02-Feb-2010, Tuesday, Week5

03-Feb-2010,...................

04-Feb-2010....................

05-Feb-2010, Friday, Week5

In my case:

05-Feb-2010,Friday, WEEK6

06..................................WEEK6

07..................................WEEK6

08..................................WEEK6

09..................................WEEK6

10..................................WEEK6

11..................................WEEK6

12-Feb-2010,Friday, WEEK7

Many thanks in advance

Claudio

fernandotoledo — Mon, 14 Jun 2010 20:02:22 GMT

Hi Claudio,

This projects week can be calculated in the script, during the reload (is it static for each project)?

You can use either week or weekName functions, or weekDay with some calculations.

Best regards

Fernando

p.s.: good look agaisnt Paraguay! I´m "Italian" today!

Tue, 15 Jun 2010 09:51:59 GMT

Hi Fernando,

Many thanks for your reply and "Soccer Support"

the answer was so logic.... I had already used in another way the same think.

Regards

Claudio