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

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
Partner - Master III
Partner - Master III

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

Anonymous
Not applicable
Author

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
Partner - Master III
Partner - Master III

how would you identify that those are top 2 comments ?

Can you provide sample app and sample data?

Anonymous
Not applicable
Author

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

shraddha_g
Partner - Master III
Partner - Master III

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

Anonymous
Not applicable
Author

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
Partner - Master III
Partner - Master III

Anonymous
Not applicable
Author

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

shraddha_g
Partner - Master III
Partner - Master III

you can Scramble or change data in columns