1 Reply Latest reply: Jul 10, 2012 5:23 AM by Magnus ÅVITSLAND RSS

    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

        • Re: Input Box Help
          Magnus ÅVITSLAND

          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.