topic Re: Simple Expression help! in QlikView

Simple Expression help!

hopkinsc — Mon, 17 Sep 2012 13:39:24 GMT

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?

MayilVahanan — Mon, 17 Sep 2012 13:48:50 GMT

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 — Mon, 17 Sep 2012 13:54:39 GMT

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..

Mon, 17 Sep 2012 14:04:55 GMT

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)