Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
To make it bold just click on "Text Format" and add the folowing:
=If(FieldName = 'Blank', '<B>')
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
Super working. Thanks.
no worries, glad to help
Joe