topic How to sumarize from one table field and devide the result from other table field caunting. in QlikView https://community.qlik.com/t5/QlikView/How-to-sumarize-from-one-table-field-and-devide-the-result-from/m-p/218591#M71678 <HTML><HEAD></HEAD><BODY><P>Hello! I have a big problem. I can't find thecorrect solution for my problem. I have 2 tables: one is Claims table and second is Bus_Truck_Sale table. The key field in Claims table should be "ChassiNo" and in Bus_Truck_Sale table - "VIN". I need to make graph Costs per one Vehicle it means: I should make SUM(AATotalCosts) from table Claims devide it COUNT(DISTINCT VIN) from table Bus_Truck_Sale in 12 months back period. The couted vehicles must not be older 12 months in this period. Some vehicles are in bouth tables some not, but when I couting vehicles I should in clude vehicle which don't have any claims but it sold in this period.</P></BODY></HTML> Fri, 09 Jul 2010 11:03:23 GMT 2010-07-09T11:03:23Z How to sumarize from one table field and devide the result from other table field caunting. https://community.qlik.com/t5/QlikView/How-to-sumarize-from-one-table-field-and-devide-the-result-from/m-p/218591#M71678 <HTML><HEAD></HEAD><BODY><P>Hello! I have a big problem. I can't find thecorrect solution for my problem. I have 2 tables: one is Claims table and second is Bus_Truck_Sale table. The key field in Claims table should be "ChassiNo" and in Bus_Truck_Sale table - "VIN". I need to make graph Costs per one Vehicle it means: I should make SUM(AATotalCosts) from table Claims devide it COUNT(DISTINCT VIN) from table Bus_Truck_Sale in 12 months back period. The couted vehicles must not be older 12 months in this period. Some vehicles are in bouth tables some not, but when I couting vehicles I should in clude vehicle which don't have any claims but it sold in this period.</P></BODY></HTML> Fri, 09 Jul 2010 11:03:23 GMT https://community.qlik.com/t5/QlikView/How-to-sumarize-from-one-table-field-and-devide-the-result-from/m-p/218591#M71678 2010-07-09T11:03:23Z