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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
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.