topic Re: Please with table in QlikView

Please with table

Anonymous — Tue, 16 Dec 2014 17:14:26 GMT

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,

Re: Please with table

Anonymous — Tue, 16 Dec 2014 18:48:17 GMT

how to select certain Id?

I tried

only({<CleanedText_Comment=>} Id)

It didn't work

Re: Please with table

Tue, 16 Dec 2014 18:51:49 GMT

Hi,

I am little bit confuse in 3rd step.

could you please specify.

Re: Please with table

Anonymous — Tue, 16 Dec 2014 18:55:51 GMT

Just remove selection from comment field

Re: Please with table

isorinrusu — Tue, 16 Dec 2014 18:56:39 GMT

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

Re: Please with table

Anonymous — Tue, 16 Dec 2014 18:58:27 GMT

No, I don't need any manually step.

I select the comment and see many Id and all url

Re: Please with table

Anonymous — Tue, 16 Dec 2014 19:05:07 GMT

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

Re: Please with table

isorinrusu — Tue, 16 Dec 2014 19:06:09 GMT

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

Re: Please with table

Anonymous — Tue, 16 Dec 2014 19:14:20 GMT

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

Re: Please with table

Anonymous — Tue, 16 Dec 2014 19:17:16 GMT

Maybe aggr function ?

Re: Please with table

Anonymous — Tue, 16 Dec 2014 20:02:01 GMT

Is possible ignore selection in dimension level?

Re: Please with table

Anonymous — Tue, 16 Dec 2014 20:36:35 GMT

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)