topic Re: Replace NULL value in condition in App Development

Replace NULL value in condition

BearNBeer — Mon, 30 Mar 2020 09:43:53 GMT

Hello,

I'm very new in Qliksense and I wrote a very simple condition that checks if a field is equal to 0 :

=if( field = 0, 'field = 0', 'field not = 0')

My result looks like that :

As you can see I have 1226 NULL values represented by a '-' .

What I would like to know is how I could put these NULL values in the 'field not = 0' line ?

Thank you in advance.

Re: Replace NULL value in condition

Taoufiq_Zarra — Mon, 30 Mar 2020 10:43:44 GMT

Maye be :

=if( lent(trim(field))= 0 or field=0 , 'field = 0', 'field not = 0')

Re: Replace NULL value in condition

Vegar — Mon, 30 Mar 2020 15:25:35 GMT

It could be that you dont have data assoiciated to any field.

Consider the example above/attached.

I have a transaction for ID 6, but no definition in the Fields dimension table. Notice that the NULL() value is defined as "Field not = 0".