Discussion board where members can get started with QlikView.
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?
Go to Solution.
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)
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
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..