Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try pressing CTRL key while selecting your values.

View solution in original post

4 Replies
swuehl
MVP
MVP

Try pressing CTRL key while selecting your values.

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

Anonymous
Not applicable
Author

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)

Anonymous
Not applicable
Author

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!