topic Re: Chart question... in QlikView https://community.qlik.com/t5/QlikView/Chart-question/m-p/892077#M999701 <HTML><HEAD></HEAD><BODY><P>Melanie</P><P></P><P>you can add a second expression (which will be the same as the first one sum(CallCounter) and select the Relative checkbox, this should then give you the number of calls as a percentage of the total instead of the absolute number</P></BODY></HTML> Mon, 15 Jun 2015 11:16:10 GMT tracysmart 2015-06-15T11:16:10Z Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892070#M999694 <HTML><HEAD></HEAD><BODY><P>Another chart question I'm afraid (I will master these) <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I've used the Straight Table chart option to create a chart which contains two dimensions... IndexDate and CallsReason.&nbsp; The expressions are =sum(CallCounter) which gives me the number of calls and I'd like to include another which details the % of these calls.&nbsp; Should I be creating a Calculated Dimension? The table below is similar to the one I've created.</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 3</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 4</STRONG></TH></TR><TR><TD style="padding: 2px;">Call Logged date</TD>Reason for Call<TD style="padding: 2px;">No. of Calls</TD><TD style="padding: 2px;">%</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">01/06/2015</TD>Reason 1<TD style="padding: 2px;">2</TD><TD style="padding: 2px;">0%</TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">01/06/2015</TD><TD style="padding: 2px;">Reason 2</TD><TD style="padding: 2px;">11</TD><TD style="padding: 2px;">0%</TD></TR><TR><TD style="padding: 2px;">01/06/2015</TD><TD style="padding: 2px;">Reason 3</TD><TD style="padding: 2px;">8</TD><TD style="padding: 2px;">0%</TD></TR><TR><TD style="padding: 2px;">02/06/2015</TD><TD style="padding: 2px;">Reason 1</TD><TD style="padding: 2px;">10</TD><TD style="padding: 2px;">0%</TD></TR><TR><TD style="padding: 2px;">02/06/2015</TD><TD style="padding: 2px;">Reason 2</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">0%</TD></TR></TBODY></TABLE><P></P><P>Thanks in advance <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 15 Jun 2015 11:06:57 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892070#M999694 2015-06-15T11:06:57Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892071#M999695 <HTML><HEAD></HEAD><BODY><P>Use a calculated dimension for % of calls. can you also please share your data?</P></BODY></HTML> Mon, 15 Jun 2015 11:10:47 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892071#M999695 Anonymous 2015-06-15T11:10:47Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892072#M999696 <HTML><HEAD></HEAD><BODY><P>add another expression</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(CallCounter)/<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum(Total CallCounter)</SPAN></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Mon, 15 Jun 2015 11:10:48 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892072#M999696 arulsettu 2015-06-15T11:10:48Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892073#M999697 <HTML><HEAD></HEAD><BODY><P>Try the TOTAL qualifier:</P><P></P><P>For percentage share per Date:</P><P>=sum(CallCounter) / sum(TOTAL&lt;IndexDate&gt; CallCounter)</P><P></P><P>Or for total share:</P><P>=sum(CallCounter) / sum(TOTAL CallCounter)</P></BODY></HTML> Mon, 15 Jun 2015 11:11:43 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892073#M999697 swuehl 2015-06-15T11:11:43Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892074#M999698 <HTML><HEAD></HEAD><BODY><P>another expression:</P><P></P><P>%calls= sum(callcounter)/sum(Total(callcounter)</P><P></P><P>or sum(callcounter) check relative , u will get percentages.</P></BODY></HTML> Mon, 15 Jun 2015 11:12:52 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892074#M999698 2015-06-15T11:12:52Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892075#M999699 <HTML><HEAD></HEAD><BODY><P>Hi Melanie,</P><P></P><P>It sounds more like you should add a new expression and maybe move over to a pivot table and pivor it so you get the header dim the way you liked (vertical). </P><P></P><P>Good luck! </P></BODY></HTML> Mon, 15 Jun 2015 11:12:54 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892075#M999699 2015-06-15T11:12:54Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892076#M999700 <HTML><HEAD></HEAD><BODY><P>You can simply use the same expression again and tick the "relative" option</P></BODY></HTML> Mon, 15 Jun 2015 11:13:11 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892076#M999700 Anonymous 2015-06-15T11:13:11Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892077#M999701 <HTML><HEAD></HEAD><BODY><P>Melanie</P><P></P><P>you can add a second expression (which will be the same as the first one sum(CallCounter) and select the Relative checkbox, this should then give you the number of calls as a percentage of the total instead of the absolute number</P></BODY></HTML> Mon, 15 Jun 2015 11:16:10 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892077#M999701 tracysmart 2015-06-15T11:16:10Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892078#M999702 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>try this.</P><P>Regards.</P><P></P><P>/Giuseppe</P></BODY></HTML> Mon, 15 Jun 2015 11:34:03 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892078#M999702 Anonymous 2015-06-15T11:34:03Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892079#M999703 <HTML><HEAD></HEAD><BODY><P>Thanks Tracy... the expression already existed, I just needed to check the 'Relative' box. Thanks so much for the prompt replies.</P></BODY></HTML> Mon, 15 Jun 2015 11:34:39 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892079#M999703 2015-06-15T11:34:39Z Re: Chart question... https://community.qlik.com/t5/QlikView/Chart-question/m-p/892080#M999704 <HTML><HEAD></HEAD><BODY><P> use below expression for % values</P><P></P><P>sum(callcounter)/sum(TOTAL callcounter).</P><P>now you can get % wise values.</P></BODY></HTML> Mon, 15 Jun 2015 11:35:25 GMT https://community.qlik.com/t5/QlikView/Chart-question/m-p/892080#M999704 ravindraa 2015-06-15T11:35:25Z