topic Re: Gauge Chart Compare Years in QlikView

Gauge Chart Compare Years

Anonymous — Fri, 27 Feb 2015 12:31:46 GMT

Hi,

How can i create a gauge chart that shows how much % electricity that is saved (oldest selected year vs latest selected year)

Info:

In my table I have data for the consumption of electricity hourly. Dimensions name: kWh

Re: Gauge Chart Compare Years

datanibbler — Fri, 27 Feb 2015 12:50:49 GMT

Hi Marius,

you need the total consumption per year - then you can build some expression (possibly using set_analysis) to grab the value for the 1st and last year in the selected range and calculate the % difference between those.

How exactly is that done? Does the user select on two separate fields?

=> Once you have one single value, you can display it in a gauge chart.

HTH

Best regards,

DataNibbler

Re: Gauge Chart Compare Years

Gysbert_Wassenaar — Fri, 27 Feb 2015 12:52:01 GMT

num(1-sum({<Year={"$(=max(Year))"}>}kWh)/sum({<Year={"$(=min(Year))"}>}kWh),'#.0%')

Re: Gauge Chart Compare Years

Anonymous — Fri, 27 Feb 2015 13:04:18 GMT

Thanks!

Think that expression was correct, but the colors in the graph shows 50/50 green gray...