topic Building a line chart in QlikView https://community.qlik.com/t5/QlikView/Building-a-line-chart/m-p/270310#M1203642 <HTML><HEAD></HEAD><BODY><P>hey guys....probably a very simple problem but I've been stuck on this for quite a while.</P><P>I want to build a line chart with date as dimension and the value my orders as result (expression)</P><P>I have three tables:<BR />Customer (Customer ID, Name, ....), Product(Product ID, Name, Price,...) and Sales (CustomerID, ProductID, Date,...)</P><P>On the "Dimension" tab I selected the date and on the Expression tab I entered the following statement</P><P>sum( [Price])</P><P>The Problem is that the values are not added correctly.</P><P>Any ideas please?</P><P></P><P></P></BODY></HTML> Tue, 10 Aug 2010 15:27:36 GMT 2010-08-10T15:27:36Z Building a line chart https://community.qlik.com/t5/QlikView/Building-a-line-chart/m-p/270310#M1203642 <HTML><HEAD></HEAD><BODY><P>hey guys....probably a very simple problem but I've been stuck on this for quite a while.</P><P>I want to build a line chart with date as dimension and the value my orders as result (expression)</P><P>I have three tables:<BR />Customer (Customer ID, Name, ....), Product(Product ID, Name, Price,...) and Sales (CustomerID, ProductID, Date,...)</P><P>On the "Dimension" tab I selected the date and on the Expression tab I entered the following statement</P><P>sum( [Price])</P><P>The Problem is that the values are not added correctly.</P><P>Any ideas please?</P><P></P><P></P></BODY></HTML> Tue, 10 Aug 2010 15:27:36 GMT https://community.qlik.com/t5/QlikView/Building-a-line-chart/m-p/270310#M1203642 2010-08-10T15:27:36Z AW:Building a line chart https://community.qlik.com/t5/QlikView/Building-a-line-chart/m-p/270311#M1203645 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I think sum(Price) is wrong, because your Table Product has no connection to the date, would be better, you enter the expression: Sum(Quantity*Price), if Quantity is a field from Table Sales.</P></BODY></HTML> Tue, 10 Aug 2010 15:32:47 GMT https://community.qlik.com/t5/QlikView/Building-a-line-chart/m-p/270311#M1203645 brenner_martina 2010-08-10T15:32:47Z