I need some guidance how to replace the “empty” in my QS tables to an alternate text. I’m using a SQL Script for my dateset. I just can’t get my SQL Syntax to work. Suggestions? Thank you!

Replace quotes around “Not-Captured”. (Microsoft office often replaces quotes with other characters, not the ones expected by expressions in Quick Sight and other products)

Dealing with "empty" cells in QS

Q&A

darcoli January 6, 2022, 10:53pm 2

You can replace empty values with custom text by changing the formatting of each field by going to “More formatting options…” from this menu

Hide rows in chart which are empty / display null values

Topic		Replies	Views
Dealing with "empty" cells on Quicksight Q&A analysis , formatting , quick-sight , calculations , Business-Intelligence-Engineer	3	48	August 23, 2024
Null Values , Show Custom is not working! Q&A analysis , formatting , error , feature-request , quick-sight , calculations	8	8120	June 12, 2024
How to show [blank] when field value is null and empty? Q&A analysis , quick-sight	5	10913	November 23, 2022
Replacing Empty Cells Q&A error , quick-sight , calculations	2	363	March 10, 2023
Ask QS to parse empty as <null> when importing CSV Q&A data-source , feature-request , quick-sight	3	428	June 2, 2023

Dealing with "empty" cells in QS

Related topics