topic Re: Gauge Chart Object in QlikView

Gauge Chart Object

Fri, 13 Jul 2012 07:58:46 GMT

I have created a Gauge object to show our convertion rate, however it dosent show the right numbers

I have tried doing the same calulation in a pivot, and it does the calcalation correctly

the expression is:

((SUM(first) * 100) / count(DISTINCT(user_id)))

first = first order (0 / 1 values)

Here is a few screenshots of the settings:

Also how do I add the value showed within the gauge to the object.

Re: Gauge Chart Object

jvitantonio — Fri, 13 Jul 2012 08:28:27 GMT

What value is showing? I'm sure is showing the right value but you need to work with the MAX value of the gauge and the different lower levels. Otherwise it would be useful to post your app or just create an example and post it here.

Re: Gauge Chart Object

Fri, 13 Jul 2012 08:35:28 GMT

But if it´s the same value, i don't understand why the pivot show the value of 10,58 and the gauge show the value of 45-50

Re: Gauge Chart Object

jvitantonio — Fri, 13 Jul 2012 08:51:44 GMT

I see that the "Lower Bound" says 0.5. I don't think that's right. You should work on those values...

Re: Gauge Chart Object

Mon, 16 Jul 2012 07:31:17 GMT

I solved the issue but removing the timedrill as the dimension

Thank you All!