topic Costs per one Vehicle in QlikView https://community.qlik.com/t5/QlikView/Costs-per-one-Vehicle/m-p/218338#M71497 <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 08:34:32 GMT 2010-07-09T08:34:32Z Costs per one Vehicle https://community.qlik.com/t5/QlikView/Costs-per-one-Vehicle/m-p/218338#M71497 <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 08:34:32 GMT https://community.qlik.com/t5/QlikView/Costs-per-one-Vehicle/m-p/218338#M71497 2010-07-09T08:34:32Z