4 Replies Latest reply: Jun 22, 2016 12:12 AM by Haikuo Yu RSS

    Is it possible to use Qlik PICK function to only pick up one item?

    Haikuo Yu

      I use states as my map dimension. I would like to only pick up one state when I click the map. For example, if I click state_1 and state_1 will be selected, and then if I click state_2, state_1 will be deselected and only state_2 is selected now.

      Could you please give any suggestion?

      Thanks!

        • Re: Is it possible to use Qlik PICK function to only pick up one item?
          Stefan Wühl

          Try pressing CTRL key while selecting your values.

            • Re: Is it possible to use Qlik PICK function to only pick up one item?
              Colin Albert

              Have a look at the Horizontal Listbox in the Sense Extension Examples folder.

                   Examples\Extensions\HorizList

               

              This has options to change the Selection Mode.

              SenseHorizList.jpg

                • Re: Is it possible to use Qlik PICK function to only pick up one item?
                  Haikuo Yu

                  Swuehl and and Colin, thanks so much for your help!

                  My specific question is:

                  I would like to create a polygon map with Qlik Sense Desktop. I need to use state as dimension to create the map, will set the map color according to the region of states in the map, and also create a map color legend. When I click the state at the map, I can show some information about the selected state.

                  Right now, I have several problems:

                  1: I use expression to create map color, but there is no map color legend with expression.

                  2: I create a table, set the text background as the same as map color, and use it as map color legend, but I can not put the created map legend on top of the map any more. (I would like to create a map legend on top of the map)

                  3: I use Text&image to show information when I click one state on the map, but when I click another state, the previous selected state can not be de-selected. (I would like to only show information about one state that I click on the map )

                   

                  I attach my Qlik Sense qvf file.

                  Could you please give any suggestion?

                  Thanks!

                   

                  I use map data at:

                  KML US and World Map and Sample Data

                  I also refer:

                  color by expression - QlikSense

                   

                  I use the following expression to create map color:

                   

                  If ( REGION = 'West', red(),

                        If ( REGION = 'East', green(),

                            (

                              if ( REGION = 'North', blue(),

                                  if (REGION = 'South', yellow(), cyan())

                                )  

                            )

                        )

                  )

                   

                  I use the following expression to create text background color and use it as map color legend:

                   

                  Pick( 1 + Match(Only({1} REGION),

                                'West',

                                'East',

                                'North',

                                'South'

                                ),

                            Black(),

                            red(),

                            green(),      

                            blue(),

                            yellow()

                      )

                   

                  I use the following expression to show information about the selected state when I click the state on the map:

                   

                  'StoreName and City at Selected State: '

                  & chr(13)

                  &'StoreName: ' & (STORENAME)

                  & chr(13)

                  &'StoreName: ' & (City)

                • Re: Is it possible to use Qlik PICK function to only pick up one item?
                  Haikuo Yu

                  Swuehl , thanks so much for your help!


                  When I click a states polygon map, I would like to show some information in the Qlik Text&iamge part.

                  I use the following expression at Text&image part, but it does not work.

                   

                  subfield(getfieldselections(myState,'#', 53), '#' , -1) does not work.


                  For example, if I firstly click Washington state, text part will always show 'Washington'; if i firstly click Arizona (if i keep clicking state with name order), the text part will be correct.

                   

                  Could you please give any suggestion?

                  Thanks!