Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problems with showing the right value in a gauge chart

Hello,

Im using an Gauge chart with three expressions and having some question about it.

It contains the following expressions:

 

Percentage (expr 2 / expr 3) :
Totaaldagenziek / Totaaldagengewerkt

 

Totaaldagenziek (The total number of sick dayes per year of all employees):
SUM(YEARSICKTIME)

 

Totaaldagengewerkt: (Total working days a year of all employees. The hours working in a week * the 52 weeks in a year / the 8 hours a working day stands for. And this minus the hours of in a yeark / the 8 hours a working day stands for)
SUM(URENWERKTIJD) *52 / 8 - SUM(VERLOFAFGEBOEKT) / 8

The result is showing as an percentage. But here is the problem, when i put my mouse at the point of the result it show all three values of the three expressions in the pop up. I want to let him only show the value of the first expression (the point is directing to the right value in the chart btw). I tried to make an textbox with '=Totaaldagenziek / Totaaldagengewerkt' to show the percentage value, but that won't work.

Someone any ideas?

0 Replies