Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
abubakarsiddiq7
Contributor III
Contributor III

Data Model Issue

i have 3 tables

 

T1:

Current Year Sales

Previous Year Sales

Company Name

Selection Code--->Key Field

Sales

PLC

 

 

T2:

IKY,

PLC,

"Company Name"

"Total Accounts",

"New Target",

"Sales Target

 

 

T3:

IKY ,

PLC,

"Company Name"

Selection Code

"Store Location",

"2019 Target"

 

combination of PLC + "Company Name"(Key Field) need to join T2 and T3

 

then Need to Join with Selection Code(Key field) with T1.

 

Note: i have to keep IKY and Company Code as a main filters in my Visuvalization.

Labels (1)
1 Reply
JustinDallas
Specialist III
Specialist III

It might be better if you showed your example with some dummy data and a "LOAD * Inline" script.  As it stands now, the formatting makes it difficult to see what's you've got, and where you want to go.