Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
wanyunyang
Creator III
Creator III

0 still doesn't show after checking "Include 0 values"

In the script, I have a table with Item and attributes, and another table with Item, Bin, Inventory.

 

In the layout straight table, my columns are Item, attributes, and Inventory in Bin A with below formula:

sum({<Bin={'A'}>}Inventory)

 

The problem is, if an item doesn't exist in Bin A, the row is showing null although the item has attributes.

 

I have checked "Include 0 values", so I have no idea what the problem is.

 

1 Reply
Chanty4u
MVP
MVP

try this

 

sum({<Bin={'A'},Bin=p(Bin)>}Inventory)