topic Re: WEEK NUMBER IN MONTH in QlikView

WEEK NUMBER IN MONTH

sorrakis01 — Wed, 29 Oct 2014 14:19:55 GMT

Hi,

I'm using a calculated dimension to Know the number of week in the month.

=if(month(weekend(Fecha))= month(Fecha),Round(div(day(WeekEnd(Fecha)),7)),Round(div(day(Weekend(Fecha,-1)),7))+1)+1

It's works well except the months who start on Monday.

Example: 01/09/2014 returns week 2. (7/7 = 1 +1) = 2

I think that a possibbility it's weekday(MonthStart(Fecha)) = 'lun' (monday) then don't sum 1 but i can't solve it on the sequence.

Any idea to solve it?

Thanks!

JAG

Re: WEEK NUMBER IN MONTH

Wed, 29 Oct 2014 14:55:51 GMT

Jordi tal vez no entiendo muy bien la pregunta pero yo las saco asi:

'Semana'&Ceil(Day(Fecha)/7) as SemanaDelMes

Re: WEEK NUMBER IN MONTH

Wed, 29 Oct 2014 15:00:46 GMT

Try like below:

if(month(weekend(Fecha))= month(Fecha),div(day(WeekEnd(Fecha)),7),div(day(Weekend(Fecha,-1)),7)+1)+1 as WeekNumber,

or check below:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/27/week-numbers

Thanks,

Singh

Re: WEEK NUMBER IN MONTH

sorrakis01 — Wed, 29 Oct 2014 15:02:12 GMT

Hi Alfredo,

My weeks are from Monday to Sunday

Thanks for the answer but your exemple don't works because for example 30/06/2014 (in your sequence is week number 5) and for me this day is week number 6).

Thanks

Re: WEEK NUMBER IN MONTH

ecolomer — Wed, 29 Oct 2014 15:03:33 GMT

Un ejemplo

Re: WEEK NUMBER IN MONTH

sorrakis01 — Wed, 29 Oct 2014 15:07:38 GMT

Hi,

Don't works. Thanks for the link

Regards

Re: WEEK NUMBER IN MONTH

Wed, 29 Oct 2014 15:09:50 GMT

you can change the forst day of the week in the system variables in exactly this one:

from this:

SET DayNames='Lun;Mar;Mie;Jue;Vie;Sab;Dom';

to this:

SET DayNames='Dom;Lun;Mar;Mie;Jue;Vie;Sab';

Re: WEEK NUMBER IN MONTH

sorrakis01 — Wed, 29 Oct 2014 15:12:54 GMT

Hola Enrique,

Gracias por el ejemplo pero no veo por ningún lado que me indique el número de semana dentro del mes.

Subo un ejemplo:

Saludos,

Re: WEEK NUMBER IN MONTH

rubenmarin — Wed, 29 Oct 2014 15:20:58 GMT

Hola Jordi,

Podrías probar con Ceil((Day(Fecha)+WeekDay(MonthStart(Fecha)))/7)

Re: WEEK NUMBER IN MONTH

ecolomer — Wed, 29 Oct 2014 15:24:08 GMT

Hola Jordi,

Si, vuelve a bajar el fichero y en la última pestaña lo tienes

Re: WEEK NUMBER IN MONTH

sorrakis01 — Wed, 29 Oct 2014 15:34:53 GMT

Hola Enrique,

Como siempre Gracias. Pero el ejemplo no es válido ya que si miras el 30/06/2014 lo coge como semana 5 y tendría que ser semana 6.

Usando la función de Rubén en principio me funciona bien.

Saludos y Gracias,

Re: WEEK NUMBER IN MONTH

sorrakis01 — Wed, 29 Oct 2014 15:38:05 GMT

Gracias a todos

Re: WEEK NUMBER IN MONTH

ecolomer — Wed, 29 Oct 2014 15:41:37 GMT

Gracias a ti.

Saludos,