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

Announcements
AWS Degraded - You may experience Community slowness, timeouts, or trouble accessing: LATEST 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.