Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


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.

Not applicable

Complicated Matrix


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



2 Replies
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.


Not applicable

Complicated Matrix

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