Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

varmekontrol
New Contributor II

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
Contributor III

Re: Coloring background for Nullvalue

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

6 Replies
karthikoffi27se
Contributor III

Re: Coloring background for Nullvalue

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
New Contributor II

Re: Coloring background for Nullvalue

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
Contributor III

Re: Coloring background for Nullvalue

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';

mark6505
Valued Contributor III

Re: Coloring background for Nullvalue

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

vijetasharma
Contributor III

Re: Coloring background for Nullvalue

Hi,

to check null values please check condition like,

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

varmekontrol
New Contributor II

Re: Coloring background for Nullvalue

Hi.

Worked with load...

Thx.

Community Browser