How to highlight only part of value in straight table in Bold?

[#1]

Hi,

I have data in excel which loads into qvw. there are some records with blanks in excel. so, in Qlikview straight table under presentation in Null Symbol and Missing Symbol I mentioned as 'Blanks'.
It is showing 'Blanks' in straight table. what I need is there any way to bold the 'Blanks' and change the colour of only 'Blanks' text.

Please can anyone suggest is it possible.

[terezagr]

Hi Amelia,

in Dimension click on the plus sign and in the Text format add following

=if(Your_Field='Blanks','<B>',Your_Field)

[#3]

Thanks. I tried it not updating. In excel file it is blank cell value. I mentioned as Blanks under expression. Please suggest

I think the above expression works if there is Blanks value in excel cell. Is that right?

[Peter_Cammaert]

Put this in your Dimension->Text Format field:

=IF (LEN(TRIM(Your_Dimension_Field)) = 0, '<B>')

Edit: Sorry, yes you are right. The test for 'Blanks' only works if the input data equals 'Blanks'. Whatever you put in Presentation->Missing Values/Null Values cannot be tested in this way because it is a last-minute presentation adjustment.

[terezagr · Accepted solution]

not sure I understand what you are trying to do...can you clarify?

you can try this: =if(isNull(Your_Field),'<B>',Your_Field)

[#6]

Thanks. That works perfect.

[#7]

Thanks. This is also working.

[#8]

when I am using same expression to change Text colour it is changing the colour for Total label. Please suggest how to change only Blanks colour?

[terezagr]

In Dimension click on the plus sign and in the Text colour add following

you can try this: =if(isNull(Your_Field),RGB(93,118,192),Your_Field)

[#10]

Thanks. tried still showing change in both Blanks and Total.