topic Re: additional expressions viewing in tooltip in QlikView

additional expressions viewing in tooltip

Thu, 14 May 2015 10:09:37 GMT

How to incorporate additional expressions for viewing in tooltip? I have one dimesion defined which will show the value in percentage , but i want the numerical value to be shown in tooltips. Also , I want to show the total count value in the tooltip.

Re: additional expressions viewing in tooltip

Thu, 14 May 2015 11:10:27 GMT

you have this feature in qlikview. please see the screen shot. this is available for dimensions and expressions.

I hope this helps

Re: additional expressions viewing in tooltip

mohammadkhatimi — Thu, 14 May 2015 11:17:01 GMT

Hie...

Goto Properties>>Caption>>Help Text>>write expression in that....

Regards,

Mohammad

Re: additional expressions viewing in tooltip

Thu, 14 May 2015 11:22:47 GMT

Thanks for your inputs, I am very new to qlikview and I apologize if I have not framed my question correctly.

I need to add additional information in a tooltip of pie chart , I have attached image of pie chart . You can see i have a study status ="Analysis" and corresponding percentage of such cases = 15.74%. I want a functionality so that number value is also displayed in tooltip as well totul number of values across all types of study.

Re: additional expressions viewing in tooltip

Thu, 14 May 2015 11:45:48 GMT

go to the Pie chart properties

Go to expressions

create a copy of the expression that you are showing in percentage

I believe you are showing the percentage by changing the number format.

Change the number format for the new expression to your desired format

append any text you want to appear in the tooltip example: you expression for the new field should be like

'Value= ' & sum(yourfield)

tick the Text as popup text option on the expression page

untick Expression as a legend

make sure that all the other expression have the Text as popup option is unticked

this I think would do it.

Re: additional expressions viewing in tooltip

petter — Thu, 14 May 2015 11:46:33 GMT

You can add additional expressions in your chart and tick on the check-box at

the bottom of the Expression tab to Text As Popup.

Then you will get the text from this expression in addition to what is already in the ToolTip (Popup).

Tip: you can have longer texts combined with expressions here to form multiple lines of information. You can separate each line with Chr(10) which is Carriage Return (new line) ...

If you want to get rid of the already displayed standard tooltips and only have the additional expression in the tooltip

then you will have to go to the Presentation Tab and uncheck the check-box for Pop-up Labels

Re: additional expressions viewing in tooltip

Thu, 14 May 2015 11:59:27 GMT

Thanks a lot guys ... it was very helpful and easy to understand.