Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ShirSandoval
Creator
Creator

YEARMONTH EN NUMERO

Buen día, por favor necesito generar o convertir una columna donde el año-mes: 2015-Ene sea = 1, 2015- Feb =2 y asi sucesivamente hasta la fecha actual donde 2021-Jul sea = 79. Lo intente con NUM pero me lo cambia solo del 1 al 12. Gracias

ShirSandoval_1-1627576422657.png

 

Labels (1)
1 Solution

Accepted Solutions
JustinDallas
Specialist III
Specialist III

Assuming your dates are in the order you want them to be in, you can use AutoNumber .

 

Mira a esto

DateNumberings:
LOAD AutoNumber(Fechas, 'FechaAutoNumero') AS 'Ordering',
*
;
LOAD * Inline
[
Fechas
2015-Jan
2015-Feb
2015-Mar
2015-Apr
2015-May
2015-Jun
2015-Jul
]
;

EXIT Script
;

 

View solution in original post

2 Replies
JustinDallas
Specialist III
Specialist III

Assuming your dates are in the order you want them to be in, you can use AutoNumber .

 

Mira a esto

DateNumberings:
LOAD AutoNumber(Fechas, 'FechaAutoNumero') AS 'Ordering',
*
;
LOAD * Inline
[
Fechas
2015-Jan
2015-Feb
2015-Mar
2015-Apr
2015-May
2015-Jun
2015-Jul
]
;

EXIT Script
;

 

ShirSandoval
Creator
Creator
Author

Muchas Gracias!!