Conditional Text Format in Table

[gf]

Hello all,

It's maybe a stupid questions but i just can not figure it out. I have a pivot table and i want that each cell in column "Betrag_Abgrenzung" where "Subkategorie" is empty to be displayed as bold.

It tried it like in the picture below but it doesn't work.

[zhadrakas]

try like
if(len(trim(SUBKATEGORIE))=0, '<B>')

[gf]

Nice to hear from you again tim and thanks for the fast reply, but unfortunately nothing changes.

Reagrds

[zhadrakas]

i tried it with sample data and it works for me.

For Dimension (BETRAG) and as Expression (sum(BETRAG))

 

is used this  Expression in Text Format

=if(len(trim(SUBKATEGORIE))=0, '<B>')

[Vengatesh]

Try any one of this:

if(Isnull(SUBKATEGORIE), '<B>')

or 

if(SUBKATEGORIE='', '<B>')

[gf]

As you see, i tried it the same way....

[gf]

@Vengatesh no changes visible with your solution....

[zhadrakas]

please try if it works as an Expression like sum(BETRAG_ABGRENZUNG)
Which QlikView Version do you use?

[gf]

Version 12.20.20700.0

[gf]

The funny thing is, in the same project, i had the same requirement but with Italic and it worked like expected.