Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
Try this code.
Where len(trim([Customer Ko$])) > 0;
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?
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
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 ------