Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
varmekontrol
Creator
Creator

Coloring background for Nullvalue

Hi

I am having a hard time finding the answer to my question, so this question might have been answered before...

I am using a theme for my app, and the app has a dark background in general RGB(73,73,73)
When using tables in this app, I need to keep the NullValues, but problem is that background of NullValues is white, and that hearts my design

So far I have tried using.

if(Field1=null(), RGB (73,73,73), RGB (73,73,73))

if(Field1=null(), RGB (73,73,73))

if(IsNull(Field1), RGB (73,73,73), RGB (73,73,73))

and so on...

But nothing seems to work, and whatever I do, the NullValue continues to be white in the background...

1 Solution

Accepted Solutions
karthikoffi27se
Creator III
Creator III

Hi Daniel,

Define the null value in the load script and use the if condition.

NULLASVALUE *;

Set NullValue = '<NULL>';

then use if condition.

Many Thanks

Karthik

View solution in original post

6 Replies
karthikoffi27se
Creator III
Creator III

Hi Daniel,

Define the null value in the load script and use the if condition.

NULLASVALUE *;

Set NullValue = '<NULL>';

then use if condition.

Many Thanks

Karthik

varmekontrol
Creator
Creator
Author

Hi

I´m pretty new to the load script.

So if I have this load, where should I insert it???

LOAD

    orgUnit,

    propertyNumber,

    baseArticleNumber as baseArticleNumberMeter,

    serialNumber as SerialNumberMeter,

    consumptionUnitNumber,

    neverReached,

    thirtyDayReached,

    referenceDate

FROM [lib://DeviceList/DeviceList.txt]

(txt, unicode, embedded labels, delimiter is ';', msq)

Where orgUnit = 'AALB';

karthikoffi27se
Creator III
Creator III

Hi Daniel,

Just do it above the load script, like below

NULLASVALUE *;

Set NullValue = '<NULL>';


LOAD

    orgUnit,

    propertyNumber,

    baseArticleNumber as baseArticleNumberMeter,

    serialNumber as SerialNumberMeter,

    consumptionUnitNumber,

    neverReached,

    thirtyDayReached,

    referenceDate

FROM [lib://DeviceList/DeviceList.txt]

(txt, unicode, embedded labels, delimiter is ';', msq)

Where orgUnit = 'AALB';

Mark_Little
Luminary
Luminary

Hi,

Another One to try would be

if(LEN(TRIM(Field1))=0, RGB (73,73,73))

This is the approach i normally take when dealing with null values.

TRIM removes any white space and LEN return the char length.

Mark

vijetas42
Specialist
Specialist

Hi,

to check null values please check condition like,

if(len(field)=0,val1,val2) or if(field=' ',val1,val2)

varmekontrol
Creator
Creator
Author

Hi.

Worked with load...

Thx.