Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
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!!