Table design issues

[#1]

Hey Guys,

I have tried a lot of different options, but I have not yet found what I'm looking for.

I want to create a table Thats shows the following:

DangerId	Location name	Type	Danger level
1	name1	type2	1.2
2	name1	type1	0.4
3	name2	type2	0.8

Any rows containing a value for danger level below 0.3 should never be shown.

The DangerId is actually something like 'ASDF-2345-ERGK-2367', but should appear in the table as a unique int (or any more comprehensible identifier).

Then there is a second table, showing the instances that provide the danger.

InstanceId	Description	Location name	Type
1	description1	name1	type1
2	description2	name1	type1
3	description3	name1	type2
4	description4	name2	type1
5	description5	name2	type2
6	description6	name2	type2

This table should show all instances that have the same location and type as the selected danger.

I've tried list box, pivot table, straight table and table box, but I can not get this working in any of those.

What tables should I use and how can I connect them to achieve this?

Regards,

Sijmen

[Gysbert_Wassenaar]

See attached qvw.

[#3]

Thank you for your reaction!

However, I only see one table. Combining the tables into one does not solve the problem, because in the real model I have over 500 dangers and over 10000 instances. The resulting table would provide no overview.

I really need the dangers and instances to be in seperate tables. Any suggestions?

[Gysbert_Wassenaar]

I'm not sure you understand the difference between tables in the data model and the sheet objects Table Box, Straight Table and Pivot Table. The data is stored in tables in the data model. You can see these tables by opening the Table Viewer (from the File menu).

Users interact with data using sheet objects like for example Table Boxes, Straight Tables, Pivot Tables and List Boxes.

If you open the Table Viewer you can see that the data in the example is loaded in two tables. There's nothing preventing you from showing this data in as many sheet objects as you need.

[#5]

I'm sorry for being unclear. I fixed the problem in the meantime, the syn keys made by qlikview was actually the solution to my sheet object Table linking problem.

Thanks for your help.