# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

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

## Setting Gauge Chart Min Based on Previous Year

Hi All

I'm Stuck and need some help.

I created a Gauge KPI that sums our LG value. The Gauge is linked to a year month Filter and it works perfectly showing me the current selection's SUM(LG).

Problem: I would like to add a Min and Max Limit to the Gauge which is equal to

Min - SUM(LG) of the current selection - 1 Year

Max - SUM(LG) of the current selection - 1 Year + 30%

I did try before(sum(LG),-1) but it did not work.

In other word:

Blue = Last Year

Point = Current Year

Yellow = Last Year + 30%

2 Replies
Partner
use the attached
Contributor II
Author

Thank You for the reply but it still don't work.

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

Tags
Community Browser