Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

hopkinsc
Valued Contributor II

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

Re: Simple Expression help!

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)

3 Replies

Re: Simple Expression help!

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

hopkinsc
Valued Contributor II

Re: Simple Expression help!

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

Re: Simple Expression help!

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)

Community Browser