Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Dear Chandrasheker,
Now I got it working. What I did earlier was put in the if statement in the SQL SELECT.