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
Not applicable
Author

Hellow Marco,

Thanks a lot for the help, i resolve my problem.

Regards.

Josué

MarcoWedel

you're welcome

please close your thread by selecting a correct (and possibly helpful) answer.

thanks

regards

Marco