topic Re: Text Box mouse hover show list of values in QlikView

Text Box mouse hover show list of values

agni_gold — Sun, 06 Mar 2016 17:04:01 GMT

Hi Team ,

I have requirement that , i have one text box and on mouse hover i want to show list of values on this , is that possible .

Please help.

Thanks

Re: Text Box mouse hover show list of values

jonathandienst — Sun, 06 Mar 2016 17:20:45 GMT

The mouse-over hover text for a a text box is defined in the entry "Help Text" on the Caption tab. You can enter an expression here, so use something like

=Concat(Distinct [MyField], ', ')

where MyField is the field to display. Adapt to your needs.

Re: Text Box mouse hover show list of values

agni_gold — Sun, 06 Mar 2016 19:23:55 GMT

Thanks but i need to show fields like list box , it this possible , right now values are coming by comma (,) , i want all values to next lines.

Re: Text Box mouse hover show list of values

agni_gold — Sun, 06 Mar 2016 19:28:12 GMT

could we make sorting on these name ?

Re: Text Box mouse hover show list of values

rubenmarin — Sun, 06 Mar 2016 19:46:08 GMT

Hi, you can try with

=Concat(DISTINCT ValueExpression, Chr(13),OrderExpression)

In example:

Contact(DISTINCT Country, Chr(13), Number_Id)

Re: Text Box mouse hover show list of values

avinashelite — Mon, 07 Mar 2016 06:02:08 GMT

yes , use the new line chr(13) with the concat function and increase your text size accordingly.. this should work