topic Re: Question about Gauges in QlikView

Question about Gauges

Thu, 17 Jul 2014 15:12:25 GMT

Hey all,

I just have quick question on the gauge object. I have a list of items associated with the gauge, and it works correctly when only one of those items, in that list, is selected. When two or more (or none at all) are selected, the dial shows the first (or last if I choose the option from the sort menu) item value in that list. I want it to show the average of all the items' values, not just one. Is this possible? If this is not possible, is there a way to not display the needle at all when no item is selected? Thanks in advance for your help.

Re: Question about Gauges

Thu, 17 Jul 2014 15:15:00 GMT

Could you share a sample qvw? What kind of expression are you using?

Re: Question about Gauges

Thu, 17 Jul 2014 15:24:49 GMT

So the data I am using to power the guage is in two parts. If this were a bar chart, the first part would be the x-axis value and the second part would be the y-axis value. The first part is the name of an object, and the second part is the value describing that object.

For the gauge, I have the first part (x-axis) as the only dimension, under the dimension tab. The second part (y-axis) is listed as an expression, under the expression tab, with the expression looking like: =avg(value).

I do not have a example document to share, but I would gladly make one, if my above description does not clear things up.

Side Note: If I check the box on the General Tab "Show Title In Chart" and I do not select a title, it shows the correct value that I am looking for, which is the average of the values. When an item is selected, it shows what the gauge shows, which is the correct value for that object.

Re: Question about Gauges

nilo_pontes — Thu, 17 Jul 2014 15:26:22 GMT

Hi Askash,

You are probably missing something on your formula.

It is possible to do both things you have asked.

The first one, aggregating in the right way and the second utilizing systems functions like 'GetCurrentSelections'.

Please, share a sample like Robert said.

Regards,

Nilo

Re: Question about Gauges

Thu, 17 Jul 2014 15:28:09 GMT

yeah sharing a qvw would definitely clear things up a lot more than that haha

Re: Re: Question about Gauges

Thu, 17 Jul 2014 17:21:16 GMT

Ok, I have made a sample Qlikview Document here. I want the gauge to show the average of all the objects listed when nothing is selected, or two or more are selected. Instead it defaults to the first object (that is selected, if any).

Re: Question about Gauges

nilo_pontes — Thu, 17 Jul 2014 20:59:34 GMT

Hi Aakash,

Gauge objects doesn't need dimensions.

Just remove it from your chart and you will get the right value.

Regards.