topic how to show 0% and 100% values for line chart in Qlikview in QlikView https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141132#M753853 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have created line chart with following expressions</P><P></P><P>1. =num((Sum([Total release wise UAT Defects])/Sum([DefectList.No.of Iterations]))*100,'#,##')&amp;'%'</P><P>2. =num((Sum([DefectList.No.of Iterations])-Sum([Total release wise UAT Defects]))/num(Sum([DefectList.No.of Iterations]),'###0')*100,'##,##')&amp;'%'</P><P></P><P>it is giving output correctly. but it's not showing 0%'s and 100%'s Values in my line chart. how to show them also</P><P></P><P>This is what i created chart</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215373_Capture.JPG" style="height: 241px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT bvssudhakar 2020-11-25T16:16:04Z how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141132#M753853 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I have created line chart with following expressions</P><P></P><P>1. =num((Sum([Total release wise UAT Defects])/Sum([DefectList.No.of Iterations]))*100,'#,##')&amp;'%'</P><P>2. =num((Sum([DefectList.No.of Iterations])-Sum([Total release wise UAT Defects]))/num(Sum([DefectList.No.of Iterations]),'###0')*100,'##,##')&amp;'%'</P><P></P><P>it is giving output correctly. but it's not showing 0%'s and 100%'s Values in my line chart. how to show them also</P><P></P><P>This is what i created chart</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215373_Capture.JPG" style="height: 241px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141132#M753853 bvssudhakar 2020-11-25T16:16:04Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141133#M753854 <HTML><HEAD></HEAD><BODY><P>please share qvw!</P></BODY></HTML> Mon, 08 Oct 2018 17:44:43 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141133#M753854 Frank_Hartmann 2018-10-08T17:44:43Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141134#M753855 <HTML><HEAD></HEAD><BODY><P>Hi Frank,</P><P></P><P>Here i attached qvw please have a look and give the possible solution</P><P></P><P></P><P>Thank you in advance</P></BODY></HTML> Tue, 09 Oct 2018 10:41:35 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141134#M753855 bvssudhakar 2018-10-09T10:41:35Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141135#M753856 <HTML><HEAD></HEAD><BODY><P>not sure if i understood your requirement correctly,</P><P>but have a look at the attached qvw</P></BODY></HTML> Tue, 09 Oct 2018 11:05:33 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141135#M753856 Frank_Hartmann 2018-10-09T11:05:33Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141136#M753857 <HTML><HEAD></HEAD><BODY><P>Hi Frank,</P><P></P><P>I am using Personal edition. Can please write here what you have changed in the chart</P><P></P><P></P><P>Thank you in advance</P></BODY></HTML> Tue, 09 Oct 2018 11:13:07 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141136#M753857 bvssudhakar 2018-10-09T11:13:07Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141137#M753858 <HTML><HEAD></HEAD><BODY><P>is this what you want to achieve?</P><P></P><P><IMG alt="Unbenannt.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215460_Unbenannt.png" style="height: 209px; width: 620px;" /></P></BODY></HTML> Tue, 09 Oct 2018 11:25:58 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141137#M753858 Frank_Hartmann 2018-10-09T11:25:58Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141138#M753859 <HTML><HEAD></HEAD><BODY><P>Hi Frank,</P><P></P><P>Yeah i need like this and as well as i want to show 0%'s also</P><P></P><P>Can you please how you implemented it</P></BODY></HTML> Tue, 09 Oct 2018 12:05:45 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141138#M753859 bvssudhakar 2018-10-09T12:05:45Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141139#M753860 <HTML><HEAD></HEAD><BODY><P><STRONG>ExpressionTab</STRONG>:</P><P>Exp1:</P><P>=(Sum([Total release wise UAT Defects])/Sum([DefectList.No.of Iterations]))</P><P>Exp2:</P><P>=(Sum([DefectList.No.of Iterations])-Sum([Total release wise UAT Defects]))/(Sum([DefectList.No.of Iterations]))</P><P></P><P><STRONG>PresentationTab:</STRONG></P><P>Uncheck Supress Zero Values</P><P>check Zero on Bar</P><P></P><P><STRONG>NumbersTab:</STRONG></P><P>Fixed to 2 Decimals</P><P>check show in Percent</P></BODY></HTML> Tue, 09 Oct 2018 12:16:43 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141139#M753860 Frank_Hartmann 2018-10-09T12:16:43Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141140#M753861 <HTML><HEAD></HEAD><BODY><P>Hi Frank,</P><P></P><P>I have used same thing. it's some thing better but it is showing above 100 percents also why?? can you please suggest for that also</P></BODY></HTML> Tue, 09 Oct 2018 13:02:32 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141140#M753861 bvssudhakar 2018-10-09T13:02:32Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141141#M753862 <HTML><HEAD></HEAD><BODY><P>i cant see any values above 100%</P><P><IMG alt="Unbenannt.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/215478_Unbenannt.png" style="height: auto;" /></P></BODY></HTML> Tue, 09 Oct 2018 13:11:15 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141141#M753862 Frank_Hartmann 2018-10-09T13:11:15Z Re: how to show 0% and 100% values for line chart in Qlikview https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141142#M753863 <HTML><HEAD></HEAD><BODY><P>Hi Frank,</P><P></P><P>Now, Again i have checked it is working thank you so much for your solution<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P></P><P>And you have any idea about this please check once</P><P></P><P><A href="https://community.qlik.com/thread/316310">qvw file opening error in personal edition</A></P></BODY></HTML> Tue, 09 Oct 2018 13:40:16 GMT https://community.qlik.com/t5/QlikView/how-to-show-0-and-100-values-for-line-chart-in-Qlikview/m-p/141142#M753863 bvssudhakar 2018-10-09T13:40:16Z