Discussion Board for collaboration related to QlikView Deployment.
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.
If(IsNull(PROODUCT_NAME),'Missing Names',PROODUCT_NAME) as PROODUCT_NAME;
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)
You cannot select NULL-values.You may
LOAD IF(LEN(TRIM(ProductName)) = 0, '#N/A', ProductName) AS ProductName_corr FROM ...
LET OTHERSYMBOL = +';....Products: LEFT KEEP YourTable LOAD Product_ID, ProductName FROM ...;MissingProductName: LOAD * INLINE [Product_ID, ProductName+, #N/A];
IF(LEN(TRIM(ProductName)) = 0, Product_ID)
Thanks both of these options work a treat