requirement on Calendar object

[#1]

Hi guys

i have  Created on Calendar object with Quarter field.my output should be like this

Expected O/P: Q1,Q2,Q3,Q4

Actual O/P: Q,Q1,Q2,Q3,Q4

how to clear this Q field

[sunny_talwar]

May be this:

If(Len(Trim(Date)) > 0, 'Q' & Ceil(Month(Date)/3)) as Quarter

[#3]

Can you use QVC for calendar Master just rigth there:

CALL Qvc.CalendarFromField('LinkTable.Periodo');

Rename Table MasterCalendar To D.CalendarioTmp;
Rename Field Day             To Calendario.NumDia;
Rename Field Weekday         To Calendario.DiaSemana;   
Rename Field Month             To Calendario.Mes;
Rename Field Year             To Calendario.Anno;
Rename Field Quarter         To Calendario.Trimestre;
Rename Field [Year-Month]    To Calendario.AnnoMes;

//--------------------------------------------------------------------------------------------------
// Procesamiento de la Tabla en Memoria para Crear Columnas Nuevas...
_Calendario:
    LOAD Distinct
        AutoNumberHash256(Date(Calendario.AnnoMes, 'YYYYMM'))    as SK.Periodo,
        Date(Calendario.AnnoMes, 'YYYYMM')                        as Calendario.Periodo,
        Calendario.Anno,
        Calendario.Mes,
        Calendario.Trimestre,
        Calendario.AnnoMes

    RESIDENT D.CalendarioTmp;
    DROP TABLE D.CalendarioTmp;

Only Change Linktable.periodo, for your field request.

I attached the QVC.

[#4]

Thanks

[#5]

Thanks