topic Formattng WeekDay in QlikView

Formattng WeekDay

Mon, 15 Nov 2010 20:31:02 GMT

Hi guys,

I need to join two tables, but having problems to set up the common field.

TargetDate3:

LOAD

,WeekDay(Date#(Y,'DD/MM/YYYY hh:mm')) as Y.Day

,WeekDay(Date#(Y,'DD/MM/YYYY hh:mm')) as Y.Day1

,Round([B+p]) as [B+p]

RESIDENT Formulas;

//LEFT

JOIN LOAD

Date#(WDay,'DDD') as Y.Day

,Date#(WDay,'DDD') as Y.Day2

,WorkableMinutes

RESIDENT WorkDays;

Take a look at the values of the fields Y.Day1 and Y.Day2:

How can I work it around?

Thanks in advance,

Aldo.

pover — Mon, 15 Nov 2010 20:59:12 GMT

Aldo,

Try Text(WeekDay(Date#(Y,'DD/MM/YYYY hh:mm'))) to just use the text part of the dual data type.

Or, Weekday(Date#(WDay,'DDD')) in the second table.

Regards.

Tue, 16 Nov 2010 08:04:05 GMT

Hi Karl, Thanks for your answer.

I tried Text(...) in the first table. I get day names ("Sun", etc), but still not the same as in the second table.

Sun

Any other idea?

Thanks,

Aldo.

deepakk — Tue, 16 Nov 2010 08:06:21 GMT

Use trim function on both fields....

Tue, 16 Nov 2010 20:07:22 GMT

Great! it works.

Thanks guys.

LOAD

Trim( Text( WeekDay(Date#(Y,'DD/MM/YYYY hh:mm')) ) ) as Y.Day

RESIDENT Formulas;

LEFT JOIN LOAD

Trim( Text( Date#(WDay,'DDD') ) ) as Y.Day

RESIDENT WorkDays;