Hi Look believes this calendar from my my qvd but by making a formula
if (month (FechaEmision)> 1 month (FechaEmision-10), month (FechaEmision)) as month,
I get the month of dicembre null is why I would like a calendar from new
Calendar_tmp:
LOAD
DISTINCT Date(DayStart(Fecha)) as Fecha
Resident
1
Order by Fecha ASC;
Calendario:
LOAD
Fecha,
Month(Fecha) as Mes,
Year(Fecha) as Año,
Week(Fecha) as Semana,
MonthName(Fecha) as MesAño,
Day(Fecha) as Dia,
'Q' &Ceil(Num(Month(Fecha))/3) as Trimestre,
'S' &Ceil(Num(Month(Fecha))/6) as Semestre
resident
Calendar_tmp;
drop table Calendar_tmp;
This question is linked to this link
http://community.qlik.com/message/260512#260512
I hope you can support me
