Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

datalakeyu
Valued Contributor

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
MVP
MVP

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

Try pressing CTRL key while selecting your values.

4 Replies
MVP
MVP

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

Try pressing CTRL key while selecting your values.

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

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

datalakeyu
Valued Contributor

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

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)

datalakeyu
Valued Contributor

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

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!