topic Re: Gauge meter boundaries in QlikView

Gauge meter boundaries

Fri, 02 Mar 2012 06:30:20 GMT

Hi!

I have a gauge meter for "Claims". I would like the meter to be coloured red from our Target level and upwards. Say for example I have currently 8 claims (which the needle is showing) but I'd like the red colouring to start at 10 claims, thereby showing we are currently green with a slight margin until the red area starts.

I've tried by putting Segment 2 with a lower bound of 10 but the gauge meter is not accepting this, instead the whole scale of the meter (1-50) is showing green.

Any ideas on how to fix this?

Thanks in advance and Krgds,

Lennart

Gauge meter boundaries

jagan — Fri, 02 Mar 2012 07:05:44 GMT

Hi,

Can you attach the sample, it helps in arriving the solution.

Regards,

Jagan.

Re: Gauge meter boundaries

sridhar240784 — Fri, 02 Mar 2012 07:13:57 GMT

Hi,

Check attached application.

-Sridhar

Re: Gauge meter boundaries

Fri, 02 Mar 2012 07:14:57 GMT

Hi Jagan,

Below is a snapshot of my Gauge meter…hope that helps you. I would like the red coloring of the meter to start at either a defined number (e.g. 10 Escapes) or if possible, to have it linked to an expression which picks up the Year-to-date Target. This would then show the audience where the threshold is in terms of being above Target, which in this case is bad and hence “red”.

Any support or suggestions would be most welcome!

Thanks and Krgds,

Lennart

Re: Gauge meter boundaries

Fri, 02 Mar 2012 07:17:22 GMT

Hi Sridhar,

I’m afraid I cannot open the application since I’m currently running on the free version I downloaded from Qliktech’s webpage. I’m building an application to present to management to persuade them to invest in real licenses at the moment.

Any chance of you describing what you managed to do? Or insert a picture?

Thanks and Krgds,

Lennart

Re: Gauge meter boundaries

jagan — Fri, 02 Mar 2012 07:21:19 GMT

Hi,

Can you attach the qlikview file.

Regards,

Jagan.

Re: Gauge meter boundaries

sridhar240784 — Fri, 02 Mar 2012 07:25:00 GMT

Hi,

Hope i understood your Question.

Your Gauge Setting for Min is 0 and Max is 50.

Your Segment 1 --> Lower Bound should start with 0.00 and the color of this is Green.

Your Segment 2 --> Lower Bound Should start with 10 and Color should be Red.

So when your expression returs <= 10 then meter show with in Green area and anything more then 10 would be in red.

Hope i`m clear. Please find the attached image.

-Sridhar

Re: Gauge meter boundaries

Fri, 02 Mar 2012 07:28:10 GMT

Hi Jagan,

I’m afraid I cannot do that since I’m currently running on the free version downloaded from Qliktech’s webpage. I’m building this application to present to management to persuade them to invest in Qlikview licenses.

Thanks and Krgds,

Lennart

Re: Gauge meter boundaries

Fri, 02 Mar 2012 07:31:47 GMT

Hi Sridhar,

You have captured it absolutely correctly….and I’ve done the settings exactly as you have shown in your picture. But my Gauge meter is still only showing the whole scale in green.

Thanks and Krgds,

Lennart

Re: Gauge meter boundaries

sridhar240784 — Fri, 02 Mar 2012 07:36:37 GMT

Ok, last check Is your Gauge Min and Max setting is 0 to 50 or 0 to .5 ? it should be 0 to 50 else you need to change your lower boud of the Segment 2 to .1?

By the way what Jagan was trying to say is, you may not be able to open the document but we have a licensed version of QlikView. So if you could post your sample document, we`ll be able to open and check the application and give you the solution.

Hope i`m clear.

Edit : If you are not able to post the application. Please post the screen shot of the Presentation tab settings and your expressions.

-Sridhar

Re: Gauge meter boundaries

Fri, 02 Mar 2012 08:12:02 GMT

Hi Sridhar,

Not able to upload my application but I have attached some pictures of my expression and presentation tab.

Thanks again for your kind support!

Krgds,

Lennart

Re: Gauge meter boundaries

sridhar240784 — Fri, 02 Mar 2012 08:16:22 GMT

Please also share the Gauge Settings which is next to segment settings. Look at the attched image.

-Sridhar

Re: Gauge meter boundaries

jagan — Fri, 02 Mar 2012 08:20:22 GMT

Hi,

Everything you did correct, check Min and Max values as suggested by Sridhar.

Regards,

Jagan.

Re: Gauge meter boundaries

Fri, 02 Mar 2012 08:20:26 GMT

OK, please find below. Gauge settings are the same for both Segments (1 & 2).

Thanks again and Krgds,

Lennart

Re: Gauge meter boundaries

Fri, 02 Mar 2012 08:23:27 GMT

OK, thanks. Min & Max values are set at 0 & 50 for both Segments yet I still don’t get the colouring of red from 10 onwards….strange.

Re: Gauge meter boundaries

jagan — Fri, 02 Mar 2012 08:25:20 GMT

Hi,

Try creating the same in another new object and remove the existing.

Regards,

Jagan.

Re: Gauge meter boundaries

Fri, 02 Mar 2012 09:16:19 GMT

Still doesn’t work….

Re: Gauge meter boundaries

jagan — Fri, 02 Mar 2012 09:19:25 GMT

Hi,

If possible attach file with some sample data. I will check it. It works fine in our file.

Regards,

Jagan.

Re: Gauge meter boundaries

Fri, 02 Mar 2012 09:23:31 GMT

Hi again Jagan,

Attached is a sample of my data….thanks again for your support, really appreciate it.

Krgds,

Lennart

Re: Gauge meter boundaries

jagan — Fri, 02 Mar 2012 09:34:03 GMT

Hi.

Please find the attached image. It works fine in my file.

Regards,

Jagan.