Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pop up labels in Block Charts

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.

3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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]))


talk is cheap, supply exceeds demand
Not applicable
Author

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.

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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,


talk is cheap, supply exceeds demand