Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
JMMAYORAL
Contributor III
Contributor III

Ayuda en diseño de nueva tabla - Agrupar Fechas DD/MM/YYYY hh:mm:ss como DD/MM/YYYY

Buenos días.

 Muchas gracias por vuestra ayuda.

 Tengo una tabla en QLIK con fechas en DIMENSION-FILA en formato DD/MM/YYYY hora minuto segundo que quiero agrupar las fechas como DD/MM/YYYY.

JMMAYORAL_0-1615371010538.png

Aplico como Date(FECHA_ALMACEN,'DD-MMM-YYYY') cambia el formato pero no me agrupa las del mismo día.

JMMAYORAL_1-1615371038287.png

Querría así:

Totales

26-sep-.2010

27-sep-2010

 

Muchas gracias. Saludos. Jose María.

 

 

 

 

 

 

 

 

 

5 Replies
Chanty4u
Champion III
Champion III

try this

date(date#(SubField (MyDate,' ',1),'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Newdate;

JMMAYORAL
Contributor III
Contributor III
Author

Good morning Chanty4u.

Thank you.

Perhaps I have started with QLIK Sense the cart before the horse (empezar la casa por el tejado) and I do no know where/how to apply what you told me. 

I tried what you told me in the Field where I have my date (FECHA_ALMACEN) and it says Invalid Dimension (Dimensión no válida) and it worked. 

JMMAYORAL_0-1615460086469.png

Probably I am applying what you told me in the wrong/incorrect way. 

Thank you. Jose María. 

 

 

 

Chanty4u
Champion III
Champion III

you have to use that in script and reload the qvf.    that newly created date field you can use in dimension.

JMMAYORAL
Contributor III
Contributor III
Author

Good morning Chanty4u.

Thank you.

I think I did what you told me: LOAD date(date#(SubField (MyDate,' ',1),'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Newdate;

JMMAYORAL_0-1615551691460.png

But when I am trying to design a new table, it did not show the rest of the columns/fields/values/... of the original table that I loaded in the beginning and containg among others the field FECHA:

JMMAYORAL_1-1615551890004.png

 

It just shows the field Newdate. 

Thank you. Good day. José María. 

 

 

 

 

 

 

 

JMMAYORAL
Contributor III
Contributor III
Author

Good morning all. Thank you for your help. 

I tried LOAD * date(date#(SubField (MyDate,' ',1),'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Newdate;

and it showed blank, it does not return anything.

I tried LOAD *, date(SubField (FECHA,' ',1),'DD/MM/YYYY') as Newdate; 

and it does not group dates with the same day as it may be seen below:

JMMAYORAL_0-1615878319836.png

 

Thank you. José María.