topic Re: Use Sum({1} 0) in pivot table in App Development

Use Sum({1} 0) in pivot table

Obsyky — Wed, 28 Sep 2022 12:08:52 GMT

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

Re: Use Sum({1} 0) in pivot table

MendyS — Wed, 28 Sep 2022 14:16:34 GMT

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

Re: Use Sum({1} 0) in pivot table

BrunPierre — Wed, 28 Sep 2022 14:33:13 GMT

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

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

Re: Use Sum({1} 0) in pivot table

MendyS — Wed, 28 Sep 2022 14:35:22 GMT

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

Re: Use Sum({1} 0) in pivot table

Obsyky — Thu, 29 Sep 2022 06:33:53 GMT

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