topic Selecting blank records from a list in QlikView

Selecting blank records from a list

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I am trying to select blank records from a list or from my pivot table but there appears to be no "null" selection criteria. Am i miaaing something really obvious or do I need to edit my script

I want Product_ Name to show blank records as well as populated fields.

LOAD

'PROODUCT_NAME`'

SQL

SELECT

FROM

TimeAnalysisOutputtbl;

Thanks

Dave

Selecting blank records from a list

Mon, 21 Feb 2011 11:04:55 GMT

please try

LOAD

If(IsNull(PROODUCT_NAME),'Missing Names',PROODUCT_NAME) as PROODUCT_NAME;

SQL

SELECT

FROM

TimeAnalysisOutputtbl;

Now all product with Null value will be populated to "Missing Names" & also you are free to make selection to this irrespective to object type(either a list box or pivot table)

Selecting blank records from a list

prieper — Mon, 21 Feb 2011 11:05:22 GMT

You cannot select NULL-values.
You may

rerun your table and identify them with a logical check:

LOAD IF(LEN(TRIM(ProductName)) = 0, '#N/A', ProductName) AS ProductName_corr FROM ...

if Product-Name is derived from an outside table, linked via KEEP:

LET OTHERSYMBOL = +';
....
Products: LEFT KEEP YourTable LOAD Product_ID, ProductName FROM ...;
MissingProductName: LOAD * INLINE [Product_ID, ProductName
+, #N/A];

Use a calculated Expression in a Multibox:
```
IF(LEN(TRIM(ProductName)) = 0, Product_ID)
```
This should list you all the ID's, which then you may select to see further details
Similar can be done as calculated dimension in a report

HTH
Peter

Selecting blank records from a list

Mon, 21 Feb 2011 11:38:50 GMT

Thanks both of these options work a treat

Dave