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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
AndreasMoller
Contributor III
Contributor III

Vizlib table, sum value with 0 disappears

Hello!

I need help, my sum values with 0 disapperas in my vizlib table.


When i look in the qvd-file my table looks something like this:

OrderNo Item Cost
123456 10 15
123456 20 0
123456 30 50

 

I have a measure:
Sum(Cost)

I use vizlib to have dynamic tables.

So to the problem:
When i use my dynamic vizlib table i find all 3 rows above when i show the "OrderNo" and "Item" dimensions.
But when i want to show my measure, the 2 second rows disapperas in the table. Why?

Cant i sum a value with 0?
I want that row to be showed as 0 cost. 

Labels (2)
1 Solution

Accepted Solutions
AndreasMoller
Contributor III
Contributor III
Author

Nevermind, i found the solution.
There was a setting on vizlib that hides 0 values. 

View solution in original post

1 Reply
AndreasMoller
Contributor III
Contributor III
Author

Nevermind, i found the solution.
There was a setting on vizlib that hides 0 values.