topic Pop up text for a straight table column in QlikView

Pop up text for a straight table column

dbaksa_1 — Tue, 06 Apr 2010 15:42:52 GMT

I hope there is a simple answer for this. I would like to display Pop up messages for a striaght table when a user hovers over a specific column. This Pop up message would contain information about the data in the column and how it is used.

Thanks in Advance,

Dan

Pop up text for a straight table column

Tue, 06 Apr 2010 15:47:16 GMT

Hi Dan

As far as I am aware there is no way to put pop-up text against a single column in a table, the only help text you can add is to describe the whole table (this is in the Help Text box in the caption tab).

Pop up text for a straight table column

dbaksa_1 — Tue, 06 Apr 2010 15:56:25 GMT

Thanks,

That is my understanding as well. I have a client who would like to add this feature if possible so I thought it was worth investigating.

Pop up text for a straight table column

johnw — Wed, 07 Apr 2010 01:34:36 GMT

See attached example of some options from from Rob Wunderlich's QlikView cookbook:

http://robwunderlich.com/Download.html

Pop up text for a straight table column

dbaksa_1 — Wed, 07 Apr 2010 16:55:54 GMT

I will take a look.

Thanks

Re: Pop up text for a straight table column

Anonymous — Tue, 06 May 2014 08:57:15 GMT

Hello,

If you add an expression like

='info: '&chr(10)&chr(10)&[Explanation]

and size the column to show only the "info:" part, when user hovers over that column, it will simply pop up the rest of the text (since it is the rest of the text that does not fit to the column).

Serhan

Re: Pop up text for a straight table column

feliciano_alan — Wed, 21 Jan 2015 18:38:40 GMT

This solution is very functional. Thanks

Re: Pop up text for a straight table column

rwunderlich — Wed, 21 Jan 2015 19:07:25 GMT

With QV11, you can also use the Dimension or Expression "Comment" field to add column hover popup text to straight tables.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Pop up text for a straight table column

brooksc57 — Thu, 04 Jun 2015 16:53:42 GMT

Looking for Field hover popup (whether it be text or image)...as we have been able to do in SSRS for many years...Ex. put part number in a column and then hover the description and/or an image. Hopefully Qlik sees this as a missing f(x) that is available in other pieces of software.

-Brooks

Re: Pop up text for a straight table column

rwunderlich — Thu, 04 Jun 2015 21:09:31 GMT

You can do it as explained here:

Cell Popups in Straight Table | Qlikview Cookbook

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Pop up text for a straight table column

brooksc57 — Fri, 05 Jun 2015 14:25:38 GMT

Thanks Rob,

Using aggr to avoid the filter is certainly nice when that is necessary.

Not super sure how to pass along ideas to Qlik directly...

It would still be great if Qlik would put this in the properties so that it could launch a real hover object than can be text or image or hyperlink or hyperlink auto-launches

Building this seemingly doable property object would really let us design some really cool stuff on really tight screen footprints.

My only thought that they have the shrunk cell popup and adding this would mess with that...but seemingly they could stack those objects or build in screen positioning for object hover.

--brooks

Re: Pop up text for a straight table column

Thu, 25 Jun 2015 04:59:34 GMT

Hi Rob. I tried using comment to get the popup on QV v11. It didn't work. My QV version is 11.20.12577. Any idea?

Re: Pop up text for a straight table column

rwunderlich — Thu, 25 Jun 2015 05:32:11 GMT

Cheng, Can you upload a sample QVW that shows the problem?

-Rob

Re: Pop up text for a straight table column

Thu, 25 Jun 2015 06:03:18 GMT

Hi Rob,

Thanks for the quick reply. Actually I found that the comment is for displaying when hovering on the column title, not on table cell. Is that correct?

And I tried your another solution on Cell Popups in Straight Table | Qlikview Cookbook. The solution works great at first, however, in this case, if user clicks on any value of that column (with concatenated popup text), this selected filter cannot be cleared using the clear button on the table. Any suggestion?

Re: Pop up text for a straight table column

rwunderlich — Fri, 26 Jun 2015 02:47:01 GMT

That's an interesting side effect I hadn't noticed before, but I never use the Clear icon. The only workaround I can think of is to replace the clear icon with your own button.

-Rob

Re: Pop up text for a straight table column

Mon, 06 Jul 2015 11:30:44 GMT

Hi Rob,

Your solution works perfectly fine for me, but just wanted to know whether the pop up will work when the dimension are in Cyclic Groups

Please help

Re: Pop up text for a straight table column

rwunderlich — Mon, 13 Jul 2015 18:56:21 GMT

‌Arjun,

DEfine the calculated dimension in the groups dialog using the "add expression" button.

-Rob

Re: Pop up text for a straight table column

kkkumar82 — Mon, 10 Aug 2015 09:16:43 GMT

Hi rob,

I tried the comment field in script and also in chart properties , these two are working for dimensions in both straight and pivot tables but I am not able to get them for the expressions.

PFA qvw file with some data.

Thanks

Kiran Kumar

Re: Pop up text for a straight table column

rwunderlich — Fri, 14 Aug 2015 01:11:19 GMT

For expressions. you must set the comment in the Comment property of the Expressions sheet. Field comments do not propagate through to expressions.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Pop up text for a straight table column

kkkumar82 — Fri, 14 Aug 2015 05:35:23 GMT

Forgot to post , actually I missed out the property on expressions tab, thanks Rob for coming back.

Thanks

Kiran Kumar