Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Simple Expression help!

Hi, i have quite a simple expression that i am trying to get working.

I'm not sure how to write it. basically i need..

if [operative name] is null then use [Status Name]. if status name is null then use [Completed Name] otherwise use [operative name]

Can anyone help please?

1 Solution

Accepted Solutions
Not applicable

if([operative name] ='', if([status name] = '', [complete name], [status name]),operative name)

unless the names would say NULL in which case

if([operative name] =<null>, if([status name] = <null>, [complete name], [status name]),operative name)

View solution in original post

3 Replies
MayilVahanan

hi

if(Len([OperativeName]) = 0 and Len(StatusName)>0, StatusName, If(Len([operative name]) = 0 and Len(StatusName) =0, CompletedName, Operativename))

But can you say your condition in details..

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi, that didnt work. but would it be because of the 0's in the expression? there wouldnt be any 0's, it would just be blank..

Not applicable

if([operative name] ='', if([status name] = '', [complete name], [status name]),operative name)

unless the names would say NULL in which case

if([operative name] =<null>, if([status name] = <null>, [complete name], [status name]),operative name)