Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist II
Specialist II

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
Highlighted
Specialist II
Specialist II

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
Highlighted
Specialist II
Specialist II

how to select certain Id?

I tried

only({<CleanedText_Comment=>} Id)

It didn't work

Highlighted
Not applicable

Hi,

I am little bit confuse in 3rd step.

could you please specify.


Highlighted
Specialist II
Specialist II

Capture.PNG

Capture.PNG

Just remove selection from comment field

Highlighted
Partner
Partner

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

Highlighted
Specialist II
Specialist II

No, I don't need any manually step.

I select the comment and see many Id and all url

Highlighted
Specialist II
Specialist II

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

Highlighted
Partner
Partner

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

Highlighted
Specialist II
Specialist II

Capture.PNG

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

Highlighted
Specialist II
Specialist II

Maybe aggr function ?