topic Re: Pop up labels in Block Charts in QlikView

Pop up labels in Block Charts

Thu, 10 Oct 2013 05:42:08 GMT

Hi,

I have a block chart in my application and I want to display all the dimension and expression values on mouse hover. By default, the labels are displayed only for dimension and first expression. (In the attached file, labels are being displayed only for Country (dimension) and Current (First Expression). The values of the other two expressions are displayed without their labels.

I do not want to concatenate the label in my expression. - Is there any other way of achieving this?

I am also attaching a sample QV file for reference.

Re: Pop up labels in Block Charts

Gysbert_Wassenaar — Thu, 10 Oct 2013 06:03:17 GMT

As far as I know the only way is to create the popup text in the first expression and disabling Text as Popup for the other expressions:

dual('Country: ' & Country

& chr(10) & 'Current: ' & sum([Current Year Factor])

& chr(10) & 'Previous: ' & sum([Previous Year Factor])

& chr(10) & '% Increase: ' & num( (sum([Current Year Factor]) - sum([Previous Year Factor]))/sum([Previous Year Factor]),'#.0%')

,sum([Current Year Factor]))

Re: Pop up labels in Block Charts

Thu, 10 Oct 2013 06:15:27 GMT

Hi,

The main reason why wanted to avoid concatenating the labels in the expression was that while exporting to excel, I want all the expression fields to display numeric value only.

If we use dual, the first expression will not be a numeric field and it will contain all the labels & expression values.

Re: Pop up labels in Block Charts

Gysbert_Wassenaar — Thu, 10 Oct 2013 06:18:49 GMT

Add another expression with only the numeric value of the first expression: sum([Current Year Factor]). In Excel can then delete the first expression column,