Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted

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

Highlighted
Contributor II
Contributor II

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

Highlighted

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