Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Creator III
Creator III

Need a group dimensions to a same common name in a link table

Hi guys, need some advise.

1) i have created data model - Link table with fact n dimension.

2) found out that 2 fields - Area and Country in the 2 facts tabble ,HAVE to be group to a common field name. for exmaple:

Fact 1 table - Zone_A_Area

Fact 2 table - A_Area

Both have a same list of area data, and i plan to create it as a common dimension, to allow user to select the Area from both of this field(Zone_A_Area & A_Area).

3) I try to use preceding load method, but i got synthetic table - LinkKey + Common_Area.  Exmaple of my precedeing load:

Fact 1 table:

load*,

Zone_A_Area as Common_Area;

load

field 1 & field 2 & field 3 as linkkey,

blablablablablabala;

Fact 2 table

load*,

A_Area as Common_Area;

load

field 1 & field 2 & field 3 as linkkey,

blablablablablabala;

I really dunno what to do. I just wanna change Zone_A_Area & the A_Area as a common name dimension.

0 Replies