topic Re: Straight Table chart with linear gauge chart in QlikView

Straight Table chart with linear gauge chart

Fri, 02 Dec 2011 08:18:25 GMT

Hi,

I have attached qvw which has bar chart in straight table chart.

I want to use linear gauge chart instead of bar for the same field.

Need your help on this as unable to show linear gauge chart.

Thanks,

Re: Straight Table chart with linear gauge chart

jagan — Fri, 02 Dec 2011 12:36:28 GMT

Hi,

Hope this helps you.

Pls check the attachment.

Regards,

Jagan.

Re: Straight Table chart with linear gauge chart

Fri, 02 Dec 2011 13:40:17 GMT

Thanks Jagan for reply.

chart should be look similar to attached picture.

Attaching the existing qvw file.

Can somebody please help me on this.

Thanks,

Straight Table chart with linear gauge chart

jagan — Fri, 02 Dec 2011 13:48:28 GMT

Missed the attachment.

Regards,

Jagan.

Straight Table chart with linear gauge chart

Fri, 02 Dec 2011 14:11:55 GMT

Not allowing to attach the file.

It is similar to the posted in original post.

Re: Straight Table chart with linear gauge chart

jagan — Fri, 02 Dec 2011 14:24:38 GMT

Check this.

Min and Max values and colors in Gauge Settings section in Expresion tab.

Regards,

Jagan.

Re: Straight Table chart with linear gauge chart

Fri, 02 Dec 2011 14:34:15 GMT

Gauge should be displayed as per the value.

For eg 14 should be the smallest gauge, 342 a bit bigger and similarly.

Re: Straight Table chart with linear gauge chart

jagan — Fri, 02 Dec 2011 14:51:43 GMT

Check this!

Regards,

Jagan.

Re: Straight Table chart with linear gauge chart

Mon, 05 Dec 2011 10:05:18 GMT

Thanks Jagan for your efforts.

For some of the values this is now shown like if you check for 14 it is not displaying.

Do you know what can be the issue.

Thanks in advance.

Re: Straight Table chart with linear gauge chart

Mon, 05 Dec 2011 10:12:35 GMT

Hi Mansi,

Your Last and second last value is not shown as they have very less value in respect to other rows Value.

Its is the part of Qlikview Feature.

Regards,

Nitin Jain

Re: Straight Table chart with linear gauge chart

jagan — Mon, 05 Dec 2011 10:17:05 GMT

Hi,

Because 14 is very small value when compared to 7287, that's why it is not visible. If you increase the width of the Linear gauge column you can view that.

Regards,

Jagan.

Re: Straight Table chart with linear gauge chart

quiquehm — Mon, 25 Feb 2013 18:56:36 GMT

Hi Jagan,

I am trying to do exactly the same that you show in your printscreen, but I would need to add some colour coding to the bars. My data is normalized to percentages, so I simply need to color code the bars on 3 different colors : Green from 0 to 90% , Yellow from 91% to 100% and Red for % higher than 100%.

I am trying to apply some nested if statements for this ( as it seems the color of the bar allows a calculated condition ), but for whatever reason it does not work.

See below screen clips...any idea of what could be rong here ?

Gauge properties : you can see here the color button for the Lower Bound has an f(x) label ( indicating a calculated condition is setup in the background )

Clicking on the color button :

Then, this is the nested if statement in the expression :

Unfortunately these are workarounds to overcome the limitation of Qlikview not having bullet charts out of the box , or not being able for example to display a thinner bar inside a wider bar , kind of a temp meter display for my setup above ( rather than showing 2 bars side by side )

Any ideas are appreciated.

Thanks

Enrique

Re: Straight Table chart with linear gauge chart

Wed, 07 May 2014 14:52:41 GMT

Hi Jagan Mohan,

I like the linear gauge presentation in the qvw you have posted. I am trying to recreate the linear gauge style with the pipes in the background and a smaller green bars. Could you please tell me how you were able to get that style?

Re: Straight Table chart with linear gauge chart

jagan — Thu, 08 May 2014 02:09:13 GMT

Hi Shruti,

Check this screenshot

Regards,

Jagan.

Re: Re: Straight Table chart with linear gauge chart

Thu, 08 May 2014 04:13:41 GMT

Thank you so much for the screenshot Jagan!

But I have tried to do exactly like you have in your qvw file, and still can't get the pipes behind the bars.

Please find attached the screenshot and the qvw file itself. The first chart is your chart and the second one is what I am trying to recreate.

Appreciate your help.

Re: Re: Re: Straight Table chart with linear gauge chart

Thu, 08 May 2014 04:25:58 GMT

Hi Shruthi ,

Uncheck the Show Scale and Show labels on Every ..

Pls refer screenshot

Re: Re: Re: Re: Straight Table chart with linear gauge chart

Thu, 08 May 2014 04:35:39 GMT

Thanks Senthil,

I have tried both checking and unchecking them They are just the same .. Please find the qvw file attached and the screenshot.

Please let me know if you are able to recreate the same style in the second chart.

Re: Re: Re: Re: Re: Straight Table chart with linear gauge chart

jagan — Thu, 08 May 2014 09:42:47 GMT

Hi,

I Created the same chart with the settings attached in screenshot. Please find attached file with new chart.

Regards,

Jagan.

Re: Straight Table chart with linear gauge chart

Thu, 08 May 2014 15:37:13 GMT

Thanks Jagan and Senthil,

I finally got the anser to this and it worked when I increased the Text size to 140% under "Custom Format Cell". You would get to Custom Format cell by right clicking on that Column of the chart. The lines will go away as soon as you make the text size 100%

Please find attached the screenshot.

Re: Straight Table chart with linear gauge chart

quiquehm — Sat, 07 Mar 2015 22:31:12 GMT

does anybody know why the calculated base color expression on the gauge does not work ? its color should change based on the nested if statement ( grenn, yellow, red ).

thanks !!