Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Selecting blank records from a list

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

3 Replies
Not applicable

Selecting blank records from a list

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)



prieper
Honored Contributor II

Selecting blank records from a list

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

Not applicable

Selecting blank records from a list

Thanks both of these options work a treat

Dave