Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

vovan4ik
Valued Contributor 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
vovan4ik
Valued Contributor II

Re: Please with table

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)

11 Replies
vovan4ik
Valued Contributor II

Re: Please with table

how to select certain Id?

I tried

only({<CleanedText_Comment=>} Id)

It didn't work

Not applicable

Re: Please with table

Hi,

I am little bit confuse in 3rd step.

could you please specify.


vovan4ik
Valued Contributor II

Re: Please with table

Capture.PNG

Capture.PNG

Just remove selection from comment field

Partner
Partner

Re: Please with table

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

vovan4ik
Valued Contributor II

Re: Please with table

No, I don't need any manually step.

I select the comment and see many Id and all url

vovan4ik
Valued Contributor II

Re: Please with table

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

Partner
Partner

Re: Please with table

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

vovan4ik
Valued Contributor II

Re: Please with table

Capture.PNG

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

vovan4ik
Valued Contributor II

Re: Please with table

Maybe aggr function ?