topic Re: Underlining and Setting text to bold to portions of the table chart in QlikView https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431480#M564090 <HTML><HEAD></HEAD><BODY><P>What if i need to apply the same logic to a value in cell D? </P></BODY></HTML> Thu, 17 Jan 2013 13:51:55 GMT 2013-01-17T13:51:55Z Underlining and Setting text to bold to portions of the table chart https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431478#M564088 <HTML><HEAD></HEAD><BODY><P>Hi - </P><P></P><P>I am working on a table where i need to Bold/Underline my Totals. </P><P></P><P>I tried achieving that through 'Custom Form' option but the problem is that formatting applies to all rows for specific dimension. Where as I need to bold/underline only totals. </P><P></P><P>Any suggestions? </P><P></P><P>Thank you!</P></BODY></HTML> Thu, 17 Jan 2013 13:43:06 GMT https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431478#M564088 2013-01-17T13:43:06Z Re: Underlining and Setting text to bold to portions of the table chart https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431479#M564089 <HTML><HEAD></HEAD><BODY><P>it looks like it working for me in a straight table.</P><P>See attached.</P></BODY></HTML> Thu, 17 Jan 2013 13:48:32 GMT https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431479#M564089 giakoum 2013-01-17T13:48:32Z Re: Underlining and Setting text to bold to portions of the table chart https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431480#M564090 <HTML><HEAD></HEAD><BODY><P>What if i need to apply the same logic to a value in cell D? </P></BODY></HTML> Thu, 17 Jan 2013 13:51:55 GMT https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431480#M564090 2013-01-17T13:51:55Z Re: Underlining and Setting text to bold to portions of the table chart https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431481#M564091 <HTML><HEAD></HEAD><BODY><P>Other than the totals cell? A random value cell? Then it will apply to all rows as those are treated as being the same.</P></BODY></HTML> Thu, 17 Jan 2013 13:59:45 GMT https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431481#M564091 giakoum 2013-01-17T13:59:45Z Re: Underlining and Setting text to bold to portions of the table chart https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431482#M564092 <HTML><HEAD></HEAD><BODY><P>Yes, I am looking to apply this type of formatting to specific row. I am not calculating totals in QV, i am brining in this information for an excel file. </P><P><IMG __jive_id="30718" class="jive-image" alt="sample.png" src="https://community.qlik.com/legacyfs/online/30718_sample.png" /></P><P></P><P>Is that possible with QlikView? </P><P><BR />Thank you </P><P><BR />Zhenya</P></BODY></HTML> Thu, 17 Jan 2013 14:04:01 GMT https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431482#M564092 2013-01-17T14:04:01Z Re: Underlining and Setting text to bold to portions of the table chart https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431483#M564093 <HTML><HEAD></HEAD><BODY><P>If this comes from excel, then it has a dimension, maybe called Totals. try to set font in expression if dimension is totals</P></BODY></HTML> Thu, 17 Jan 2013 14:25:16 GMT https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431483#M564093 giakoum 2013-01-17T14:25:16Z Re: Underlining and Setting text to bold to portions of the table chart https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431484#M564094 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If I understand your question well, you want to bold all TOTAL?</P><P></P><P>If you are using straight table (or any table), please go to Chart Property &gt; Expressions then click the + sign beside the TOTAL &gt; click Text Format &gt; on the right hand side of the screen under Definition, enter TOTAL = 'B', I can't remember on top of my head if that has to be '&lt;B&gt;' or just 'B' but I think it is '&lt;B&gt;' and clik OK</P><P></P><P>Let me know if it worked</P><P></P><P>Regards,</P><P>Gabriel</P></BODY></HTML> Thu, 17 Jan 2013 14:26:18 GMT https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431484#M564094 Gabriel 2013-01-17T14:26:18Z Re: Underlining and Setting text to bold to portions of the table chart https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431485#M564095 <HTML><HEAD></HEAD><BODY><P>Hi, I have modified above example. </P><P>You can assign condition in Text Format so if the value is 'D' then Make it bold, if it lowest value assign LightRed().&nbsp; </P><P></P><P>Try it. </P></BODY></HTML> Thu, 17 Jan 2013 14:35:07 GMT https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431485#M564095 2013-01-17T14:35:07Z Re: Underlining and Setting text to bold to portions of the table chart https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431486#M564096 <HTML><HEAD></HEAD><BODY><P>That did not work for me. I need to bold specific Rows for example </P><P></P><P>2012 (measure)</P><P></P><P><SPAN style="text-decoration: underline;"><STRONG>Revenue </STRONG></SPAN></P><P>1</P><P>2</P><P>3</P><P><SPAN style="text-decoration: underline;"><STRONG>Cost of Goods Sold </STRONG></SPAN></P><P>1</P><P>2</P><P>3</P><P><SPAN style="text-decoration: underline;"><STRONG>Expense </STRONG></SPAN></P></BODY></HTML> Thu, 17 Jan 2013 15:14:28 GMT https://community.qlik.com/t5/QlikView/Underlining-and-Setting-text-to-bold-to-portions-of-the-table/m-p/431486#M564096 2013-01-17T15:14:28Z