Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert number in days and hours

Hello everyone, I have a problem and quisiser know if I can help get the following information:

My

  1. Monitoring

AVG T. Atención

AVG

12890

  1. 0.441790954
  2. 0.44179095

one

2172

  1. 0.42090322
  2. 0.42090322

feb

3713

  1. 0.419268926
  2. 0.41926893

mar

2595

  1. 0.36465677
  2. 0.36465677

abr

2137

  1. 1.022257399
  2. 1.0222574

may

1759

  1. 0.045884953
  2. 0.045884953

jun

514

  1. 0.023692738
  2. 0.023692738

And the problem in April to spend this time in excel format gives me 1 day with 32 minutes of this form

 

My

  1. Monitoring

AVG T. Atención

AVG

12890

  1. 0.441790954

00: 10: 36: 11

one

2172

  1. 0.42090322

00: 10: 06: 06

feb

3713

  1. 0.419268926

00: 10: 03: 45

mar

2595

  1. 0.36465677

00: 08: 45: 06

abr

2137

  1. 1.022257399

01: 00: 32: 03

may

1759

  1. 0.045884953

00: 01: 06: 04

jun

514

  1. 0.023692738

00: 00: 34: 07

I wonder if I can do it in graphic QlikView because if this is wrong and gives me a gráica of attention tiempode wrong, but wrong gives me a pop just to 32 minutes and this causes confusion

Captura.PNG

And I'd like to leave 1 days 32 minutes of attention.

I hope you can help me.

21 Replies
sunny_talwar

I am not sure I understand your requirement completely. Can you try to may be re-explain please?

Best,

Sunny

fkeuroglian
Partner - Master
Partner - Master

Josue como estas?

Podras explicar mejor tu consulta, para que sea mas facil ayudarte

saludos

Fernando

Not applicable
Author

Hellow Sunny,

Thanks for thake a few minuts to this, well i have some dates, and i convert them in number to take the avg of two diferent rows, and the result i want to do a graphic of them, the exercice is

     

MesT. MonitoreoAVG T. AtenciónAVG QlikViewAVG Excel
ene21720.4209032210:06:06 a. m.0 day 10:06:06
feb37130.41926892610:03:45 a. m.0 day 10:03:45
mar25950.3646567708:45:06 a. m.0 day 08:45:06
abr21371.02225739912:32:03 a. m.01 day 00:32:03
may17590.04588495301:06:04 a. m.0 day 01:06:04
jun5140.02369273812:34:07 a. m.0 day 00:34:07

Mes = Month

T.Monitoreo = Tickets Monitorion

AVG T Atención = Average attention Tickets

AVG QlikView = The format that QlikView

AVG  Excel = The formar of Excel

And i want to do in QlikView the same like Excel,  and grafic them, because if i grafic whith this data the grafic confuse to the user

Captura.PNG

This data confuse because in the 2 times April and June the data is in April 12:32:03 A.M. and June 12:34:07 A.M. and de diference is about 2 minutes and It is not understandable the diference in the graphic, I hope to be more explicit.

Regards!!!

sunny_talwar

See if this helps:

Interval(AVG QlikView, 'D hh:mm:ss')

if not, then would you be able to share a sample?

Best,

Sunny

Not applicable
Author

Hola Fernando

Lo puse en ingles no se si me explique, pero el tema es que tengo dos columnas en la data donde sumo los tickets generados para un tema de monitoreo, y después de eso, saco el promedio de atención de eso tickets, tal como lo pmuestro aqui en la tabla

     

MesT. MonitoreoAVG T. AtenciónAVG QlikViewAVG Excel
ene21720.4209032210:06:06 a. m.0 day 10:06:06
feb37130.41926892610:03:45 a. m.0 day 10:03:45
mar25950.3646567708:45:06 a. m.0 day 08:45:06
abr21371.02225739912:32:03 a. m.01 day 00:32:03
may17590.04588495301:06:04 a. m.0 day 01:06:04
jun5140.02369273812:34:07 a. m.0 day 00:34:07

El tema es que cuando hago el formato de el número en Qlik me dala columna de AVG QlikView, y despues de tanto pensar, lo exporte a Excel y le di un formato en la columna AVG Excel, y en realidad me da ese resultado, todos me dan 0 días excepto Abril me da 1 día y 32:03 seg

Captura.PNG

Esto genera una confusión ya que en Abril al ponerse encima del dato aparece 12:32:03 a. m. y en la data es menor que cualquier otro de los meses anteriores, y cuando gráfica Junio 12:34:07 a. m. y eso es lo que confunde, entonces quisiera saber como hacer que la gráfica al sacar los emergentes de 1 día 32:03 minutos.


Espero haber sido mas explicito y cual es la confusión al ser más detallado y te agradezco Fernando.


Saludos.

Not applicable
Author

Hellow Sunny,

It´s do not work !!!

I can share my document, where can i upload???

Regards

Carlos.

Not applicable
Author

sunny_talwar

While replying, click on 'Use advanced editor' on upper right of the reply window

Capture.PNG

It will take you to another window where you will have the option to attach on lower right.

Capture.PNG

Best,

Sunny

Not applicable
Author

Hellow Sunny,

It´s atached.

Regards