Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filter pane - show blanks

Hi,

Some of my records in Access are blank for the field region. When I however create a filter pane for this field in Qlik Sense there is no option to select the blanks.

I checked the properties window for the filter pane and reloaded my data to see if there was an option to exclude the blanks but no success.

Can anyone point me in the right direction?

I've attached a print screen for a visual overview of the issue.

10 Replies
Anonymous
Not applicable
Author

Dear Chandrasheker,


Now I got it working. What I did earlier was put in the if statement in the SQL SELECT.