Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jhlovenc
Not applicable

Show extended text only when there is a single selection

I have a single table with several thousand rows.  One of the columns is "Short_Description" and another is "Extended_Description"

Since the extended description can be several sentences long, I would like to display it in a text box, but only if a single record in the table has been selected. If there are no, or multiple, selections, it should be blank.

As I am scrolling my chart with short descriptions, I should be able to click on a particular record and get the extended description in anothe robject.

1 Solution

Accepted Solutions
jhlovenc
Not applicable

Re: Show extended text only when there is a single selection

Thnaks Rob.  I think that will work also.  Now I wish I could figure out how my reply to my post got posted 12 times...I kept getting an error saying it was unabe to post but apparently it was able!

11 Replies
jhlovenc
Not applicable

Re: Show extended text only when there is a single selection

Never mind - I was able to adapt from another post.  Thanks!

Text Box

=If(getSelectedCount([Short_Description])=1 andIsNotNull(Extended_Description])0,Extended_Description,0)

jhlovenc
Not applicable

Re: Show extended text only when there is a single selection

Never mind - I was able to adapt from another post.  Thanks!

Text Box

=If(getSelectedCount([Short_Description])=1 andIsNotNull(Extended_Description])0,Extended_Description,0)

jhlovenc
Not applicable

Re: Show extended text only when there is a single selection

Never mind - I was able to adapt from another post.  Thanks!

Text Box

=If(getSelectedCount([Short_Description])=1 andIsNotNull(Extended_Description])0,Extended_Description,0)

jhlovenc
Not applicable

Re: Show extended text only when there is a single selection

Never mind - I was able to adapt from another post.  Thanks!

  Text Box

=If(getSelectedCount([Short_Description])=1 andIsNotNull(Extended_Description])0,Extended_Description,0)

jhlovenc
Not applicable

Re: Show extended text only when there is a single selection

Never mind - I was able to adapt from another post.  Thanks!

  Text Box

=If(getSelectedCount([Short_Description])=1 andIsNotNull(Extended_Description])0,Extended_Description,0)

jhlovenc
Not applicable

Re: Show extended text only when there is a single selection

Never mind - I was able to adapt from another post.  Thanks!

Text Box =If(getSelectedCount([Short_Description])=1 andIsNotNull(Extended_Description])0,Extended_Description,0)

jhlovenc
Not applicable

Re: Show extended text only when there is a single selection

Never mind - I was able to adapt from another post.  Thanks!

Text Box =If(getSelectedCount([Short_Description])=1 andIsNotNull(Extended_Description])0,Extended_Description,0)

rwunderlich
Not applicable

Re: Show extended text only when there is a single selection

In the Layout pane of your extended description object, check "Show Conditional" and enter this expression:

=GetPossibleCount(Short_Description)=1

-Rob

http://robwunderlich.com

jhlovenc
Not applicable

Re: Show extended text only when there is a single selection

Never mind - I was able to adapt from another post.  Thanks!

Text Box

=If(getSelectedCount([Short_Description])=1 andIsNotNull(Extended_Description])0,Extended_Description,0)