Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
beloanthony
Contributor II
Contributor II

How to show Dimension Labels with no record

Hello,

I have a survey question that allowed respondents to choose one of the following values: 'Very Dissatisfied','Dissatisfied','Somewhat Dissatisfied','Somewhat Satisfied','Satisfied','Very Satisfied'. When I upload the data into Qlik Sense, the chart only shows 4 of the 6 options in the dimensions because there were no records for 2 of the options. Does anyone know how I can show all 6 dimension values even if the record count may be 0?

Labels (1)
2 Replies
AdiPai
Creator II
Creator II

there is an option called as include null values  - select your visualization , and in the dimension you should find this tick box

beloanthony
Contributor II
Contributor II
Author

Hello ARP,

That would work for null values in a field, but what I'm looking for is a way to include the values that were never selected. They don't exist based on the data uploaded because no survey respondent chose them, so they wouldn't even show up as null. Essentially, I need a way to add a dimension value that isn't found in the data.