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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?

2 Replies
sunny_talwar

Miguel_Angel_Baeyens

Replied in the other post: replace ## by the correct mask.