topic not equal code in QlikView

not equal code

Sun, 15 Jul 2012 10:08:12 GMT

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

Re: not equal code

deepakk — Sun, 15 Jul 2012 10:56:29 GMT

hi,

Try this code.

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

Re: not equal code

Sun, 15 Jul 2012 11:04:31 GMT

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?

Re: not equal code

deepakk — Sun, 15 Jul 2012 11:48:03 GMT

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

Re: not equal code

Wed, 23 Mar 2016 09:29:49 GMT

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