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

[JMMAYORAL]

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.

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

Querría así:

Totales

26-sep-.2010

27-sep-2010

…

Muchas gracias. Saludos. Jose María.

[Chanty4u]

try this

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

[JMMAYORAL]

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. 

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

Thank you. Jose María. 

[Chanty4u]

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

[JMMAYORAL]

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;

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:

It just shows the field Newdate. 

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

[JMMAYORAL]

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:

Thank you. José María.