Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Different scales on guages in guage chart?

Hi,

I have a straight table chart with an expression presented as a linear guage. The expression is an amount of sales against target (I'm using a variable to hold the expression, $(vAmountOfSalesAgainstTarget) ), which is evaluated as a number: 1 meaning sales equals targets, 0.9 means sales is 90% of target, 1.1 means 110% of target. The dimension is Department.

I want the maximum value for each guage in each row to be either 1, or the sales against target for that department, whichever is greatest.

I am getting this to work using

NumMax(Max(Aggr($(vSalesAmountAgainstTarget), [Department])), 1)


However, this sets the same maximum value for all guages in the table, so they all end up having the same scale. I want each guage to have their own maximum. Is this possible?

Thanks, I hope I have made myself clear!

1 Solution

Accepted Solutions
MVP
MVP

Different scales on guages in guage chart?

The Min, Max, and the size of all the segments are fixed in a Gauge that's included in a Straight Table. You should pre-calculate the max. for all the departments and use that as your consistent Max.

3 Replies
MVP
MVP

Different scales on guages in guage chart?

The Min, Max, and the size of all the segments are fixed in a Gauge that's included in a Straight Table. You should pre-calculate the max. for all the departments and use that as your consistent Max.

Not applicable

Different scales on guages in guage chart?

That's a shame, I think it would be nice to have a dynamic max for each guage in a chart. Maybe this will be considered as a new feature for the next version.

Thanks for your input anyway!

derekjones
Contributor II

Different scales on guages in guage chart?

FYI, I've just stumbled across the same issue and I'm using version 10. So no new feature yet I'm afraid Smiley Surprised(

Community Browser