Use Sum({1} 0) in pivot table

[Obsyky]

Hello,

I would like to use this kind of measure in my pivot table:

Count(ValueX) + Sum({1} 0)

But it doesn't work

What am I doing wrong?

Thanks

[MendyS]

Hi @Obsyky 

that a known issue - Display 0 in pivot table instead of - NULL - Qlik Community - 1509674 .

but you can change that in the script for example - Replace Null, - Value to Zero in Qlik Sense Pivot ... - Qlik Community - 1704292 or Solved: show "nothing" as Zeros in Pivot table - Qlik Community - 57185

[BrunPierre]

{1} returns total Sales disregarding selections in this example; Sum ({1} Sales)

Perhaps you can provide some sample data and the desired result.

[MendyS]

It seems that you something deference, 
what you try to do?

[Obsyky]

My table looks like this when no filter is applied

What I want is when a filter is applied, it replaces places that have a base number but are not related to the current filter with a zero so it can keep the shape.
For example I select a filter that will show me numbers in the first 5 columns, but not in the 6th, so replace all the right values with a 0.
Why I need this is that this table represents something physical and so it allows me to visualize where I am in relation to the physical