Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pacoli2013
Creator
Creator

Kein Pies but Gauges

Hello,

I'm still designing my Dashboard.

I have two Options (see attachment gauges):

1) a straight table with mini-gauges built in

2) a straight table plus a trellisbox with gauges

Option 1 saves space but the gauges don't show the right values, the gauges in the trellisbox give the right values.

Both options have the same Dimension and the formula are also the same: 

if (Sum(BudgetAmount) > 0, Sum(ActualAmount) /Sum(BudgetAmount), 0)

The settings for the segments  are also equal:

Segment 1: startposition 0.0

Segment 2: startposition 1.0

Min value: 0

Max value: 1.2

Hope someone can tell my why in option 1 the gauges have a problem with displaying the right values. And how to solve it (if there is a solution)

Thanks in regards

Court

1 Reply
marcus_sommer

Please provide a small example which also showed which results do you expect. Beside them you could simplify your expression to: alt(Sum(ActualAmount) /Sum(BudgetAmount), 0).

- Marcus