Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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???

Tags (1)
5 Replies
pennetzdorfer
Contributor III

Re: Add missing values

Does "Show All Values" help you?

1.jpg

Regards,

Florian

Not applicable

Re: Add missing values

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

Is it?

Not applicable

Re: Add missing values

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

Not applicable

Re: Add missing values

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
Contributor III

Re: Add missing values

Could you post an example qvw?

Community Browser