topic Re: Display a string when two fields are null in QlikView

Display a string when two fields are null

kakani87 — Thu, 19 Apr 2018 05:19:54 GMT

Hi Folks ...

Here I want to show In a chart the status based on two fields all the status able to show with the below expression but when two fields they are Null I would like to show as 'Abscent'

here in my case this is showing as third scenario as 'OnSite'

Can any one correct the syntax when both the fields they are null show as 'Abscent'

if(column(1)<column(2),'ProperEntry',

if(column(1)>column(2),'RemoteEntry',

if(IsNull(column(1)),'OnSite',

if(IsNull(column(2)),'Missing',

if(IsNull(column(1) and column(2)) ,'Abscent'

//if(IsNull(column(1)) and IsNull(column(2)) ,'Abscent'

)

Regards,

Kishore.

Re: Display a string when two fields are null

tamilarasu — Thu, 19 Apr 2018 05:31:04 GMT

Hi SaiKishore,

if(column(1)<column(2),'ProperEntry',

if(column(1)>column(2),'RemoteEntry',

if(IsNull(column(1)) and IsNull(column(2)) ,'Abscent',

if(IsNull(column(1)),'OnSite',

if(IsNull(column(2)),'Missing'

)

Re: Display a string when two fields are null

kakani87 — Thu, 19 Apr 2018 05:37:14 GMT

Thanks a lot this worked.

But the same i entered in the post with line commented

Where I went wrong

//if(IsNull(column(1)) and IsNull(column(2)) ,'Abscent'

Re: Display a string when two fields are null

kakani87 — Thu, 19 Apr 2018 05:43:37 GMT

Can we provide a filter for all the Status displayed

Inorder to filter Each status

Status:

ProperEntry
RemoteEntry
OnSite
Missing
Abscent

Re: Display a string when two fields are null

tamilarasu — Thu, 19 Apr 2018 05:52:17 GMT

if(column(1)<column(2),'ProperEntry',

if(column(1)>column(2),'RemoteEntry',

if(IsNull(column(1)),'OnSite',

if(IsNull(column(2)),'Missing',

if(IsNull(column(1) and column(2)) ,'Abscent'

//if(IsNull(column(1)) and IsNull(column(2)) ,'Abscent'

)

The reason is the third condition is true in your if condition, so the next if conditions will not be considered. It is checking only the column(1) and it is null so it is returning "OnSite" and else part not considered.

Re: Display a string when two fields are null

tamilarasu — Thu, 19 Apr 2018 06:06:00 GMT

Listbox filter?

Re: Display a string when two fields are null

kakani87 — Thu, 19 Apr 2018 09:51:33 GMT

Yes Tamil.