topic Complicated Matrix in QlikView

Complicated Matrix

ester_pr — Mon, 26 Dec 2011 12:19:47 GMT

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

Complicated Matrix

pover — Tue, 27 Dec 2011 21:17:13 GMT

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

Complicated Matrix

ester_pr — Thu, 05 Jan 2012 13:52:28 GMT

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