1 Reply Latest reply: Aug 3, 2011 11:24 AM by Patrick Laredo RSS

    Every selection in green

      Hello

       

      I would like to know if it's possible to color every data linked to a selection in green. For example, in a table where I have the choice Male or Female, I want that when I select Male, every Men in the User table are selected in Green (actually in white in QlikView)

       

      Thank you =)

       

      Annie

        • Every selection in green
          Patrick Laredo

          hi,

           

          the qlikview colours green white and grey fit with the basic aql design. All your males are white because they can logically be selected without moving away from your selection of gender='male'. they are not green because their names have not been selected.

           

          If you want them to be selected you would have to write a macro which woud chnage the status of the User field to "selected" for all those that are "possible". This would mimic the "select possible" action you get with the right button click on a selection box.

           

          The macro would be fired each time you change the field gender (male/female). You woud have to be careful about any other selections which could be or have been made in your document.

           

          The macro would include the  line

           

          ActiveDocument.Fields("User").SelectPossible