Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ester_pr
Partner - Creator
Partner - Creator

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
Luminary Alumni
Luminary Alumni

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
Partner - Creator
Partner - Creator
Author

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