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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Airton
Contributor III
Contributor III
‎2021-03-19 09:37 AM

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 (2)
Labels
1,686 Views
0 Likes
4 Replies
agigliotti
MVP
MVP
‎2021-03-19 09:54 AM

Hi @Airton ,

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
1,674 Views
0 Likes
Airton
Contributor III
Contributor III
‎2021-03-19 10:46 AM
Author

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

1,652 Views
0 Likes
agigliotti
MVP
MVP
‎2021-03-19 11:15 AM

In response to Airton

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

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
1,647 Views
0 Likes
Airton
Contributor III
Contributor III
‎2021-03-19 12:12 PM
Author

hh:mm:ss

1,642 Views
0 Likes