topic Re: Text Box Formating in QlikView https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83475#M768722 <HTML><HEAD></HEAD><BODY><P>Change the '##' part to something like '# ##0.00' or the format you need.</P></BODY></HTML> Mon, 11 Jun 2018 14:30:38 GMT Miguel_Angel_Baeyens 2018-06-11T14:30:38Z Text Box Formating https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83474#M768721 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a text box with the expression</P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">='Onboarding Time' &amp; chr(10) &amp;</P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">NUM(Sum(</P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">Aggr(</P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">MAX({$&lt;JobCode={'PST'}&gt;} PersonJobEndDate)-ScribeUStartDate</P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">, PersonGUID)</P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">)</P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">/</P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">Count({$&lt;JobCode={'PST'}&gt;} DISTINCT PersonGUID),'##')</P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;"></P><P style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">However for the values I get values in the attached image. Do anyone know how to fix this issue to show right?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83474#M768721 taylor_jesse 2020-11-25T16:16:04Z Re: Text Box Formating https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83475#M768722 <HTML><HEAD></HEAD><BODY><P>Change the '##' part to something like '# ##0.00' or the format you need.</P></BODY></HTML> Mon, 11 Jun 2018 14:30:38 GMT https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83475#M768722 Miguel_Angel_Baeyens 2018-06-11T14:30:38Z Re: Text Box Formating https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83476#M768723 <HTML><HEAD></HEAD><BODY><P>Look here</P><P><A href="https://community.qlik.com/message/1500143">Re: Text Box Formatting</A></P></BODY></HTML> Mon, 11 Jun 2018 14:31:58 GMT https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83476#M768723 sunny_talwar 2018-06-11T14:31:58Z