Discussion board where members can get started with Qlik Sense.
i have the table like below .i need to prepare data model for it can any help me on it.
i have implemented that but i am getting some data mismatch
Note : I need all the coloumns
loadSales Org",Customer ",PLQ",Sold to customer",Sold To",Street Name",cityofficePostal CodeRepresentative ;
LOADIKF ,Sales Org",Customer ",PLQ",Sold to customercityofficeStore Segmentation"2019 Sales"
TableC:IKF,Sales Org,Total Accounts
what is the functional link between the table?
in two tables, you have the same field like Sales Org",Customer ",PLQ", is it your functional link?
TableA: Sales Org", key field
TableB: Sales Org" Sold to customer combination of two fields as key field
TableC: IKF, Sales Org, combination of two fields as key field
If i understand, your link is Sales org, it's the good field which appears in the 3 tables
So rename the other fields from each table to avoid the syn table and keep Sales org
Other solution is to concatenate all table with a add like 'tableA' as TypeFact on the table A, 'TableB' as TypeFAct,...
And in expression, you select what you want with set analysis