0 instead of disappearing rows

[Omarov]

Hi everyone.
I have a data like this :
customerID Product     value     date
       1            Prod1       100       Jan24
       2            Prod2       140       Jan24
       3            Prod2       360       Jan24
       4            Prod2        60        Jan24

I add customerid and sum(value) to pivot table
and Product to filter pane and date to another filter pane
when i select Prod1 from filter pane customerid 2,3,4 disappear because there is no data for customerid 2,3,4. I want qliksense show  0 instead of disappearing .
Thank you in advance.

[rui24]

Hello @Omarov 

Try this

if(sum(value) = 0,'0',sum(value))

[Lech_Miszkiewicz · Accepted solution]

try:

sum(value)+sum({1} 0)

and make sure you have option to in include 0 enabled

cheers

[Omarov]

Thanks a lot