Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
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)