Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
date(date#(SubField (MyDate,' ',1),'DD/MM/YYYY hh:mm:ss'),'DD-MM-YYYY') as Newdate;
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.
you have to use that in script and reload the qvf. that newly created date field you can use in dimension.
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.
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.