topic Re: Empty cell in QlikView

Empty cell

gidon500 — Wed, 06 Jun 2012 13:13:08 GMT

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

Miguel_Angel_Baeyens — Wed, 06 Jun 2012 13:15:14 GMT

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

SunilChauhan — Wed, 06 Jun 2012 13:15:21 GMT

if(isnull(fieldName),fieldName) as fieldName

if(fieldName=' ',fieldName) as fieldName

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

use above inside scripe

hope this helps

gidon500 — Wed, 06 Jun 2012 13:21:59 GMT

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

Miguel_Angel_Baeyens — Wed, 06 Jun 2012 13:41:17 GMT

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 — Thu, 07 Jun 2012 08:45:10 GMT

Hi Miguel

thanks for your promt answer

it helps

gidon