topic Re: How to write an expression with not null value in QlikView

How to write an expression with not null value

trishita — Wed, 25 Nov 2020 16:16:04 GMT

I want to write an expression for a field in database which is reflected in qlikview as ACTUAL ROB

.Example when this field is updated in database or is non empty, I can say that the Status is edited.

What would be my expression for this?

if(( ACTUAL ROB is not null ,'Correction done','Correction not done')

OR IF THE VALUE FOR THIS FIELD IS MISSING OR EMPTY I CAN WRITE THE FOLLOWINGß

if(( ACTUAL ROB is null OR MISSING ,'Correction NOT done','Correction done')

The data format for ACTUAL ROB is Integer and not varchar

Re: How to write an expression with not null value

olivierrobin — Fri, 18 May 2018 09:21:45 GMT

hello

in Qlik, you could try

if( len(trim([ACTUAL ROB]))=0 ,'Correction NOT done','Correction done')

Re: How to write an expression with not null value

trishita — Fri, 18 May 2018 09:50:19 GMT

we don't have to use the IsNull or Exist field? Suppose the field has a value 0 then it would be noted as null or 0?

Re: How to write an expression with not null value

trishita — Fri, 18 May 2018 09:51:44 GMT

Actual ROB is not a string ..Is it okay this code then

if( len(trim([ACTUAL ROB]))=0 ,'Correction NOT done','Correction done')?

Re: How to write an expression with not null value

YoussefBelloum — Fri, 18 May 2018 09:54:05 GMT

len(trim()) works with all null/blanks etc.. it will not work if you have 0, 0 is not null and is not blank

if you want to consider 0 values as null, you can replace those 0 to null in the script and then use the len(trim()) technique

Re: How to write an expression with not null value

trishita — Fri, 18 May 2018 09:56:24 GMT

Hi Its working.

Can you also suggest how to colour the correction done and correction not done statements using colour functions

Re: How to write an expression with not null value

olivierrobin — Fri, 18 May 2018 10:01:45 GMT

in your graph, you can use an expression in foreground color section

eg:

if(field='Correction done'),blue(),red())

Re: How to write an expression with not null value

olivierrobin — Fri, 18 May 2018 10:02:44 GMT

oups !!!!!

in text color section

Re: How to write an expression with not null value

trishita — Fri, 18 May 2018 13:13:13 GMT

I WANT TO KEEP ZEROES (any value in the field) as it is to be considered for the requirement..If the field has no value it is implied that the corrections are not done.