topic How to Create a Line chart for Selected companies in QlikView https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324908#M579343 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I have to create two line charts </P><P>The data for the 1st chart is all the companies in the group <STRONG>which i have created</STRONG></P><P>In the 2nd i have to use the same data but for selected companies, i tried using "<SPAN style="font-size: 8pt;">Sum ({&lt;ATC3={$(=[A10N])}&gt;} [LEUData])" <SPAN style="font-size: 10pt;">formula, here ATC is the Field name and [A10N] is of the the Company, but its not saying no data to display,</SPAN></SPAN></P><P><SPAN style="font-size: 10pt;">Can any one help me on this, </SPAN></P><P><SPAN style="font-size: 10pt;">Thanks in advance</SPAN></P></BODY></HTML> Tue, 28 Feb 2012 13:27:58 GMT 2012-02-28T13:27:58Z How to Create a Line chart for Selected companies https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324908#M579343 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>I have to create two line charts </P><P>The data for the 1st chart is all the companies in the group <STRONG>which i have created</STRONG></P><P>In the 2nd i have to use the same data but for selected companies, i tried using "<SPAN style="font-size: 8pt;">Sum ({&lt;ATC3={$(=[A10N])}&gt;} [LEUData])" <SPAN style="font-size: 10pt;">formula, here ATC is the Field name and [A10N] is of the the Company, but its not saying no data to display,</SPAN></SPAN></P><P><SPAN style="font-size: 10pt;">Can any one help me on this, </SPAN></P><P><SPAN style="font-size: 10pt;">Thanks in advance</SPAN></P></BODY></HTML> Tue, 28 Feb 2012 13:27:58 GMT https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324908#M579343 2012-02-28T13:27:58Z How to Create a Line chart for Selected companies https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324909#M579344 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Comparing the field value should not be within $()</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum ({&lt;ATC3={'A10N'}&gt;} [LEUData])</P><P></P><P>Hope it helps</P><P>Celambarasan</P></BODY></HTML> Tue, 28 Feb 2012 13:30:21 GMT https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324909#M579344 CELAMBARASAN 2012-02-28T13:30:21Z How to Create a Line chart for Selected companies https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324910#M579345 <HTML><HEAD></HEAD><BODY><P>Hi Celambarasan,</P><P>Thanks for your reply i have around 10 companies can you tell how to change the syntax</P></BODY></HTML> Tue, 28 Feb 2012 13:40:33 GMT https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324910#M579345 2012-02-28T13:40:33Z How to Create a Line chart for Selected companies https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324911#M579346 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; You can add companies by comma in between them</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum ({&lt;ATC3={'A10N','A20N','A30N'}&gt;} [LEUData])</P><P></P><P>Celambarasan</P></BODY></HTML> Tue, 28 Feb 2012 13:43:18 GMT https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324911#M579346 CELAMBARASAN 2012-02-28T13:43:18Z How to Create a Line chart for Selected companies https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324912#M579347 <HTML><HEAD></HEAD><BODY><P> Ayyyyyy ur syntax has worked thanks alot for your help</P></BODY></HTML> Tue, 28 Feb 2012 13:51:19 GMT https://community.qlik.com/t5/QlikView/How-to-Create-a-Line-chart-for-Selected-companies/m-p/324912#M579347 2012-02-28T13:51:19Z