topic Text Box Formating in QlikView https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83453#M768733 <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><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;"><IMG class="jive-image" data-custom="AAMkADA2MjVhNmFkLWQ3YWYtNDEzOC1iMGUxLTkxMGFjZDYwODllNABGAAAAAABdKG%2FbLMOVSKWD1b0jCnMiBwAcD2NjmWUET5punlcCfr%2FVAAAA2AOKAABrI0azS%2FwtSbFTQSAAZ%2BuxAAExQSgrAAABEgAQANDNE3NTcUZPjrDeukt9RnA%3D" data-downloadimage="service.svc/s/GetFileAttachment?id=AAMkADA2MjVhNmFkLWQ3YWYtNDEzOC1iMGUxLTkxMGFjZDYwODllNABGAAAAAABdKG%2FbLMOVSKWD1b0jCnMiBwAcD2NjmWUET5punlcCfr%2FVAAAA2AOKAABrI0azS%2FwtSbFTQSAAZ%2BuxAAExQSgrAAABEgAQANDNE3NTcUZPjrDeukt9RnA%3D&amp;X-OWA-CANARY=gz2byKlxSEecgIg2RC208QARG5imz9UYejZhSgZ7UU0o2HPplqcOn7bE0Fc9DGErzJeCyzcLqi4." data-imagetype="AttachmentByCid" data-thumbnailimage="https://attachment.outlook.office.net/owa/jesset@mail.smu.edu/service.svc/s/GetFileAttachment?id=AAMkADA2MjVhNmFkLWQ3YWYtNDEzOC1iMGUxLTkxMGFjZDYwODllNABGAAAAAABdKG%2FbLMOVSKWD1b0jCnMiBwAcD2NjmWUET5punlcCfr%2FVAAAA2AOKAABrI0azS%2FwtSbFTQSAAZ%2BuxAAExQSgrAAABEgAQANDNE3NTcUZPjrDeukt9RnA%3D&amp;X-OWA-CANARY=gz2byKlxSEecgIg2RC208QARG5imz9UYejZhSgZ7UU0o2HPplqcOn7bE0Fc9DGErzJeCyzcLqi4.&amp;token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjA2MDBGOUY2NzQ2MjA3MzdFNzM0MDRFMjg3QzQ1QTgxOENCN0NFQjgiLCJ4NXQiOiJCZ0Q1OW5SaUJ6Zm5OQVRpaDhSYWdZeTN6cmciLCJ0eXAiOiJKV1QifQ.eyJ2ZXIiOiJFeGNoYW5nZS5DYWxsYmFjay5WMSIsImFwcGN0eHNlbmRlciI6Ik93YURvd25sb2FkQDBmNDUwZjJlLTMzNGYtNGJhZC1hODVjLTlhZGY3NjA1MWQ4YiIsImFwcGN0eCI6IntcIm1zZXhjaHByb3RcIjpcIm93YVwiLFwicHJpbWFyeXNpZFwiOlwiUy0xLTUtMjEtODAyNjY5NTQ0LTc0NTY1MTA0MS0zOTM4MzcwMTM3LTU0OTE0MjBcIixcInB1aWRcIjpcIjExNTM3NjU5MzE4NjUxMDY1ODBcIixcIm9pZFwiOlwiM2M3N2MwYjctN2ZhOS00ZTZhLWE4MTMtZDEwZGVkYjcyMjk0XCIsXCJzY29wZVwiOlwiT3dhRG93bmxvYWRcIn0iLCJuYmYiOjE1Mjg3MjY4NjksImV4cCI6MTUyODcyNzQ2OSwiaXNzIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwQDBmNDUwZjJlLTMzNGYtNGJhZC1hODVjLTlhZGY3NjA1MWQ4YiIsImF1ZCI6IjAwMDAwMDAyLTAwMDAtMGZmMS1jZTAwLTAwMDAwMDAwMDAwMC9hdHRhY2htZW50Lm91dGxvb2sub2ZmaWNlLm5ldEAwZjQ1MGYyZS0zMzRmLTRiYWQtYTg1Yy05YWRmNzYwNTFkOGIifQ.NRHglI2X9xjVZzhgRN7o1xabyMPsoRR_IofObJru2-YZaEIrd0vtVnx8gJxlhhSOJPCC5TheYceINbC4_NoBmvIuNyh6C06ub5pkajQIAu0HtQrPmjSAC0feg6A62Fj0x2O0jzZj-rwq4NbNOSVL9Ayo_Rb5OSZAarmSHE-tUfC-fvKAXCMCS32A_3-KVZNGxRO1LTPS9fRw0J40VxLEDuYCuDGSz5mhsfZ6lIrKgEE7Q1C3x0pnKAzeh97Ge1ziG0kJjgjHGV5hDamYVdpNgghXwD-IwPdNo24JYZE_5PWStHfPFOjH8ONSKLZIsBV-uvmp4Iv_5aW6Fgugv7vP2Q&amp;owa=outlook.office.com&amp;isImagePreview=True" height="87" src="https://attachment.outlook.office.net/owa/jesset@mail.smu.edu/service.svc/s/GetFileAttachment?id=AAMkADA2MjVhNmFkLWQ3YWYtNDEzOC1iMGUxLTkxMGFjZDYwODllNABGAAAAAABdKG%2FbLMOVSKWD1b0jCnMiBwAcD2NjmWUET5punlcCfr%2FVAAAA2AOKAABrI0azS%2FwtSbFTQSAAZ%2BuxAAExQSgrAAABEgAQANDNE3NTcUZPjrDeukt9RnA%3D&amp;X-OWA-CANARY=gz2byKlxSEecgIg2RC208QARG5imz9UYejZhSgZ7UU0o2HPplqcOn7bE0Fc9DGErzJeCyzcLqi4.&amp;token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjA2MDBGOUY2NzQ2MjA3MzdFNzM0MDRFMjg3QzQ1QTgxOENCN0NFQjgiLCJ4NXQiOiJCZ0Q1OW5SaUJ6Zm5OQVRpaDhSYWdZeTN6cmciLCJ0eXAiOiJKV1QifQ.eyJ2ZXIiOiJFeGNoYW5nZS5DYWxsYmFjay5WMSIsImFwcGN0eHNlbmRlciI6Ik93YURvd25sb2FkQDBmNDUwZjJlLTMzNGYtNGJhZC1hODVjLTlhZGY3NjA1MWQ4YiIsImFwcGN0eCI6IntcIm1zZXhjaHByb3RcIjpcIm93YVwiLFwicHJpbWFyeXNpZFwiOlwiUy0xLTUtMjEtODAyNjY5NTQ0LTc0NTY1MTA0MS0zOTM4MzcwMTM3LTU0OTE0MjBcIixcInB1aWRcIjpcIjExNTM3NjU5MzE4NjUxMDY1ODBcIixcIm9pZFwiOlwiM2M3N2MwYjctN2ZhOS00ZTZhLWE4MTMtZDEwZGVkYjcyMjk0XCIsXCJzY29wZVwiOlwiT3dhRG93bmxvYWRcIn0iLCJuYmYiOjE1Mjg3MjY4NjksImV4cCI6MTUyODcyNzQ2OSwiaXNzIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwQDBmNDUwZjJlLTMzNGYtNGJhZC1hODVjLTlhZGY3NjA1MWQ4YiIsImF1ZCI6IjAwMDAwMDAyLTAwMDAtMGZmMS1jZTAwLTAwMDAwMDAwMDAwMC9hdHRhY2htZW50Lm91dGxvb2sub2ZmaWNlLm5ldEAwZjQ1MGYyZS0zMzRmLTRiYWQtYTg1Yy05YWRmNzYwNTFkOGIifQ.NRHglI2X9xjVZzhgRN7o1xabyMPsoRR_IofObJru2-YZaEIrd0vtVnx8gJxlhhSOJPCC5TheYceINbC4_NoBmvIuNyh6C06ub5pkajQIAu0HtQrPmjSAC0feg6A62Fj0x2O0jzZj-rwq4NbNOSVL9Ayo_Rb5OSZAarmSHE-tUfC-fvKAXCMCS32A_3-KVZNGxRO1LTPS9fRw0J40VxLEDuYCuDGSz5mhsfZ6lIrKgEE7Q1C3x0pnKAzeh97Ge1ziG0kJjgjHGV5hDamYVdpNgghXwD-IwPdNo24JYZE_5PWStHfPFOjH8ONSKLZIsBV-uvmp4Iv_5aW6Fgugv7vP2Q&amp;owa=outlook.office.com&amp;isImagePreview=True" style="color: #000000; font-family: -webkit-standard;" width="380" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT taylor_jesse 2020-11-25T16:16:04Z Text Box Formating https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83453#M768733 <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><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;"><IMG class="jive-image" data-custom="AAMkADA2MjVhNmFkLWQ3YWYtNDEzOC1iMGUxLTkxMGFjZDYwODllNABGAAAAAABdKG%2FbLMOVSKWD1b0jCnMiBwAcD2NjmWUET5punlcCfr%2FVAAAA2AOKAABrI0azS%2FwtSbFTQSAAZ%2BuxAAExQSgrAAABEgAQANDNE3NTcUZPjrDeukt9RnA%3D" data-downloadimage="service.svc/s/GetFileAttachment?id=AAMkADA2MjVhNmFkLWQ3YWYtNDEzOC1iMGUxLTkxMGFjZDYwODllNABGAAAAAABdKG%2FbLMOVSKWD1b0jCnMiBwAcD2NjmWUET5punlcCfr%2FVAAAA2AOKAABrI0azS%2FwtSbFTQSAAZ%2BuxAAExQSgrAAABEgAQANDNE3NTcUZPjrDeukt9RnA%3D&amp;X-OWA-CANARY=gz2byKlxSEecgIg2RC208QARG5imz9UYejZhSgZ7UU0o2HPplqcOn7bE0Fc9DGErzJeCyzcLqi4." data-imagetype="AttachmentByCid" data-thumbnailimage="https://attachment.outlook.office.net/owa/jesset@mail.smu.edu/service.svc/s/GetFileAttachment?id=AAMkADA2MjVhNmFkLWQ3YWYtNDEzOC1iMGUxLTkxMGFjZDYwODllNABGAAAAAABdKG%2FbLMOVSKWD1b0jCnMiBwAcD2NjmWUET5punlcCfr%2FVAAAA2AOKAABrI0azS%2FwtSbFTQSAAZ%2BuxAAExQSgrAAABEgAQANDNE3NTcUZPjrDeukt9RnA%3D&amp;X-OWA-CANARY=gz2byKlxSEecgIg2RC208QARG5imz9UYejZhSgZ7UU0o2HPplqcOn7bE0Fc9DGErzJeCyzcLqi4.&amp;token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjA2MDBGOUY2NzQ2MjA3MzdFNzM0MDRFMjg3QzQ1QTgxOENCN0NFQjgiLCJ4NXQiOiJCZ0Q1OW5SaUJ6Zm5OQVRpaDhSYWdZeTN6cmciLCJ0eXAiOiJKV1QifQ.eyJ2ZXIiOiJFeGNoYW5nZS5DYWxsYmFjay5WMSIsImFwcGN0eHNlbmRlciI6Ik93YURvd25sb2FkQDBmNDUwZjJlLTMzNGYtNGJhZC1hODVjLTlhZGY3NjA1MWQ4YiIsImFwcGN0eCI6IntcIm1zZXhjaHByb3RcIjpcIm93YVwiLFwicHJpbWFyeXNpZFwiOlwiUy0xLTUtMjEtODAyNjY5NTQ0LTc0NTY1MTA0MS0zOTM4MzcwMTM3LTU0OTE0MjBcIixcInB1aWRcIjpcIjExNTM3NjU5MzE4NjUxMDY1ODBcIixcIm9pZFwiOlwiM2M3N2MwYjctN2ZhOS00ZTZhLWE4MTMtZDEwZGVkYjcyMjk0XCIsXCJzY29wZVwiOlwiT3dhRG93bmxvYWRcIn0iLCJuYmYiOjE1Mjg3MjY4NjksImV4cCI6MTUyODcyNzQ2OSwiaXNzIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwQDBmNDUwZjJlLTMzNGYtNGJhZC1hODVjLTlhZGY3NjA1MWQ4YiIsImF1ZCI6IjAwMDAwMDAyLTAwMDAtMGZmMS1jZTAwLTAwMDAwMDAwMDAwMC9hdHRhY2htZW50Lm91dGxvb2sub2ZmaWNlLm5ldEAwZjQ1MGYyZS0zMzRmLTRiYWQtYTg1Yy05YWRmNzYwNTFkOGIifQ.NRHglI2X9xjVZzhgRN7o1xabyMPsoRR_IofObJru2-YZaEIrd0vtVnx8gJxlhhSOJPCC5TheYceINbC4_NoBmvIuNyh6C06ub5pkajQIAu0HtQrPmjSAC0feg6A62Fj0x2O0jzZj-rwq4NbNOSVL9Ayo_Rb5OSZAarmSHE-tUfC-fvKAXCMCS32A_3-KVZNGxRO1LTPS9fRw0J40VxLEDuYCuDGSz5mhsfZ6lIrKgEE7Q1C3x0pnKAzeh97Ge1ziG0kJjgjHGV5hDamYVdpNgghXwD-IwPdNo24JYZE_5PWStHfPFOjH8ONSKLZIsBV-uvmp4Iv_5aW6Fgugv7vP2Q&amp;owa=outlook.office.com&amp;isImagePreview=True" height="87" src="https://attachment.outlook.office.net/owa/jesset@mail.smu.edu/service.svc/s/GetFileAttachment?id=AAMkADA2MjVhNmFkLWQ3YWYtNDEzOC1iMGUxLTkxMGFjZDYwODllNABGAAAAAABdKG%2FbLMOVSKWD1b0jCnMiBwAcD2NjmWUET5punlcCfr%2FVAAAA2AOKAABrI0azS%2FwtSbFTQSAAZ%2BuxAAExQSgrAAABEgAQANDNE3NTcUZPjrDeukt9RnA%3D&amp;X-OWA-CANARY=gz2byKlxSEecgIg2RC208QARG5imz9UYejZhSgZ7UU0o2HPplqcOn7bE0Fc9DGErzJeCyzcLqi4.&amp;token=eyJhbGciOiJSUzI1NiIsImtpZCI6IjA2MDBGOUY2NzQ2MjA3MzdFNzM0MDRFMjg3QzQ1QTgxOENCN0NFQjgiLCJ4NXQiOiJCZ0Q1OW5SaUJ6Zm5OQVRpaDhSYWdZeTN6cmciLCJ0eXAiOiJKV1QifQ.eyJ2ZXIiOiJFeGNoYW5nZS5DYWxsYmFjay5WMSIsImFwcGN0eHNlbmRlciI6Ik93YURvd25sb2FkQDBmNDUwZjJlLTMzNGYtNGJhZC1hODVjLTlhZGY3NjA1MWQ4YiIsImFwcGN0eCI6IntcIm1zZXhjaHByb3RcIjpcIm93YVwiLFwicHJpbWFyeXNpZFwiOlwiUy0xLTUtMjEtODAyNjY5NTQ0LTc0NTY1MTA0MS0zOTM4MzcwMTM3LTU0OTE0MjBcIixcInB1aWRcIjpcIjExNTM3NjU5MzE4NjUxMDY1ODBcIixcIm9pZFwiOlwiM2M3N2MwYjctN2ZhOS00ZTZhLWE4MTMtZDEwZGVkYjcyMjk0XCIsXCJzY29wZVwiOlwiT3dhRG93bmxvYWRcIn0iLCJuYmYiOjE1Mjg3MjY4NjksImV4cCI6MTUyODcyNzQ2OSwiaXNzIjoiMDAwMDAwMDItMDAwMC0wZmYxLWNlMDAtMDAwMDAwMDAwMDAwQDBmNDUwZjJlLTMzNGYtNGJhZC1hODVjLTlhZGY3NjA1MWQ4YiIsImF1ZCI6IjAwMDAwMDAyLTAwMDAtMGZmMS1jZTAwLTAwMDAwMDAwMDAwMC9hdHRhY2htZW50Lm91dGxvb2sub2ZmaWNlLm5ldEAwZjQ1MGYyZS0zMzRmLTRiYWQtYTg1Yy05YWRmNzYwNTFkOGIifQ.NRHglI2X9xjVZzhgRN7o1xabyMPsoRR_IofObJru2-YZaEIrd0vtVnx8gJxlhhSOJPCC5TheYceINbC4_NoBmvIuNyh6C06ub5pkajQIAu0HtQrPmjSAC0feg6A62Fj0x2O0jzZj-rwq4NbNOSVL9Ayo_Rb5OSZAarmSHE-tUfC-fvKAXCMCS32A_3-KVZNGxRO1LTPS9fRw0J40VxLEDuYCuDGSz5mhsfZ6lIrKgEE7Q1C3x0pnKAzeh97Ge1ziG0kJjgjHGV5hDamYVdpNgghXwD-IwPdNo24JYZE_5PWStHfPFOjH8ONSKLZIsBV-uvmp4Iv_5aW6Fgugv7vP2Q&amp;owa=outlook.office.com&amp;isImagePreview=True" style="color: #000000; font-family: -webkit-standard;" width="380" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83453#M768733 taylor_jesse 2020-11-25T16:16:04Z Re: Text Box Formating https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83454#M768734 <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:32:04 GMT https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83454#M768734 sunny_talwar 2018-06-11T14:32:04Z Re: Text Box Formating https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83455#M768735 <HTML><HEAD></HEAD><BODY><P>Replied in the other post: replace ## by the correct mask.</P></BODY></HTML> Mon, 11 Jun 2018 14:32:08 GMT https://community.qlik.com/t5/QlikView/Text-Box-Formating/m-p/83455#M768735 Miguel_Angel_Baeyens 2018-06-11T14:32:08Z