Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am creating an Excel based report in NPrinting. I only want to show the rows where a column value is null. How do I do this in a filter?
thanks
Frank
Hi,
As lech_miszkiewicz told, it is not possible to select NULL explicitly in QlikView or in Qlik Sense. Qlik NPrinting does the same operations you manually do, so if a feature is not available originally in QlikView or Qlik Sense it is also not available in Qlik NPrinting.
There are many posts in the community with suggestions about how to manage the NULL but at the end the best solution is to create a flag as showed by Lech.
For example refer to:
- NULL handling in QlikView (select expluded and advanced search are not yet available in Qlik NPrinting 17+)
- Selecting Null values in a Filter
Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
thanks ruggero.