not equal code

[#1]

Hi,

I'm trying to select specific data from a table on qlikview. this table has a few records without details which i want to erase.

the code i used was as shown below.

for some reason its not working. perhaps i am using the where clause in correct? it is an integer type of field..

thanks in advance..

evya

[deepakk · Accepted solution]

hi,

Try this code.

Where len(trim([Customer Ko$])) > 0;

[#3]

Deer Deer Deepak-

Thanks a lot for your answer. it was correct.

I would like to ask another question with relevance to your answer - when do i use the NULL syntax? is it relevant only for a char type of data?

[deepakk]

hi,

It always better to use len() in all cases because u never know if there is blank space inside a field.

If there is a blank space then the null function will not work but len will work in both the cases.

Hence I always prefer using len().

Deepak

[#5]

Hi, here my script & i wish to filtered out the PRTDescription is blank. But seem it does not work. Appreciate any help as i m new t oqlikview.

//-------- Start Multiple Select Statements ------

LOAD "No_" As "DocNo",

  "Posting Date",

    "Buy-from Vendor No_",

    Month("Posting Date") As Month,

    //Date("Posting Date",'MMM-YY') As MonthYear,

    Year ("Posting Date") As Year;

SQL SELECT *

FROM "Texas2_Live".dbo."Texas Chicken Malaysia$Purchase Header";

LOAD

    SUM(Amount) As Amount,

    SUM(Quantity) As Quantity,

    SUM("Qty_ Rcd_ Not Invoiced") As "Qty_ Rcd_ Not Invoiced",

    "Document No_" As DocNo,

    "No_" AS GLNo,

    "Location Code",

    "Purchase Repair Type" AS PRT

WHERE Type= 1 AND len(trim([Purchase Repair Type])) > 0

GROUP BY

  "Document No_",

    "No_",

    "Location Code",

    "Purchase Repair Type";

SQL SELECT *

FROM "Texas2_Live".dbo."Texas Chicken Malaysia$Purchase Line";

LOAD

    Code As PRT,

    Description AS PRTDescription;

SQL SELECT *

FROM "Texas2_Live".dbo."Texas Chicken Malaysia$Purchase Repair Type";

//-------- End Multiple Select Statements ------