Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Mgx
Contributor
Contributor

Duration Format

Hello, 

On my KPI, I would like to print a duration. I choose this format. My problem is : I would like to print for example 25h05 and not hh:mm. 

I don't know how to escape the character h. 

Mgx_0-1675691136505.png

Mgx_1-1675691424329.png

 

 

Thanks, 

Labels (2)
1 Reply
hic
Former Employee
Former Employee

1) Change the formatting to "Auto"
2) Change the expression to
Dual(Hour(<Measure>) & 'h' & Minute(<Measure>),<Measure>)

where <Measure> is your initial measure - the calculation of the duration.