Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

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?

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Champion
Champion

Re: Null +value

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
Highlighted
Champion
Champion

Re: Null +value

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

Highlighted
Master II
Master II

Re: Null +value

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

Highlighted
Specialist III
Specialist III

Re: Null +value

thank you both its working fine