Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
gidon500
Contributor II

Empty cell

Hi , how can i  get  only  empty value for a filed   thanks gidon

Tags (1)
1 Solution

Accepted Solutions

Re: Empty cell

Hi Gidon,

Then something like this code should work:

Table:

LOAD CREDIT,

     If(Len(Trim(CREDIT)) = 0, 1) AS AA // when CREDIT is null, AA = 1

FROM ...

Hope that helps.

Miguel

5 Replies

Re: Empty cell

Hi,

If you mean you want to add an empty value to a field, do as follows in the script:

Table:

LOAD Field1,

     Field2

     Null() AS EmptyField,

     '' AS EmptyField_2

FROM ...

Hope that helps.

Miguel

chauhans85
Esteemed Contributor

Empty cell

if(isnull(fieldName),fieldName)  as fieldName

or

if(fieldName=' ',fieldName)  as fieldName

or

if(len(fieldName)=0' ',fieldName)  as fieldName

use above inside scripe

hope this helps

gidon500
Contributor II

Empty cell

Hi Miguel

thanks for your prompt answer  ,

i have a field name CREDIT  , only in some of the recoder this field get a value

i want to define as a new filed  AA  in the same record if the value of the filed is null

thanks

gidon

Re: Empty cell

Hi Gidon,

Then something like this code should work:

Table:

LOAD CREDIT,

     If(Len(Trim(CREDIT)) = 0, 1) AS AA // when CREDIT is null, AA = 1

FROM ...

Hope that helps.

Miguel

gidon500
Contributor II

Empty cell

Hi Miguel

thanks for your promt answer

it helps

gidon

Community Browser