Qlik Community

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 
Search instead for 
Did you mean: 
BouwerVa
Contributor II
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%

Capture.PNG

 

2 Replies
premvihari
Partner
Partner

use the attached
BouwerVa
Contributor II
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

Capture.PNG