topic Re: How to full fill zero on the chart? in QlikView https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390852#M422892 <HTML><HEAD></HEAD><BODY><P>already check but it not work.</P></BODY></HTML> Wed, 04 Oct 2017 06:37:26 GMT panwipa2528 2017-10-04T06:37:26Z How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390848#M422888 <HTML><HEAD></HEAD><BODY><P>Need to full fill zero as sample</P><P></P><P><IMG alt="" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/178516_pastedImage_1.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P></P><P>Need like this</P><P><IMG alt="" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/178517_pastedImage_2.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 04 Oct 2017 05:02:28 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390848#M422888 panwipa2528 2017-10-04T05:02:28Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390849#M422889 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Another way is to do it on pivot table attached screenshot for reference:</P><P></P><P>Regards,</P><P>Mayank</P></BODY></HTML> Wed, 04 Oct 2017 05:13:26 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390849#M422889 mayankraoka 2017-10-04T05:13:26Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390850#M422890 <HTML><HEAD></HEAD><BODY><P>My customer need to present in chart.</P></BODY></HTML> Wed, 04 Oct 2017 06:15:08 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390850#M422890 panwipa2528 2017-10-04T06:15:08Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390851#M422891 <HTML><HEAD></HEAD><BODY><P>For that you need to create rows with null values for every non-existing combination of the key.Then the sum on null should work and return 0 .For this just check show all values for dimensions.</P><P></P><P></P><P>Regards,</P><P>Mayank</P></BODY></HTML> Wed, 04 Oct 2017 06:31:16 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390851#M422891 mayankraoka 2017-10-04T06:31:16Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390852#M422892 <HTML><HEAD></HEAD><BODY><P>already check but it not work.</P></BODY></HTML> Wed, 04 Oct 2017 06:37:26 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390852#M422892 panwipa2528 2017-10-04T06:37:26Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390853#M422893 <HTML><HEAD></HEAD><BODY><P>What are your dimensions as per the excel?</P></BODY></HTML> Wed, 04 Oct 2017 06:56:37 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390853#M422893 kavita25 2017-10-04T06:56:37Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390854#M422894 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Check "Show Zero Values" on Presentation tab. Should work.</P></BODY></HTML> Wed, 04 Oct 2017 07:04:20 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390854#M422894 Sergey_Shuklin 2017-10-04T07:04:20Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390855#M422895 <HTML><HEAD></HEAD><BODY><P>Unchecked Suppress Zero-Values, Suppress Missing.. under presentation tab.</P><P>And checked Zero on Bars...</P></BODY></HTML> Wed, 04 Oct 2017 07:17:44 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390855#M422895 kavita25 2017-10-04T07:17:44Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390856#M422896 <HTML><HEAD></HEAD><BODY><P>Not working</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178540_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 04 Oct 2017 07:37:27 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390856#M422896 panwipa2528 2017-10-04T07:37:27Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390857#M422897 <HTML><HEAD></HEAD><BODY><P>uncheck suppress missing</P></BODY></HTML> Wed, 04 Oct 2017 07:38:55 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390857#M422897 kavita25 2017-10-04T07:38:55Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390858#M422898 <HTML><HEAD></HEAD><BODY><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178541_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 04 Oct 2017 08:02:06 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390858#M422898 panwipa2528 2017-10-04T08:02:06Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390859#M422899 <HTML><HEAD></HEAD><BODY><P>Check<IMG alt="sample.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178542_sample.PNG" style="height: auto;" /> the attached </P></BODY></HTML> Wed, 04 Oct 2017 08:12:30 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390859#M422899 techvarun 2017-10-04T08:12:30Z Re: How to full fill zero on the chart? https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390860#M422900 <HTML><HEAD></HEAD><BODY><P>Thank you very much.</P></BODY></HTML> Wed, 04 Oct 2017 09:06:22 GMT https://community.qlik.com/t5/QlikView/How-to-full-fill-zero-on-the-chart/m-p/1390860#M422900 panwipa2528 2017-10-04T09:06:22Z