Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Please with table

Hi all,

I have a file, where there is comment field "CleanedText_Comment"

I'd like to select any comment from "CleanedText_Comment" and get Id and Url in a table chart.

My manually steps work so:

1. I select any comment from list box "CleanedText_Comment"

2. Select possible SessionId

3. Deselect "CleanedText_Comment"

My table show me all values.

Please find the attached file.

Thanks,

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I got it

vSID=IF(GetSelectedCount(CleanedText_Comment)=1, SessionId,null())

trigger  CleanedText_Comment onSelect and onChange

select in Field SessionId

=vSID

in the table expression

only({<CleanedText_Comment= ,SessionId={'$(vSID)'}>}Url)

View solution in original post

11 Replies
Anonymous
Not applicable
Author

how to select certain Id?

I tried

only({<CleanedText_Comment=>} Id)

It didn't work

Not applicable
Author

Hi,

I am little bit confuse in 3rd step.

could you please specify.


Anonymous
Not applicable
Author

Capture.PNG

Capture.PNG

Just remove selection from comment field

isorinrusu
Partner - Creator III
Partner - Creator III

If I understood you well, what you have to do is to keep Ctrl button pressed while doing the 3rd step.

Try that.

Regards,

Sorin

Anonymous
Not applicable
Author

No, I don't need any manually step.

I select the comment and see many Id and all url

Anonymous
Not applicable
Author

In text object it works. I click on any comment and get all Id and url in text objects

=Concat( {< CleanedText_Comment= ,SessionId=P()>}Url, ',')

and

=concat({<CleanedText_Comment=, SessionId=P()>} Id,',')

I think I need to use a trigger onChange and onSelect

but I don't know how select my Id

isorinrusu
Partner - Creator III
Partner - Creator III

Vladimir, so what you want is the table to show all the comments associated to the ID of the selected comment?

Anonymous
Not applicable
Author

Capture.PNG

Select any comment and get all Id and url associated to this SessionId.

Anonymous
Not applicable
Author

Maybe aggr function ?