Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

Blank

I have aexcel under which there is a column (Field) Product, which has some blank values ,

Now in the script iam writing the below code

match( Product, ='','') as Product,  so that the null (Blank values ) showed be suppressed,

But after reloading iam geting 0 ,

My result shoul be like where ever there is blank it should not show anything ,

In the script iam writing the script wrong ? PLease suggest me

1 Solution

Accepted Solutions
sunny_talwar

Try this instead:

LOAD

If(Len(Trim(Field)) > 0, Field) as Field

View solution in original post

3 Replies
sunny_talwar

Try this instead:

LOAD

If(Len(Trim(Field)) > 0, Field) as Field

View solution in original post

kkkumar82
Specialist III
Specialist III

Or if you want to handle the null values

you can add this

Set NULLINTERPRET ='';

in the load script

you can use

if(isnull(FieldName) , expression1, expression2)

avinashelite

try like this

if(len(trim(field_name))>0,field_name) as field_name

//if you eliminate the complete data associated with the null values then

LOAD *

from table_name

where len(trim(field_name))>0;