9 Replies Latest reply: Apr 8, 2013 3:21 AM by WANG Xu RSS

    Hide two values from a list box?

      Hi,

      In my script I have the following inline table:

       

      Qualify*;

      Dimension:

      LOAD * INLINE [
      Dimension, Selection
      1, Segment 1
      2, Segment 2
      3, Segment 3
      4, Segment 4
      5, Segment 5
      6, Segment 6
      7, Segment 7
      ]
      ;
      UNQUALIFY*;

       

      I use the above inline table in a list box - See attached sample.


      The above works perfectly at the moment but I now need to create another list box on another tab that doesn't require Segment 6 & Segment 7 (but all other segments are required).  Since I would like to keep the existing inline table I would like to know if its possible to hide Segment 6 and Segment 7 from been displayed in the new list box? 

       

      thanks in advance

        • Re: Hide two values from a list box?

          Hi,

           

          Please see attached file. I have used expression to exclude the 2 segments in the list box.

           

          Regards,

           

          Janzen

            • Re: Hide two values from a list box?

              Thanks Janzen, very helpful but its still not quite what I'm looking for.  With your solution when Segment 1 is selected in the 2nd list box the first list box automatically selects Segment 1,  Segment 6 and Segment 7.  What I need to get working is when Segment 1 is selected it should automatically select Segment 1 across both list boxes i.e. it should work in the same way when choosing Segment 2,3,4 or 5.  Likewise when Segment 6 or Segment 7 is selected in the first list box the 2nd list box automatically selects Segment 1 in the 1st list box.  Can this be changed so the users last selected option in the second list box or possibly the list box default option gets displayed instead?   I hope this makes sense!

               

              Thanks again

            • Re: Hide two values from a list box?
              sivasankar kanagasabai

              Hi Rebelman,  You can use HidePrefix feature. It will help you to convert the field into system fields, but still you can use it in inline for any calculations. Attached the qvw file. Hope it will be helpful.  Regards. Siva Sankar k

              • Re: Hide two values from a list box?

                I have included the WILDMATCH in the expression to hide 'Segment 6' and 'Segment 7' but I need to do the following:

                At the moment when a user selects a segment from the list box that contains Segments 1 - 5 and then selects either Segment 6 or 7 from the other list box the original selection gets deselected.  Is there anyway to keep the selections?  For example user selects Segment 1 (from the list box containing Segment 1 - 5) then selects Segment 6 from the other list box - I need Segment 1 to be still selected.  Attached is the updated file with the WILDMATCH expression.

                 

                Thanks again

                • Re: Hide two values from a list box?
                  Jonathan Dienst

                  Hi

                   

                  I would solve this problem like this. First, create a second selection field in the LOAD statement:

                   

                  Dimension:

                  LOAD * INLINE [

                  Dimension, Selection, Selection2

                  1, Segment 1, Segment 1

                  2, Segment 2, Segment 2

                  3, Segment 3, Segment 3

                  4, Segment 4, Segment 4

                  5, Segment 5, Segment 5

                  6, Segment 6

                  7, Segment 7

                  ];

                   

                   

                  Note that the values are the same, except that 6 and 7 are null for the second selection. Now use Selection for the list box on the first tab and use Selection2 in the second one.

                   

                  Because the fields are associated, selecting Segment 1 in the first box will select Segment 1 in the second and vv. If you select Segment 6 or 7 in the first, then nothing will be selected in the second tab.

                   

                  Hope that helps

                  Jonathan