topic Convert Y-Axis to Percentage in QlikView https://community.qlik.com/t5/QlikView/Convert-Y-Axis-to-Percentage/m-p/420777#M560211 <HTML><HEAD></HEAD><BODY><P>I need help to convert Y-Axis to Percentage. In Dimention I have two Dimensions "Week_Ending", "TAT_Days" and One expression "Count(Order_Number)".&nbsp; When I plot a&nbsp; Bar Chart, I see the Y-Axis in numbers and want to convert to %. I have a list of data as mentioned below as well as the chart.</P><P></P><P>&nbsp;&nbsp; </P><P>Week_Ending&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TAT_Days&nbsp;&nbsp;&nbsp;&nbsp; Order_Number</P><P></P><P>3/3/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On-Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1</P><P>3/3/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On-Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2</P><P>3/3/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Late&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A3</P><P>3/10/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Late&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B1</P><P>3/10/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On-Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B2</P><P>3/17/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Late&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C1</P><P>..........</P></BODY></HTML> Thu, 02 May 2013 14:37:53 GMT 2013-05-02T14:37:53Z Convert Y-Axis to Percentage https://community.qlik.com/t5/QlikView/Convert-Y-Axis-to-Percentage/m-p/420777#M560211 <HTML><HEAD></HEAD><BODY><P>I need help to convert Y-Axis to Percentage. In Dimention I have two Dimensions "Week_Ending", "TAT_Days" and One expression "Count(Order_Number)".&nbsp; When I plot a&nbsp; Bar Chart, I see the Y-Axis in numbers and want to convert to %. I have a list of data as mentioned below as well as the chart.</P><P></P><P>&nbsp;&nbsp; </P><P>Week_Ending&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; TAT_Days&nbsp;&nbsp;&nbsp;&nbsp; Order_Number</P><P></P><P>3/3/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On-Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A1</P><P>3/3/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On-Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A2</P><P>3/3/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Late&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; A3</P><P>3/10/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Late&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B1</P><P>3/10/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; On-Time&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; B2</P><P>3/17/2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Late&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; C1</P><P>..........</P></BODY></HTML> Thu, 02 May 2013 14:37:53 GMT https://community.qlik.com/t5/QlikView/Convert-Y-Axis-to-Percentage/m-p/420777#M560211 2013-05-02T14:37:53Z Re: Convert Y-Axis to Percentage https://community.qlik.com/t5/QlikView/Convert-Y-Axis-to-Percentage/m-p/420778#M560212 <HTML><HEAD></HEAD><BODY><P>I assume that each week should sum to 100%? If so, you should use </P><P>&nbsp;&nbsp;&nbsp;&nbsp; Count(Order_Number)/Count(total &lt;Week_Ending&gt; Order_Number)</P><P></P><P>Further, you should format the expression to "Integer" and check "Show In Percent" (Numbers tab)</P><P></P><P>HIC</P><P></P><P><IMG __jive_id="40316" class="jive-image-thumbnail jive-image" onclick="" alt="Toatl.png" src="https://community.qlik.com/legacyfs/online/40316_Toatl.png" width="450" /></P></BODY></HTML> Thu, 02 May 2013 14:48:44 GMT https://community.qlik.com/t5/QlikView/Convert-Y-Axis-to-Percentage/m-p/420778#M560212 hic 2013-05-02T14:48:44Z Re: Convert Y-Axis to Percentage https://community.qlik.com/t5/QlikView/Convert-Y-Axis-to-Percentage/m-p/420779#M560213 <HTML><HEAD></HEAD><BODY><P>Million Thanks it worked....<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 02 May 2013 17:55:58 GMT https://community.qlik.com/t5/QlikView/Convert-Y-Axis-to-Percentage/m-p/420779#M560213 2013-05-02T17:55:58Z