I want to display Null values as empty cell values, how can I acheive that. I neither want a Phi symbol nor 0 displayed in the table as shown in the picture below. As in the picture displayed above, it should be just a blank space, instead of NULL. The value above are genererated using a pivot.

You have three choices: NULL 0 empty string I believe your “blank space” is an empty string but your value is numerical, hence it would render the data points incompatible. If it’s crucial for you to do so, you would need to convert your numerical value to string with Table Calculation coalesce(…

How to display nothing (blank soace) in the place of Null values (‘Phi’ symbol)

Looker Q&A Looker

IanT July 27, 2022, 8:32am 3

Maybe liquid in html to check when it’s null then html empty string.

Topic		Replies	Views
Displaying null values in sums Looker	13	319	December 11, 2023
Replace NULL Values with Blank cells Looker visualizations	0	45	January 27, 2022
Creating pivot tables with null column and null row Looker visualizations	0	30	September 22, 2025

How to display nothing (blank soace) in the place of Null values (‘Phi’ symbol)

AI Suggested topics