Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

zhujason858_cha
New Contributor II

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]))

Tags (1)
3 Replies
YoussefBelloum
Esteemed Contributor

Re: Convert Nulls in pivot table to blanks

Hi

try this instead

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

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

zhujason858_cha
New Contributor II

Re: Convert Nulls in pivot table to blanks

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
Esteemed Contributor

Re: Convert Nulls in pivot table to blanks

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

Community Browser