Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
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
Highlighted
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.

View solution in original post

4 Replies
Highlighted
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.

View solution in original post

Highlighted

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

Highlighted
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)

Highlighted
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!