Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Null +value

Hi All,

Quy Nguyen

youssef belloum

i have field called  Go_to   the values i can see is

blank

direct

indirect

so my requirment is     all null.blank treat as direct only

how can i do this?

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

Hi,

try like this:

table:

load

if(len(trim(GO_TO_MAR)=0,'Direct', GO_TO_MAR) as GO_TO_MAR

from...

View solution in original post

3 Replies
YoussefBelloum
Champion
Champion

Hi,

try like this:

table:

load

if(len(trim(GO_TO_MAR)=0,'Direct', GO_TO_MAR) as GO_TO_MAR

from...

View solution in original post

Frank_Hartmann
Master II
Master II

if(len(trim(GO_TO_MAR))=0,'Direct', GO_TO_MAR) as GO_TO_MAR

soniasweety
Master
Master
Author

thank you both its working fine