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.

[#2]

Have a look at dimensionality, that might be able to help you.

In your colour expression use something like

If(Dimensionality()>0, [Your colour expression Here])

replace 0 with the number of dimension totals in your chart -1

hope that helps

Joe

[ThornOfCrowns]

Dimensionality is the way to go and a neat trick.

[#4]

Thanks. tried it still showing same

[#5]

What code are you trying? Can you post up an example app, that would be best

[#6]

Thanks. I am using below code in Text Colour under dimension

=If(Dimensionality()>27-1, RGB(93,118,192))

[#7]

Sorry maybe I didn't explain clearly, for the dimensionality the number you enter would be one less than the number of dimension totals you have.

So if you have 27, use 26

If(Dimensionality()>26, RGB(93,118,192))

give that a try

hope that helps

Joe

[#8]

I have dimension Total as 632 so I used

If(Dimensionality()>631, RGB(93,118,192))

it is not working . Do I need to make any change?

[#9]

How many dimension fields do you have in the chart? (I am hoping not 632)

So Field1, Field2 etc

use one less than that number of fields

[pho3nix90]

Why would you use dimensionality when you are try to use the value of a row to define the color?

Expand your Expression, open text color

Add the following :

=If(FieldName = 'Blank', LightRed())

[#11]

sorry I misunderstood. I have only one dimension in straight table. so, I used below

If(Dimensionality()>0, RGB(93,118,192))

when I used this it is changing colour for Blanks and remaining all values as well. how to make this only to Blanks instead of all.