Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
abubakarsiddiq7
Contributor III
Contributor III

Need help on data model

hi

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

TableA:

load
Sales Org",
Customer ",
PLQ",
Sold to customer",
Sold To",
Street Name",
city
office
Postal Code
Representative ;


TableB:

LOAD
IKF ,
Sales Org",
Customer ",
PLQ",
Sold to customer
city
office
Store Segmentation
"2019 Sales"

TableC:
IKF,
Sales Org,
Total Accounts

3 Replies
juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

hello,

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?

Bye

abubakarsiddiq7
Contributor III
Contributor III
Author

Hi,

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

 

Thanks

juliensaintmaxent3113
Luminary Alumni
Luminary Alumni

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