Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Select <blank> entries in a table column?

I have a table which contains <blank> entries (showed in color light grey with a sign '-').

I would like to select these entries - but I cannot filter or select them.

Is there a best practice - maybe a link to a manual which can help here?

Example - Column 3 contains 2 values with sign '-' which I cannot select or filter:

Header 1Header 2Here I would like to select <blank> fields marked with sign -Header 4Header 5
AppleName 1AlphaOtheradsf
AppleName 2-Otherqer
MelonName 3BetaTestasdf
MelonName 4AlphaTestasdf
BananaName 5-Testqewqr
4 Replies
daveamz
Partner - Creator III
Partner - Creator III

Hi Omar,

Check Henric's post: https://community.qlik.com/docs/DOC-3155

Regards,

David

Not applicable
Author

Hi Omar

First you can take that field which contains NULL values in a list box or Filter pane and "select all". After that take your Primary Key Field into Filter Pane and Select Excluded.

Regards

Ahmed

tajmohamed30
Creator III
Creator III

you can assign a value for - and make it selectable

rospigliosi
Creator
Creator

Hi Omar,

try something like:

IF(isnull("name of the Field with blanks.."),'N/A', "name of the Field with blanks..") as "name of the Field with blanks.."



Than you can select N/A instead of blanks..