topic Re: Add missing values in QlikView https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501103#M692552 <HTML><HEAD></HEAD><BODY><P>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...</P></BODY></HTML> Fri, 16 Aug 2013 12:57:08 GMT 2013-08-16T12:57:08Z Add missing values https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501099#M692548 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>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:</P><P><IMG __jive_id="45613" class="jive-image-thumbnail jive-image" onclick="" alt="current result.JPG" src="/legacyfs/online/45613_current result.JPG" width="450" /></P><P></P><P>Is there any way to add any other products that have to test data brought in like below:</P><P></P><P><IMG __jive_id="45614" class="jive-image-thumbnail jive-image" onclick="" alt="intended result.JPG" src="/legacyfs/online/45614_intended result.JPG" width="450" /></P><P></P><P>'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.</P><P>Any ideas???</P></BODY></HTML> Fri, 16 Aug 2013 12:13:01 GMT https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501099#M692548 2013-08-16T12:13:01Z Re: Add missing values https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501100#M692549 <HTML><HEAD></HEAD><BODY><P>Does "Show All Values" help you?</P><P><IMG __jive_id="45619" class="jive-image-thumbnail jive-image" onclick="" alt="1.jpg" src="https://community.qlik.com/legacyfs/online/45619_1.jpg" width="450" /></P><P></P><P>Regards,</P><P>Florian</P></BODY></HTML> Fri, 16 Aug 2013 12:18:28 GMT https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501100#M692549 pennetzdorfer 2013-08-16T12:18:28Z Re: Add missing values https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501101#M692550 <HTML><HEAD></HEAD><BODY><P>From what I understand you want to populate the values ​​containing 0 to some other value!</P><P>Is it?</P></BODY></HTML> Fri, 16 Aug 2013 12:43:26 GMT https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501101#M692550 2013-08-16T12:43:26Z Re: Add missing values https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501102#M692551 <HTML><HEAD></HEAD><BODY><P>No what i want is to make the first chart identical to the second one which is the requested from me.</P></BODY></HTML> Fri, 16 Aug 2013 12:52:34 GMT https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501102#M692551 2013-08-16T12:52:34Z Re: Add missing values https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501103#M692552 <HTML><HEAD></HEAD><BODY><P>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...</P></BODY></HTML> Fri, 16 Aug 2013 12:57:08 GMT https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501103#M692552 2013-08-16T12:57:08Z Re: Add missing values https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501104#M692553 <HTML><HEAD></HEAD><BODY><P>Could you post an example qvw?</P></BODY></HTML> Fri, 16 Aug 2013 14:07:12 GMT https://community.qlik.com/t5/QlikView/Add-missing-values/m-p/501104#M692553 pennetzdorfer 2013-08-16T14:07:12Z