Input Box Help

Tue, 10 Jul 2012 08:24:37 GMT

i have two input box , first vertical and then plant

my inputbox has the following data look as

vertical Plant

Blade 1003,1008,2501

Nacelle 1005,1004

in my input box if i select blade then i should only able see its respective plants.

So please help me out on this issue

Re: Input Box Help

magavi_framsteg — Tue, 10 Jul 2012 09:23:20 GMT

Hi sumitthakur.mpvm.

May I ask why you use an input box for this?

The "QlikView way" is by taking benefit of the extremely efficient associative data model and thus associating verticals with 0..n plants.

Table examples (pseudo code):

Table Verticals:

Vertical, Plant

Blade, 1003

Blade, 1008

Blade, 2501

Nacelle, 1004

Nacelle, 1005

Table Plants:

Plant

1003

1004

1005

1008

2501

Then if you select vertical Blade, you get all associated Plants 1003, 1008 and 2501.

Maybe this will help you?

Kind regards

BI Consultant