topic Re: Guage charts overlap in QlikView

Guage charts overlap

Wed, 01 Jul 2015 11:38:10 GMT

Hi All

I have a stuck from here regarding gauge chart to show indicator for relevant year i not understood i would do.

fiscal_year is the dimension sum(revenue) is my measure any body try like which i am share screen shot and let me know immediately this for immediate requirement.

i will appreciate who ever given reputed answer or else similar to alternate in same gauge chart.

Re: Guage charts overlap

maxgro — Wed, 01 Jul 2015 17:44:42 GMT

if the problem is to have multiple needles for each gauges

Re: Multiple needles in gauge chart (tachometer)

gauge doesn't have dimension, only one expression

Re: Guage charts overlap

dgreenberg — Tue, 06 Oct 2015 15:20:01 GMT

You can however overlap mutliple gauges to show different years or use reference lines. If overlapping you would set the overlapping gauge to transparent.

Re: Guage charts overlap

Wed, 07 Oct 2015 13:05:30 GMT

Create 3 gauge charts for 3 years seperately (remember you can use the specific year in expressions as there is no dimension in gauge chart)

sum({<year='2010'>}revenue) - Use show scale, show needle, speedometer, define 2-3 segments for different colors, in colors tab give a different color (grey)

sum({<year='2011'>}revenue) - Uncheck "show scale", show needle, Hide segment boundaries, hide gauge outlines, in colors tab give a different color (dark blue)

sum({<year='2012'>}revenue) - Uncheck "show scale", show needle, Hide segment boundaries, hide gauge outlines, in colors tab give a different color (light blue)

Define layout in each chart like 5,10,15 for charts with year 2010, 2011, 2012 respectively

Now overlap the charts for 2011 and 2012 over 2010 after making proper layout .

For legends you have to create text box only for the desired year range and color box.

Hope that will help.