Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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

Henric_Cronström

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

geetaalhan
Creator
Creator

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