topic Re: Field Week Problem in QlikView

Field Week Problem

pgalvezt — Wed, 20 Apr 2016 16:27:17 GMT

Hi,

I try to concatenate my week field into the calendar but I can't get to expect.

I attached an example (I have 2 calendars one of them dont have weeks.. Excel file has.: PROBLEM is commented...

Thanks!

Re: Field Week Problem

swuehl — Wed, 20 Apr 2016 18:28:49 GMT

Not sure how the Excel file helps here in understanding your issue, since you don't load from an Excel file in your script, do you?

If this doesn't work for you

Left Join(Remuneraciones)

//CalendarioFiltro:

LOAD //[Año Contable Filtro],

[Semana Contable Filtro] as Semana,

//[Mes Contable Filtro],

[Año Contable Filtro] & [Mes Contable Filtro] as LlaveCalendario

FROM

(qvd);

You need to check your created key, i.e. [Año Contable Filtro] & [Mes Contable Filtro], and compare these values to the existing key value: 2016_feb

I would guess that you need a underscore:

Left Join(Remuneraciones)

//CalendarioFiltro:

LOAD

[Semana Contable Filtro] as Semana,

[Año Contable Filtro] & '_' & [Mes Contable Filtro] as LlaveCalendario

FROM

(qvd);

Re: Field Week Problem

pgalvezt — Wed, 20 Apr 2016 18:38:57 GMT

since you don't load from an Excel file in your script, do you?

R: I do... I load the file excel and I use semana column...

Let me check your answer and let you know ..

Thanks!

Re: Field Week Problem

swuehl — Wed, 20 Apr 2016 18:43:18 GMT

R: I do... I load the file excel and I use semana column...

Hm, can't see an excel table source in your script. But may have just missed it, never mind.

Re: Field Week Problem

Colin-Albert — Wed, 20 Apr 2016 18:53:07 GMT

This post may help Redefining the Week Numbers

When using week numbers the year associated with the week number can differ from the calendar year.

Week 1 can start in December and the last week of the year, week 52/53 can continue into January.

Perhaps this is why you have problems matching the calendars.

Re: Field Week Problem

pgalvezt — Thu, 21 Apr 2016 19:30:00 GMT

Wow so simple! too many code in my script I guess ... Thanks swuehl