topic Creating Dual Indicator Gauge in QlikView

Creating Dual Indicator Gauge

Wed, 28 Mar 2012 14:11:59 GMT

I want to display a gauge with 2 indicators, 1 that is doing current year vs total last year, and one that is doing current year vs last year to date. I do not see any option for doing this, so to get it to work I created 2 gauges, 1 that has everything transparent except for the indicator, and the major tick marks (Have not found a way to make these transparent as well.)

This works well where I have the bottom gauge showing the CY vs LYTD scales and colors of the gauge and the CY vs LY total on top with the scale lined up.

My biggest issue besides these being different charts is that when last year to date is 0 then the bottom gauge displays No data to display and I lose all the color formatting and scale numbers. Another issue that I have seen is the bottom chart tends to lock at a certain value no matter what I select and I can only refresh it by copying it or closing the dashboard and re opening it.Also this makes it so that the user can not simply print the gauge as they will only print the top chart.

Does anyone know of a better way to display this? I know I can fix the last year to date by flipping the charts so Last year total is on the bottom, but I like how the formatting is for the current display.

Bottom Chart Null:

Both Charts Fine:

Creating Dual Indicator Gauge

pover — Wed, 28 Mar 2012 22:30:29 GMT

How about adding the last year amount as a reference line in the this year's gauge chart?

karl

Creating Dual Indicator Gauge

Thu, 29 Mar 2012 10:54:40 GMT

Both use this years amount:

Year to date is this year / last year to date

total is this year/ last year total

I Thought about using this, but A. I can not get a solid line like the above, it is smaller and slightly transparent. B. If the main expression is null and the reference is not null you lose both.

Creating Dual Indicator Gauge

SunilChauhan — Thu, 29 Mar 2012 11:27:24 GMT

you can add two gauge chart one over other

and make 2nd one as transparent

hope this helps

Creating Dual Indicator Gauge

Thu, 29 Mar 2012 11:28:39 GMT

If you read the original post that is was I am currently doing.

Creating Dual Indicator Gauge

pover — Thu, 29 Mar 2012 19:01:42 GMT

Not much you can do about the reference line format, but maybe you can fix disappearance because of the null value if you check for null and return 0 if it is null.

if(isnull(sum(...)/sum/(...)),0,sum(...)/sum(....))

Karl