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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
fmazzarelli
Partner - Creator III
Partner - Creator III

interval

Hi Community,

I used the formula interval by getting the elapsed time field.

I wish to be addressed to achieve the coloring of the value  and time values as shown below

and number formatting.

The elapsed time field is a string

Immagine.png

4 Replies
its_anandrjs
Champion III
Champion III

In interval which format you are using

Interval(EndTime - StarTime, 'D hh:mm' )

Or

Interval(EndTime - StarTime, 'hh:mm' )

Regards

Anand

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

ok

may I paint them?

vlad_komarov
Partner - Specialist III
Partner - Specialist III

You cannot do it in a standard QS table... You can color the whole cell, but not the individual values in a cell.

You can do it in the "text" object, using an extension though. There is one called "Editable Text Box" and it's available on the Branch.

VK

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

ok.

very useful.