Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
taylor_jesse
Creator
Creator

Text Box Formating

Hi

I have a text box with the expression

='Onboarding Time' & chr(10) &

NUM(Sum(

Aggr(

MAX({$<JobCode={'PST'}>} PersonJobEndDate)-ScribeUStartDate

, PersonGUID)

)

/

Count({$<JobCode={'PST'}>} DISTINCT PersonGUID),'##')

However for the values I get values in the attached image. Do anyone know how to fix this issue to show right?

1 Solution

Accepted Solutions
2 Replies
Miguel_Angel_Baeyens

Change the '##' part to something like '# ##0.00' or the format you need.

sunny_talwar