# App Development

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Contributor II

## Gauge Chart Limits,Max & Min Problem

Hi I'm trying to set my gauge limit to the previous year's total. But my gauge is connected to Year Filter.

In other word when I select 2019. The pointer must be 2019 total. The limit must be 2018 total and max must be 2018 + 30%. But my Pointer and Limit keeps giving me the same value.

Here is my Formula's:

Point : sum(if(TTYPE = 'Lo', CAPITAL))/1000000

Min: 0

Max : (sum({<Year={\$(=max(Year)-1)},TTYPE={"Lo"}>}CAPITAL)*1.3)/1000000

Limit: sum({<Year={\$(=max(Year)-1)},TTYPE={"Lo"}>}CAPITAL)/1000000

Results: The Limit and Point still gives the same value

Labels (2)

• ### Gauge chart Limits

1 Solution

Accepted Solutions
Partner

hi

the field you are making the selections is FIN_YEAR

as you are not referencing him in your expression your expression doesn't work

maybe something like :

sum({<FIN_YEAR={\$(=max(FIN_YEAR)-1)},TTYPE={"Lo"}>}CAPITAL)*1.3)/1000000

or

sum({<FIN_YEAR=,Year={\$(=max(Year)-1)},TTYPE={"Lo"}>}CAPITAL)*1.3)/1000000

Partner

hi

the field you are making the selections is FIN_YEAR

as you are not referencing him in your expression your expression doesn't work

maybe something like :

sum({<FIN_YEAR={\$(=max(FIN_YEAR)-1)},TTYPE={"Lo"}>}CAPITAL)*1.3)/1000000

or

sum({<FIN_YEAR=,Year={\$(=max(Year)-1)},TTYPE={"Lo"}>}CAPITAL)*1.3)/1000000

Tags
Community Browser