Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
BouwerVa
New 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
Partner
Partner

Re: Setting Gauge Chart Min Based on Previous Year

use the attached
BouwerVa
New Contributor II

Re: Setting Gauge Chart Min Based on Previous Year

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