Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add missing values

Hi everyone,

I have a straight table that has some metrics regarding product testing. The chart has one dimension and 5 expressions and it is depicted below:

current result.JPG

Is there any way to add any other products that have to test data brought in like below:

intended result.JPG

'Suppress zero values' it is not going to solve the problem because I actualy do not bring in any data from products that had no test.

Any ideas???

5 Replies
pennetzdorfer
Creator III
Creator III

Does "Show All Values" help you?

1.jpg

Regards,

Florian

Not applicable
Author

From what I understand you want to populate the values ​​containing 0 to some other value!

Is it?

Not applicable
Author

No what i want is to make the first chart identical to the second one which is the requested from me.

Not applicable
Author

The show all values option will not help as i dont bring in and data from products that have not been tested ...But I want to show these product as zero...

pennetzdorfer
Creator III
Creator III

Could you post an example qvw?