Empty cell in the pivot table is it possible to zero?

[selimkocak]

Hello there,

Pivot tables dash fields with zero (0) Can we do.

Above(TOTAL SUM(debt),0,RowNo(TOTAL)) + Above(TOTAL SUM(credit),0,RowNo(TOTAL))

+

SUM(amount)

[lakshmikandh · Accepted solution]

combination which are not having data in table are displayed as gaps or dashes . You can not show it as zero if you are not having data for that combination.

[cesaraccardi]

Hi,

What if you replace the expression by sum({1} 0), does it display 0 values for all the cells? If that is the case then I think you can try something like:

sum({1} 0)

+

alt(

Above(TOTAL SUM(debt),0,RowNo(TOTAL)) + Above(TOTAL SUM(credit),0,RowNo(TOTAL))

+

SUM(amount)

,0)

[rupamjyotidas]

Maybe ALT() funciton can help you, if I understand your problem

Alt(your equation, 0)

Below is the help

https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/ConditionalFunctions/alt.htm

[selimkocak]

Thank you so much