show selected records in a table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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:

Leadership
A1
A2

Above and below table result after selecting PI1

Strategy
A3

How to manage?

Re: show selected records in a table

ramasaisaksoft — Thu, 15 Mar 2018 06:07:41 GMT

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)