topic Re: Replace '-' or null value with 0 in Pivot table Qlik sense in App Development

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

bhargavikn — Fri, 15 Nov 2024 21:35:01 GMT

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 — Thu, 13 Jul 2023 13:58:02 GMT

use your expression as below using set analysis:-

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

this will replace null with zero too

BrunPierre — Thu, 13 Jul 2023 14:03:56 GMT

RangeSum(Expression, 0)

Keitaru — Fri, 01 Dec 2023 09:06:38 GMT

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