topic Day of Week in QlikView

Day of Week

Wed, 14 Sep 2011 14:10:02 GMT

Hi,

I want to select in "multi box" on year and a week (example: 2011-01; 2011-04) and i see in "text box" the days of this week (example for 2011-01 -> 3, 4, 5, 6, 7, 8, 9).

I prefer not use script, only expression/function in "text box".

Any Ideas?

Regards,
Nuno Maximiano

Day of Week

its_anandrjs — Wed, 14 Sep 2011 14:15:15 GMT

Hi,

Use Weekdays( Date ) in text box and multibox use

Year( Date ) & ' - ' & Week( Date )

Let me know if not works

HTH

Regards

Anand

Day of Week

Wed, 14 Sep 2011 14:23:48 GMT

Hi,

I can't alter the "multi box".

The "multi box" have the example values: (2011-1;2011-2;2011-10;2011-20).

I want sellected 2011-1 and populate 7 text-box with values: 3; 4; 5; 6; 7; 8; 9 ( the values of the week 1 in year 2011).

I can't use Weekdays(DATE) in text-box because i don't have the complete DATE, i don't have the day.

Day of Week

its_anandrjs — Wed, 14 Sep 2011 14:25:47 GMT

Hi,

Load your data some thing like this in resident table

load

Year(Date)&'-'&Week(Date) as YearWeek,

Weekday(Date) as WeekDay

Resident Temp;

Regards

Anand

Re: Day of Week

its_anandrjs — Wed, 14 Sep 2011 14:27:46 GMT

Hi,

See the sample file

Let me know if not works

HTH

Regards

Anand

Re: Day of Week

its_anandrjs — Wed, 14 Sep 2011 14:35:02 GMT

Hi,

But how you find with this type of data because it is not in pure date format so how could you make the weeks please find attached sample i think it may help you.

And let me know

HTH

Rgds

Annad

Day of Week

Anonymous — Fri, 16 Sep 2011 12:35:59 GMT

You could use something like:

=Min(Day(Date))

&', '&

(Min(Day(Date))+1)

&', '&

(Min(Day(Date))+2)

&', '&

(Min(Day(Date))+3)

&', '&

(Min(Day(Date))+4)

&', '&

(Min(Day(Date))+5)

&', '&

(Min(Day(Date))+6)

&', '&

(Min(Day(Date))+7)

in your text.

But this is not complete. When you week is falling in 2 months, it goes wrong.

I am going to try some and get back at you later.

Day of Week

Anonymous — Fri, 16 Sep 2011 12:43:20 GMT

I think I found a way, try this:

=Day(Min(Date))

&', '&

(Day(Min(Date)+1))

&', '&

(Day(Min(Date)+2))

&', '&

(Day(Min(Date)+3))

&', '&

(Day(Min(Date)+4))

&', '&

(Day(Min(Date)+5))

&', '&

(Day(Min(Date)+6))

Day of Week

Sun, 18 Sep 2011 11:10:32 GMT

Thanks Anand and Dennis for help.