topic How to have plot/line like this in Excel in QlikView https://community.qlik.com/t5/QlikView/How-to-have-plot-line-like-this-in-Excel/m-p/909647#M315874 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="93580" alt="Plotstyle.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/93580_Plotstyle.png" style="height: 348px; width: 620px;" /></P><P></P><P>How can&nbsp; Iacheive such plotting.</P><P></P><P>I have call Data : CallStartDate, Call %.</P><P></P><P>Thank You</P></BODY></HTML> Wed, 22 Jul 2015 09:11:48 GMT 2015-07-22T09:11:48Z How to have plot/line like this in Excel https://community.qlik.com/t5/QlikView/How-to-have-plot-line-like-this-in-Excel/m-p/909647#M315874 <HTML><HEAD></HEAD><BODY><P><IMG __jive_id="93580" alt="Plotstyle.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/93580_Plotstyle.png" style="height: 348px; width: 620px;" /></P><P></P><P>How can&nbsp; Iacheive such plotting.</P><P></P><P>I have call Data : CallStartDate, Call %.</P><P></P><P>Thank You</P></BODY></HTML> Wed, 22 Jul 2015 09:11:48 GMT https://community.qlik.com/t5/QlikView/How-to-have-plot-line-like-this-in-Excel/m-p/909647#M315874 2015-07-22T09:11:48Z Re: How to have plot/line like this in Excel https://community.qlik.com/t5/QlikView/How-to-have-plot-line-like-this-in-Excel/m-p/909648#M315875 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>So call % is your expressions, and&nbsp; CallStartDate is your dimension. But there are three expressions in this case</P><UL><LI>Morning call</LI><LI>daily call </LI><LI>late reported call</LI></UL><P>You can create individual expressions and isolate the data using set analysis. Just search set analysis. It should help solve your problems.</P></BODY></HTML> Wed, 22 Jul 2015 09:36:46 GMT https://community.qlik.com/t5/QlikView/How-to-have-plot-line-like-this-in-Excel/m-p/909648#M315875 2015-07-22T09:36:46Z Re: How to have plot/line like this in Excel https://community.qlik.com/t5/QlikView/How-to-have-plot-line-like-this-in-Excel/m-p/909649#M315876 <HTML><HEAD></HEAD><BODY><P>Any example, I have trie some expression, but still not working</P><P></P><P></P><P><IMG alt="Model.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/93629_Model.png" style="height: 286px; width: 620px;" /></P><P>AM_PM correspond to time range&nbsp; :</P><UL><LI>Morning call</LI><LI>daily call</LI><LI>late reported cal</LI></UL><P>Percentage is AVG(UTCount)</P><P>Thanks</P></BODY></HTML> Wed, 22 Jul 2015 12:54:26 GMT https://community.qlik.com/t5/QlikView/How-to-have-plot-line-like-this-in-Excel/m-p/909649#M315876 2015-07-22T12:54:26Z