topic Re: Percentage Calculation in Combo Chart in QlikView https://community.qlik.com/t5/QlikView/Percentage-Calculation-in-Combo-Chart/m-p/742860#M265250 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Perhaps this: Count({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">OverdueFlag={0}</SPAN>&gt;}DistinctOrderNumber) /<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> Count(DistinctOrderNumber)</SPAN></SPAN></P></BODY></HTML> Fri, 31 Oct 2014 12:31:49 GMT Gysbert_Wassenaar 2014-10-31T12:31:49Z Percentage Calculation in Combo Chart https://community.qlik.com/t5/QlikView/Percentage-Calculation-in-Combo-Chart/m-p/742859#M265249 <HTML><HEAD></HEAD><BODY><P>Hi there. Really hoping someone can help.</P><P></P><P>I have created a stacked combo chart that shows the amount of orders that have been completed on time and overdue. To get this I have loaded in script:</P><P></P><P>If (actfinishdate &gt;overduedate,1,0) as OverdueFlag</P><P></P><P>Then in chart properties I have 2 dimensions:</P><P></P><P>Week(Orderstartdate)</P><P>OverdueFlag</P><P></P><P>And the expression is Count(Distinct(OrderNumber)</P><P></P><P>This works fine and I am getting the bars to how I am expecting them to look.</P><P></P><P>My problem comes when I try to add a line chart into the graph to show the percentage of orders completed on time (OverdueFlag=0). I just cant seem to get the forumla right. </P><P></P><P>Can anyone help?</P><P></P><P>Many thanks in advance.</P></BODY></HTML> Fri, 31 Oct 2014 11:38:31 GMT https://community.qlik.com/t5/QlikView/Percentage-Calculation-in-Combo-Chart/m-p/742859#M265249 2014-10-31T11:38:31Z Re: Percentage Calculation in Combo Chart https://community.qlik.com/t5/QlikView/Percentage-Calculation-in-Combo-Chart/m-p/742860#M265250 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Perhaps this: Count({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">OverdueFlag={0}</SPAN>&gt;}DistinctOrderNumber) /<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> Count(DistinctOrderNumber)</SPAN></SPAN></P></BODY></HTML> Fri, 31 Oct 2014 12:31:49 GMT https://community.qlik.com/t5/QlikView/Percentage-Calculation-in-Combo-Chart/m-p/742860#M265250 Gysbert_Wassenaar 2014-10-31T12:31:49Z