Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
gf
Creator III
Creator III

Conditional Text Format in Table

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.

bold.PNG

Labels (5)
12 Replies
zhadrakas
Specialist II
Specialist II

try like
if(len(trim(SUBKATEGORIE))=0, '<B>')
gf
Creator III
Creator III
Author

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

Reagrds
zhadrakas
Specialist II
Specialist II

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

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

sample.png 

is used this  Expression in Text Format

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

Vengatesh
Partner
Partner

Try any one of this:

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

or 

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

You Know What To Do.
gf
Creator III
Creator III
Author

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

bold2.PNG

gf
Creator III
Creator III
Author

@Vengatesh no changes visible with your solution....
zhadrakas
Specialist II
Specialist II

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

Version 12.20.20700.0
gf
Creator III
Creator III
Author

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