Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
BouwerVa
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

Capture.PNG

Labels (1)
1 Solution

Accepted Solutions
Partner
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

View solution in original post

1 Reply
Partner
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

View solution in original post