Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Regards
Hi
Can you share the expression you added to "colors and legend"?
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"
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.
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
Can you share your .qvf file so I can take a better look?