topic Re: Formatting pivot table dissapears when collapsed in QlikView https://community.qlik.com/t5/QlikView/Formatting-pivot-table-dissapears-when-collapsed/m-p/448432#M167337 <HTML><HEAD></HEAD><BODY><P>Interesting. I never noticed that before. When a group is collapsed, the expression total loses it's bolding. You can work around it by using a conditional Text Format in your <STRONG>expression</STRONG>.</P><P></P><P><SPAN style="font-family: 'courier new', courier;">=if(Dimensionality()=1, '&lt;B&gt;')</SPAN></P><P></P><P>-Rob</P></BODY></HTML> Wed, 23 Jan 2013 16:01:37 GMT rwunderlich 2013-01-23T16:01:37Z Formatting pivot table dissapears when collapsed https://community.qlik.com/t5/QlikView/Formatting-pivot-table-dissapears-when-collapsed/m-p/448431#M167336 <HTML><HEAD></HEAD><BODY><P>I have this problem with formatting a pivot table, when I collapse a part of the pivot table, the format of the expression values dissapears.</P><P>I used the text format property on the dimension ( '&lt;B&gt;')</P><P><IMG __jive_id="31619" class="jive-image-thumbnail jive-image" height="242" onclick="" alt="Naamloos.png" src="https://community.qlik.com/legacyfs/online/31619_Naamloos.png" width="705" /></P></BODY></HTML> Wed, 23 Jan 2013 15:32:37 GMT https://community.qlik.com/t5/QlikView/Formatting-pivot-table-dissapears-when-collapsed/m-p/448431#M167336 2013-01-23T15:32:37Z Re: Formatting pivot table dissapears when collapsed https://community.qlik.com/t5/QlikView/Formatting-pivot-table-dissapears-when-collapsed/m-p/448432#M167337 <HTML><HEAD></HEAD><BODY><P>Interesting. I never noticed that before. When a group is collapsed, the expression total loses it's bolding. You can work around it by using a conditional Text Format in your <STRONG>expression</STRONG>.</P><P></P><P><SPAN style="font-family: 'courier new', courier;">=if(Dimensionality()=1, '&lt;B&gt;')</SPAN></P><P></P><P>-Rob</P></BODY></HTML> Wed, 23 Jan 2013 16:01:37 GMT https://community.qlik.com/t5/QlikView/Formatting-pivot-table-dissapears-when-collapsed/m-p/448432#M167337 rwunderlich 2013-01-23T16:01:37Z Re: Formatting pivot table dissapears when collapsed https://community.qlik.com/t5/QlikView/Formatting-pivot-table-dissapears-when-collapsed/m-p/448433#M167338 <HTML><HEAD></HEAD><BODY><P>It works! Amazing. Thank you very much.</P></BODY></HTML> Thu, 24 Jan 2013 07:43:41 GMT https://community.qlik.com/t5/QlikView/Formatting-pivot-table-dissapears-when-collapsed/m-p/448433#M167338 2013-01-24T07:43:41Z