Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sra1bandi
Contributor III
Contributor III

Colors to Null symbol '-'

Sra1bandi_0-1666541720478.png

Hi Team,

In normal Table Need to fill colors in the  cell '-',.

i am using expression :-  If(not IsNull([Your Field]), [Your Field], ' ') 

with above function i am getting colors in empty cell but i am not getting color with the symbol in the cell '-'

How to fill  colors for the values '-' in the table?

 

Regards,

Sra1.

Labels (1)
2 Replies
ckarras22
Partner - Creator
Partner - Creator

If the NULLs come from the load script, then you can use the NullAsValue and NullValue like below  

 

 

NullAsValue Phone;
Set NullValue = '-';

LOAD
    CustomerID,
    Name_CStmr,
    Phone
FROM [lib://ssdd/Customer - nulls.xlsx]
(ooxml, embedded labels, table is Customer);

 

 

then you can use it as usual in the table 

null_as_vallues.jpg

 

If the NULLs are generated on the fly, the "Background color expression" has no effect. The check happens before the NULL generation

Sra1bandi
Contributor III
Contributor III
Author

Hi Ckarras,

Thanks for your reply.

I am used that also still it's not getting.