topic Determining Dates in QlikView

Determining Dates

Tue, 06 Mar 2012 09:26:26 GMT

Hi all,

i have the following task:

I have a record in a table that describes a week. It has one field for each day of the week. the record has a start day (always Sunday) and the record has an end date (always Saturday😞

ID	start	end	monday	tuesday	wednesday	thursday	friday	saturday	sunday
12	2010-05-16	2010-05-22	2	1	5	2	5	0	0

How can i for each weekday in a record determine the date based on start and end field ?

Thanks a lot!

Determining Dates

CELAMBARASAN — Tue, 06 Mar 2012 09:37:19 GMT

Hi,

Each weekday means ?Determining start and end of the given date?

Example:

For 2010-05-20 you need to retrieve 2010-05-16 and 2010-05-22.

Celambarasan

Determining Dates

Tue, 06 Mar 2012 09:43:15 GMT

Hi, sorry for beeing unclear.

The value in the field 'start' is the date of the Sunday.

The value in the field 'end' is the date for the Saturday.

Based on this, i would like to determine the dates for the other weekdays in a record.

in the example above this would be:

2010-05-17 for monday

2010-05-18 for tuesday

...

Thanks a lot!

Determining Dates

CELAMBARASAN — Tue, 06 Mar 2012 09:45:36 GMT

Hi,

Then try with this

Date(Start+1) as Monday

Date(Start+2) as Tuesday like that so on.

If it didn't help let me know.

Celambarasan

Determining Dates

jagan — Tue, 06 Mar 2012 10:57:30 GMT

Hi,

You can use

Start+1 AS Monday,

Start + 2 AS Tuesday,

Regards,

Jagan.