Replace '-' or null value with 0 in Pivot table Qlik sense

[bhargavikn]

Hello All,

I'm trying to replace '-' values with 0 in pivot table but it is not working.

tried with below functions

1. If(isnull(Expression),0,Expression)

2. Alt(Expression,0)

nothing is working. Can you please suggest me on this.

Thank you!

[udit_k]

use your expression as below using set analysis:-

sum({<Region={"=len(Region)>0"}>} Count)

this will replace null with zero too

[BrunPierre]

RangeSum(Expression, 0)

[Keitaru]

This worked for me but if there is multiple Column dimensions it doesn't work on the additional columns