Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

23 Replies
pho3nix90
Creator II
Creator II

To make it bold just click on "Text Format" and add the folowing:

=If(FieldName = 'Blank', '<B>')

Not applicable
Author

Ah okay no worries, now you just combine that with the earlier answer to the bold query and you should get the colouring you want.

If(Dimensionality()>0 And isNull(Your_Field),RGB(93,118,192))

something like that

Joe

Not applicable
Author

Super working. Thanks.

Not applicable
Author

no worries, glad to help

Joe