Qlik Sense Advanced Authoring

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save \$400. Learn More
Highlighted
New 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 (1)
• Gauge chart Limits

1 Solution

Accepted Solutions Partner

Re: Gauge Chart Limits,Max & Min Problem

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

Re: Gauge Chart Limits,Max & Min Problem

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