Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Valentino_Rossi_46
New Contributor II

Cambiar formato de fechas a número

Hola alguien me podría ayudar con este tema

Quiero cambiar mis formatos de fecha a sólo númerico de un rango de 1-31 que serían los días del mes( 1, 2, 3, 4).

Para que en el momento que escoja el día 1 por ejemplo se refiera al 1 de febrero del 2018 y del 2019 (seleccionando mes y años por separado )

Fechas

1-02-2018

1-02-2019

Deseo solo seleccionar el 1

 

saludos

Labels (2)
2 Replies
ajaykakkar93
Contributor III

Re: Cambiar formato de fechas a número

hi,

Refer sheet "Cambiar formato de fechas a número" from attached application. 

OR

Consulte la hoja "Cambiar formato de fechas a número" De la solicitud adjunta.

""

Hello, someone could help me with this topic I want to change my date formats to only numeric of a range of 1-31 which would be the days of the month (1, 2, 3, 4). So that at the time you choose day 1, for example, refer to February 1, 2018 and 2019 (selecting month and years separately) Dates 02-01-2018 02-01-2019 I just want to select 1

""

 

 

 

 

Regards & Thanks,
Ajay Kakkar
ajaykakkar93@gmail.com
ajaykakkar93
Contributor III

Re: Cambiar formato de fechas a número

Script : 

temp:
load
date(MakeDate(2017,1,1) + RowNo(),'DD-MM-YYYY ') as date
AutoGenerate today() - date(MakeDate(2017,1,1) + RowNo(),'DD-MM-YYYY ');


Cal:
load date,
day(date) as DateDay,
month(date) as month,
year(date) as year,
num(month(date)) as monthNo,
ceil(month(date)/3) as quarter,
'Q'&ceil(month(date)/3) as quarterName,
week(date) as week,
WeekDay(date) as weekday,
WeekName(date) as weekName,
If(Month(date)<=3,Month(date)+9,Month(date)-3) as FiscalMonth,
If(Month(date)>3,Year(date)+1,Year(date)) as FiscalYear
Resident temp;

drop Table temp;

Regards & Thanks,
Ajay Kakkar
ajaykakkar93@gmail.com