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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
abc_18
Creator II
Creator II

Heat map values not displaying properly upon hover

Hello everyone,

I am using a heat map for visualization, where Market share represents the size and Market share growth defines the color (written expression in colors and legend).

But upon hover, market share growth values are not properly visible (highlighted in blue), after one/two digits it showing as ...., please suggest how can i display full value with "%" symbol.

 

Heat map.png

Regards

Labels (1)
5 Replies
MMS118
Partner - Contributor
Partner - Contributor

Hi

Can you share the expression you added to "colors and legend"?

abc_18
Creator II
Creator II
Author

Hi,

Below is the expression I am using:-

num(

(sum({<fYear={'$(vCurYear)'},FYear=>}sales)
/
sum(total{<fYear={'$(vCurYear)'},FYear=,company_name=>}sales))*100

-

(sum({<fYear={'$(vPrevYear)'},FYear=>}sales)
/
sum(total{<fYear={'$(vPrevYear)'},FYear=,company_name=>}sales))*100


,'#%')

 

Expression name is "Market share growth"

MMS118
Partner - Contributor
Partner - Contributor

A couple of thoughts:

1. You said the expression name is Market share growth, yet the name in the picture you attached is Mkt Share Gwth. Are there 2 expressions or did you change the name only?

2. Can you try this instead:

num(

(

(sum({<fYear={'$(vCurYear)'},FYear=>}sales)
/
sum(total{<fYear={'$(vCurYear)'},FYear=,company_name=>}sales))

-

(sum({<fYear={'$(vPrevYear)'},FYear=>}sales)
/
sum(total{<fYear={'$(vPrevYear)'},FYear=,company_name=>}sales))

)*100

,'##.##%')

Please let me know if it works or not.

abc_18
Creator II
Creator II
Author

Hi,

The name is same, it's "Mkt Share Gwth" only.

The above expression also giving same result, number is not visible after one digit.

Regards

MMS118
Partner - Contributor
Partner - Contributor

Can you share your .qvf file so I can take a better look?