Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ester_pr
Not applicable

Complicated Matrix

Hi,

I have to create a table that takes dimensions and measures from diffrent tables, for example:

Payment - sum filed wher filed rechiv 0001 from payment table

Expense - pay filed wher filed tipe 0005 from expenses table and so on

The fileds are not in the key table because ther are too many , the key table has the time and the place

I know i  need matrix tables for the hedlines

dut how do i :

1.show the hedlines even when ther is no rechiv in thet time or place

2. put all the matrics hedlines in one chart table?

I hope i was clear

thank's

Ester

2 Replies
pover
Not applicable

Complicated Matrix

Your key or link table would need to contain all the possible combinations of the keys to work properly.  I prefer to concatenate all my transactions into 1 table.  It simplifies my development, runs faster and sometimes uses less RAM.  Keep it simple and don't use the link table.

Karl

ester_pr
Not applicable

Complicated Matrix

Thank's but I thought of a different wey because actualy i have lotes of tables in the model