Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Airton
Contributor II
Contributor II

Time format operation

Good morning, Okay ? I need an aid if someone can help me! I am extracting some information about the markings of the dot card, straight from the database. so far so good. However the information of the time I spent my card is described in number and I cannot convert it correctly in hh: mm: ss, as in the image below on 03/18/2021 I have my 4 markings there. how do i do that, can someone help me?

Sem título.png

Labels (1)
4 Replies
agigliotti
Partner
Partner

Hi @Airton ,

What is the meaning of Horas field? ex. 1074 what does it means?

Airton
Contributor II
Contributor II
Author

It was time that I swiped the card, but it is not formatted and I am not able to do that.

agigliotti
Partner
Partner

ok but ex. how is your desired format for 1074 value? 

Airton
Contributor II
Contributor II
Author

hh:mm:ss