Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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?

Community Browser