Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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]))
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.
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,