Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ramshoney
Contributor

Selecting on map shows to relevant text data in Textbox.

Hi,

I have a map viz, where I'm showing Sales rep as a bubble, The next to the Map I placed a Textbox. So when I Click on the Bubble ( Sales Rep ) which it should show his text information( I'm pulling only one column into the Textbox )  it should show his last 3 text information.

I created a Textbox and placed the Textcolumn into the Fx. ( How to wirte the set here its giving me error ) when I try to use fx as below.

={$[TextName]}

27 Replies
shraddha_g
Honored Contributor III

Re: Selecting on map shows to relevant text data in Textbox.

What do you want to display in Text Box?

You can use for Ex. Concat(GetFiledSelection(SalesRep),',') to Display selected Sales Rep name.

Please provide some Input data n Expected output to be shown in Textbox

ramshoney
Contributor

Re: Selecting on map shows to relevant text data in Textbox.

Shraddha, Thanks for the reply.

Please find the below Sample data. There are many columns in TableA and TableB i'm just provided only the target columns.

Table exmaple.png

I have a Map Viz, and Table Viz ( with only one column "comment" )

So when I select Raj in the Map, in the Tab Viz it should show his last two updated comment, here we have 4 comments provided for each user, i need to get top 2 comments from that table.

shraddha_g
Honored Contributor III

Re: Selecting on map shows to relevant text data in Textbox.

how would you identify that those are top 2 comments ?

Can you provide sample app and sample data?

ramshoney
Contributor

Re: Selecting on map shows to relevant text data in Textbox.

I have Year,Month,Date,Hour,Day. etc from TableB.

shraddha_g
Honored Contributor III

Re: Selecting on map shows to relevant text data in Textbox.

can you share this excel having all columns with limited data?

ramshoney
Contributor

Re: Selecting on map shows to relevant text data in Textbox.

Shraddha, I'm sharing some sample data.As i cant share the original data which is sensitive information.

II'm not able to see the upload Document option here.

shraddha_g
Honored Contributor III

Re: Selecting on map shows to relevant text data in Textbox.

Highlighted
ramshoney
Contributor

Re: Selecting on map shows to relevant text data in Textbox.

Shraddha, I'm using some client data it is sensitive information.

shraddha_g
Honored Contributor III

Re: Selecting on map shows to relevant text data in Textbox.

you can Scramble or change data in columns
Community Browser