show selected records in a table

[Anonymous]

I have a EFQM dbase with performance indicators, enablers and actions

I want to present it like the model.

The enablers are Leadership, People, Strategy, Partnerships and processes.

Every performance indicator has actions at each enabler.

When a user select a performance indicator I wat to show 5 tableboxes (is this the right tool)

with the actions that belong to that specific enabler

Part of the dbase:

Enabler	Action	PI
Leadership	A1	PI1
Leadership	A2	PI1
Strategy	A3	PI1

Leadership
A1
A2

Above and below table result after selecting PI1

Strategy
A3

How to manage?

[ramasaisaksoft]

Yes, it will come output as you expected.

if you select P11

1st straight table

for that in qlikview you need to write like

Select Straight table -->add dimension-->Dimension condition like =if(Enabler='Leadership',Enabler)

so this condition will show A1,A2 in this straight table

2nd straight table

Select Straight table -->add dimension-->Dimension condition like =if(Enabler='Strategy',Enabler)