topic Re: Calculated Expression - Line Chart in QlikView https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563531#M1112098 <HTML><HEAD></HEAD><BODY><P>Hi Jeffrey,</P><P>The file has been attached by Gysbert,</P><P>Guess u r seeing the reply through mail,</P><P>Please login to see the attachment.</P><P></P><P>-Sundar</P></BODY></HTML> Wed, 26 Feb 2014 06:46:13 GMT sundarakumar 2014-02-26T06:46:13Z Calculated Expression - Line Chart https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563528#M1112095 <HTML><HEAD></HEAD><BODY><P>Attached is a table of data that I want to use for creating a line chart. I want to use "Yr/Mon" as the dimension. I want to calculate the overall combined (for all sites) complaints per million: (sum of complaints/sum of shipments)*1,000,000 for each Yr/Mon. I would also like when I select a site, it calculates the CPM for each Yr/Mon for that site alone.</P><P></P><P>What is the expression calcuation? I know it's not a matter of adding up the CPMs.</P><P></P><P>Thanks.</P><P></P><P>Jeff</P></BODY></HTML> Tue, 25 Feb 2014 05:47:59 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563528#M1112095 jmonroe918 2014-02-25T05:47:59Z Re: Calculated Expression - Line Chart https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563529#M1112096 <HTML><HEAD></HEAD><BODY><P>The expression is simply sum(Complaints)/sum(Shipments)*1000000. Use Yr/Month as dimension for the line chart. Add a listbox for Site to select the sites. See attached qvw.</P></BODY></HTML> Tue, 25 Feb 2014 06:29:51 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563529#M1112096 Gysbert_Wassenaar 2014-02-25T06:29:51Z Re: Calculated Expression - Line Chart https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563530#M1112097 <HTML><HEAD></HEAD><BODY><P>Gysbert:</P><P>Did you attache at file?</P><P>Jeff</P></BODY></HTML> Tue, 25 Feb 2014 21:34:38 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563530#M1112097 jmonroe918 2014-02-25T21:34:38Z Re: Calculated Expression - Line Chart https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563531#M1112098 <HTML><HEAD></HEAD><BODY><P>Hi Jeffrey,</P><P>The file has been attached by Gysbert,</P><P>Guess u r seeing the reply through mail,</P><P>Please login to see the attachment.</P><P></P><P>-Sundar</P></BODY></HTML> Wed, 26 Feb 2014 06:46:13 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563531#M1112098 sundarakumar 2014-02-26T06:46:13Z Re: Calculated Expression - Line Chart https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563532#M1112099 <HTML><HEAD></HEAD><BODY><P>Sundar:</P><P></P><P>I haven't seen any attachment in this post. Where would it be?</P><P></P><P>Jeff</P></BODY></HTML> Wed, 26 Feb 2014 15:02:36 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563532#M1112099 jmonroe918 2014-02-26T15:02:36Z Re: Calculated Expression - Line Chart https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563533#M1112100 <HTML><HEAD></HEAD><BODY><P>Sundar:</P><P></P><P>Never mind. I found it.</P><P></P><P>Thanks.</P><P></P><P>Jeff</P></BODY></HTML> Wed, 26 Feb 2014 15:04:54 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563533#M1112100 jmonroe918 2014-02-26T15:04:54Z Re: Calculated Expression - Line Chart https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563534#M1112101 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/laugh.png" /></P></BODY></HTML> Thu, 27 Feb 2014 07:44:39 GMT https://community.qlik.com/t5/QlikView/Calculated-Expression-Line-Chart/m-p/563534#M1112101 sundarakumar 2014-02-27T07:44:39Z