Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Convert Nulls in pivot table to blanks

Hi I want to use set analysis to change null values in my pivot table to blanks. I want to do this in the front end and not in the load editor script.

I tried detecting nulls and setting them equal 'blank' but it doesnt seem to be working. Nulls in my pivot are still being represented as a greyed out box with '-'in them. Any help would be greatly appreciated!

Attempted Code:

if(Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty])=0 OR

IsNull(Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty])),'',

Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty]))

3 Replies
YoussefBelloum
Champion
Champion

Hi

try this instead

if(len(trim(Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty])))=0,'',

Sum({<Region=,County=,[StationName]=>}[Invoice Doses Qty]))

Anonymous
Not applicable
Author

Thanks for the quick response! When i try this it actually turns all the Null or 0 values to a greyed out '-' box. Which i assume represents Null.

YoussefBelloum
Champion
Champion

the expression above replace NULL and BLANK values with a blank.. so you should not see '-' anymore on the table..