Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

Regarding Null

Hi ALL,

When i am writing the Or after IsNull(DD_TYPE) then it is fetching the rows....but when i am writing "and" after IsNull(DD_TYPE) nothing is getting fetched ....i dont know what happming exactly .....is i am doing wrong please suggest me right answer....

Below is my code ...i want all the null  records in my report ....

IsNull(DD_TYPE) and

WildMatch(DD_TYPE,'EN','NB','RW','RO','UC')

Please reply its urgent ......

Sarfaraz

12 Replies
sarfaraz_sheikh
Contributor III
Contributor III
Author

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

Sarfaraz

hic
Former Employee
Former Employee

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

Anonymous
Not applicable

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