Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
j_cabrera
Contributor II

Calculo de # de Retados (date-time)/Estimation of numbers of delays(date-time)

hola buen dia me encuentro tratando de de calcular los numeros de retardos de los empleados:

todos entran a las 8:30 am pero no he podido encontrar la solucion de dicho dilema o problema, espero me puedan apoyar  y dar una idea de como lo puedo realizar.

anexo como documentos para realizar pruebas

mil gracias

********************************

hello good day I am trying to calculate the numbers of lags of employees:

all go at 8:30 am but I could not find the solution to this dilemma or problem, I hope I can support and give an idea of ​​how I can make.

Annex as documents for testing

thank you

1 Solution

Accepted Solutions

Re: Calculo de # de Retados (date-time)/Estimation of numbers of delays(date-time)

Hola,

Mira el documento adjunto. El formato necesita modificarse un poco, ya que tal como viene de excel no es legible tal cual por QlikView.

=Date(Timestamp#(PurgeChar(Estado, '.'), 'DD/MM/YYYY hh:mm tt'))

La función PurgeChar() elimina el "." de "a.m." dejándolo como "am", que QlikView sí sabe interpretar.

Espero que te sirva.

Miguel

5 Replies
whiteline
Honored Contributor II

Re: Calculo de # de Retados (date-time)/Estimation of numbers of delays(date-time)

Hi.

It seems that you loaded your timestamps as strings.

You should use Date#() or Timestamp# functions to convert them to numbers. Then you can use date functions:

Timestamp#(replace(Estado, '.', ''), 'DD/MM/YYYY hh:mm tt')

j_cabrera
Contributor II

Re: Calculo de # de Retados (date-time)/Estimation of numbers of delays(date-time)

HI.

hello

good day looks the problem I have and as you realize that when removing the excel file in text format came and put him in aunq Qlilk View

date # (State)

makes me not to change the date or even applying your sentence also comets

Timestamp # (replace (State, '.',''), 'DD / MM / YYYY hh: mm tt')

if not if you know some trick to change the format within Qlik that excel at what they did was seprar same data date-time-schedule and with that the tube Qlik no problems if you pass any alternatima more so that he could reply me would be helpful

thousand grax

Re: Calculo de # de Retados (date-time)/Estimation of numbers of delays(date-time)

Hola,

Mira el documento adjunto. El formato necesita modificarse un poco, ya que tal como viene de excel no es legible tal cual por QlikView.

=Date(Timestamp#(PurgeChar(Estado, '.'), 'DD/MM/YYYY hh:mm tt'))

La función PurgeChar() elimina el "." de "a.m." dejándolo como "am", que QlikView sí sabe interpretar.

Espero que te sirva.

Miguel

j_cabrera
Contributor II

Re: Calculo de # de Retados (date-time)/Estimation of numbers of delays(date-time)

mil grx eso es lo que queria

te lo agradesco y al igual a  @whiteline por su apoyo en los que somos primerisos

j_cabrera
Contributor II

Re: Calculo de # de Retados (date-time)/Estimation of numbers of delays(date-time)

disculpa pero una pregunta Miguel Angel Baeyens si con ese mismo quisiera hacer una variable de

1er quincena Sep =del 1 al 15

2da quincena Sep= del 16 al 30

y asi sucecivamente

como lo prodria hacer???? 

Community Browser