Multiple Common Fields in tables. Filtering issue wrt chart

[joybratas1]

Hi, 

I have 3 tables of which two are : VIN and TRIPS. 

Fields in VIN-

stateISO, vehicle_description, vin_id, Date_range, Model_year, trip_count, min_temperature

Fields in TRIPS-

stateISO, trip_count, Date_range, min_temperature, vehicle_description, model_year.

The trip_count for TRIPS is calculated by summing the trip_count in VIN for each min_temperature of VIN grouped by VIN. state_ISO and VIN. vehicle_description

So, 

I have a chart and kpi with sum(TRIP.trip_count). I am facing the issue when I use a filter from VIN table. The sum doesn't work the intended way. While it works fine when I use the filter from TRIP table. 

For example:

TRIP. vehicle_decsription works fine in updating chart while VIN. vehicle_description gives wrong or don't update when filter is selected. 

Any help   will be greatly appreciated. 

Regards, 

Joy Brata Sarkar

[anat · Accepted solution]

seems you are using Qualify *,so no relation between 2 tables<VIN and TRIPS>

if you check in your  datamodel ,2 tables are iland ,thats why if u make any selection in VIN table will not reflect in TRIPS values.

recommendation is remove Qualify and rename the trip_count as trip_coint_VIN

[joybratas1]

Hi, 

The Qualify statement was creating the issue I removed that. I have used Concatenation and renamed the field to 'Trip_count_new'. 

It's now working fine but the qvw file is now slower. Maybe because of the concatenation. Is there any way to better model it. 

[anat]

if stateISO is key field and it contain unique values,then you can do the inner join