Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

not equal code

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..

Not equal code.JPG

thanks in advance..

evya

1 Solution

Accepted Solutions
Partner
Partner

Re: not equal code

hi,

Try this code.

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

View solution in original post

4 Replies
Partner
Partner

Re: not equal code

hi,

Try this code.

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

View solution in original post

Not applicable

Re: not equal code

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?

Partner
Partner

Re: not equal code

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

Not applicable

Re: not equal code

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 ------