How to show [blank] when field value is null and empty?

Question & Answer
,
1

One of the column in data set has null values.
When I show it in pivot or table visual it shows either ‘null’ or ‘empty’.
image

  1. What is difference between display ‘null’ and ‘empty’? Why the visual displays mix of both, even if the value field GroupCode = null?

  2. Is it possible to display blank cell in pivot and table visual instead of text ‘null’ or ‘empty’?

2

  1. null is a value that is null. empty is a value that is ‘’. Are you saying all of your GroupCode’s are null?

  2. Yes, you can go to more formatting options and change null values to Show custom and in the text add a space. This is only for null values so you’ll need to change your empty values to nulls. Here is how you can do that.

GroupCodeNulls = ifelse({GroupCode}=‘’,null,{GroupCode})

image
image978×532 59.2 KB

2 Likes
3

Hi Max, Thanks for formatting tip.

Regarding null versus empty, GroupCode column as either a one word char string or null. There is no ‘’.

4

Hmm, empty shows up when there is an empty string.

Can you show me an example where you are getting empty instead of what you are expecting to see?

5

Hi Max,
Beiow attached is the snapshot of the table column from my Quicksight analysis.
image

6

Those blank values are spaces " "

NULL => null
‘’ => empty
" " =>