Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

sarfaraz_sheikh
New Contributor III

Re: Regarding Null

my requirement is  how i can recognise the null records in table ....

Sarfaraz

Re: Regarding Null

Create a couple of Debug fields that will help you understand your data, e.g.

    IsNull(DD_TYPE) as DebugField1,

    Len(Trim(DD_TYPE)) as DebugField2,


and use the following where clause:

     Len(Trim(DD_TYPE))=0 or WildMatch(DD_TYPE,'EN','NB','RW','RO','UC')


The "Len(Trim(DD_TYPE))=0" may be a better condition than IsNull(), since you could have records that are empty but still not NULL.


HIC

Highlighted
geetaalhan
Contributor

Re: Regarding Null

Hi,

At the script level,create one field in the table that satisfies  your condition ,take a look at the following example:

*************************************************************************

data:

LOAD name,

     DD_TYPE

FROM

data.xls

(biff, embedded labels, table is Sheet1$);

data1:

load name,DD_TYPE,

if(IsNull(DD_TYPE) or WildMatch(DD_TYPE,'EN','NB','RW','RO','UC'),1,0) as test

resident data;

drop table data;

************************************************************************

then in the front end ,create one chart having following  expression

only({<test={1}>}name)

You will get what you are looking for but make sure field 'name' must not contain any  null values .

Hope this will help you.

Thanks and Regards,

Geeta