Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Input Box Help

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

1 Reply
magavi_framsteg
Contributor III

Re: Input Box Help

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

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Community Browser