topic Re: display informtion when hovering over croostab expression in QlikView

display informtion when hovering over croostab expression

curiousfellow — Wed, 15 Apr 2015 09:27:01 GMT

I created a crosstab reporting average numbers. I would like to show additional information when hoovering over a number . For example the number of respondents to a survey.

Can not find an option like that. Is it possible ?

Re: display informtion when hovering over croostab expression

awhitfield — Wed, 15 Apr 2015 09:31:55 GMT

Hi Curious,

you can use text popup, see the attached example where it's used on a bar chart.

Andy

Re: display informtion when hovering over croostab expression

curiousfellow — Wed, 15 Apr 2015 09:38:11 GMT

I did find that option for a chart, but there is not such option fot a crosstab

Re: display informtion when hovering over croostab expression

awhitfield — Wed, 15 Apr 2015 09:51:08 GMT

What do you actually mean by a CrossTab?

Andy

Re: display informtion when hovering over croostab expression

awhitfield — Wed, 15 Apr 2015 09:57:40 GMT

I presume you mean a pivot table, you can't do it by hovering over one of the 'normal values' , but if you convert the supplied example, to a pivot, you can see that you get an extra POP column, that you may be able to utilise.

Andy

Re: display informtion when hovering over croostab expression

stigchel — Wed, 15 Apr 2015 10:00:41 GMT

I use the total row of the table for that with a condition in the expression you can specify a different calculation e.g. something like

if(Rowno()=0 and Dimensionality()=0,'n='&Count(ID),YourExpression)

An other option is to add the n= expression to the label of the expression you are using, so it is showing in the header.

(Next to adding new columns with an extra expression offcourse)

Re: display informtion when hovering over croostab expression

curiousfellow — Wed, 15 Apr 2015 10:22:20 GMT

Sorry I mean a Pivot Table. I try to avoid extra columns and the "hoover value" has to be presented and calculated for every "normal value"

@Andrew, which supplied example are you reffering to ?

Re: display informtion when hovering over croostab expression

awhitfield — Wed, 15 Apr 2015 10:24:09 GMT

There's a qvw attached to my original reply

Re: display informtion when hovering over croostab expression

stigchel — Wed, 15 Apr 2015 11:15:22 GMT

No you can't without the extra columns (no hoover). Using my option it would like something like this

N.B. Werk je voor een marktonderzoekbureau?

Re: display informtion when hovering over croostab expression

ali_hijazi — Wed, 15 Apr 2015 11:18:31 GMT

add the desired text to the comment of each expression:

Re: display informtion when hovering over croostab expression

awhitfield — Wed, 15 Apr 2015 11:28:42 GMT

Doesn't this only work against the expression heading / label, and not cell values?

Andy

Re: display informtion when hovering over croostab expression

ali_hijazi — Wed, 15 Apr 2015 11:33:18 GMT

ah yes only for expression header label

Re: display informtion when hovering over croostab expression

curiousfellow — Wed, 15 Apr 2015 11:36:26 GMT

Ik werk niet voor een marktonderzoekbureau.. Het gaat hier echter wel over een enquete.

Re: display informtion when hovering over croostab expression

curiousfellow — Wed, 15 Apr 2015 19:44:18 GMT

I am afraid that I have to conclude that it is not possible.

Thanks to all for your answers