Discussion board where members can get started with QlikView.
i have field called Go_to the values i can see is
so my requirment is all null.blank treat as direct only
how can i do this?
try like this:
if(len(trim(GO_TO_MAR)=0,'Direct', GO_TO_MAR) as GO_TO_MAR
View solution in original post
if(len(trim(GO_TO_MAR))=0,'Direct', GO_TO_MAR) as GO_TO_MAR
thank you both its working fine