Table1 with (TerritoryID,Area) with ( TerritoryID 55 Distinct Values )
Table2 with ( TerritoryID, TerritoryStae, PostCode ) with (TerritoryID 62 Distinct Values)
Table3 with (TerritoryID,Cust First Name,Cust Last Name,Sales Rep) with (TerritoryID 130 DIstinct Values )
I Made all the Tables Join with TerritoryID Column in the Load editor.
When I Create a Table report in the QlikSense, When I pull a Dimension column from TerritoryID (Expression editor fx) it is pulling all the 130 Dimension values into the Table report.
So i removed it and pull the column from Table1.TerritoryID (Expression editor fx) which im expecting only the 55 Distinct TerritoryID values, again it is showing the same 130 Distinct values even i'm pulling from Table1.TerritoryID.
Table1 with (TerritoryID,TerritoryArea ) with ( TerritoryID 55 Distinct Values )
Table4 with (TerritoryID,State) with (TerritoryID 42 Distinct Values ) all these 42 values exists in Table1
So when i Join The table as below im getting
FROM .....Table2.xlsx (ooxml, embedded labels, table is Sheet);
FROM ......... (qvd);;
LOAD state as 'Terr State'
When i ran the above in Table1
Im getting TerritoryID,Area,'Terr State' with 225 Records. where i'm expecting 55 records.