topic Re: Guage chart help in QlikView

Guage chart help

suryakant241187 — Fri, 17 Mar 2017 09:46:59 GMT

Hi,

I need percentage and numbers to be shown in gauge chart as per the attached file.

Please help.

Regards,

Suryakant

Re: Guage chart help

sarvesh — Fri, 17 Mar 2017 09:58:25 GMT

Please refer below mentioned link:

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Gauge_Chart.htm

Regard's

Sarvesh Srivastava

Re: Guage chart help

sarvesh — Fri, 17 Mar 2017 10:45:12 GMT

If your problem has been resolved then mark "Correct and Helpful" to close this thread.

Regard's

Sarvesh Srivastava

Re: Guage chart help

suryakant241187 — Fri, 17 Mar 2017 12:07:32 GMT

Hi,

I need the percentage on gauge chart and numbers in legend. can you please help with expression?

Regards,

Suryakant

Re: Guage chart help

sarvesh — Fri, 17 Mar 2017 12:13:15 GMT

Do you know why we use legend, it is use to define the colours.

Re: Guage chart help

suryakant241187 — Fri, 17 Mar 2017 13:34:45 GMT

Yep Correct... My requirement is that values will be on legend and the percentage will be on gauge chart.

Re: Guage chart help

suryakant241187 — Fri, 17 Mar 2017 14:36:20 GMT

Is there any solution?

Regards,

Suryakant

Re: Guage chart help

CarlosAMonroy — Fri, 17 Mar 2017 15:05:36 GMT

Hi Suryakant,

What I did to solve that requirement is:

Go to Expressions tab, copy and paste the expression you have. The trick is the properties of the second expression.

It should have checked the 'Relative' and 'Values on data points' options.

Then go to Presentation tab and check the box 'Show numbers in legend'.

Thanks,

Carlos M

Re: Guage chart help

sarvesh — Sat, 18 Mar 2017 05:18:20 GMT

Hi..Carlos,

Have you ever tried this.

Re: Guage chart help

Anonymous — Sat, 18 Mar 2017 08:06:26 GMT

For this requirement it's better to use pie chart instead of gauge

I did it by two pie chart, one of them calculate in percentage and another one has normal amount (949,21,104 ,0)

Re: Guage chart help

sarvesh — Sat, 18 Mar 2017 08:10:19 GMT

Thanks..Well done !!

Re: Guage chart help

suryakant241187 — Mon, 20 Mar 2017 10:16:12 GMT

Thanks a ton...!!! very helpful solution.

Re: Guage chart help

suryakant241187 — Mon, 20 Mar 2017 12:43:40 GMT

Hi Ramezani..

This is the exact answer which i was expected. just one query, I have applied same logic and created two piecharts. but when i reopening the file, the percentage piechart is hiding and the blank piechart is coming up at front side. which property i need to made changes for making percenatage pie chart at front side.

Regards,

Suryakant

Re: Guage chart help

CarlosAMonroy — Mon, 20 Mar 2017 12:49:40 GMT

Hi Sarvesh, You do not have to create 2 pie charts. The steps above are in a single pie chart. Sorry I did not specify before.

Thanks,

Carlos

Re: Guage chart help

Wed, 22 Mar 2017 08:11:32 GMT

Hi Suryakant,

Once you are done with creating 2 pie charts, you need to set their properties as shown in screenshot. Below is the procedure for the same.

1. Disable show legend property of pie chart in which you are displaying percentage by going to Dimension tab and enable Relative property in Expressions tab , also enable Values on data point property. Now go to Colors tab and set Transparency to 100%

2. For displaying numbers, enable Show legend property of another pie chart and set transparency to 100% in color tab for this pie chart also.

3.Now finally put one of the pie chart on another and set border width to 0 in layout tab of both the charts.

Regards,

Anurag

Re: Guage chart help

yoganantha321 — Wed, 22 Mar 2017 11:26:06 GMT

Hi Surya,

I think the below expression helps you,

=Round( Your expression *100)&'%'

Re: Guage chart help

sarvesh — Mon, 03 Apr 2017 11:58:39 GMT

Hi..

If your problem has been solved then mark this "Correct and Helpful" to close this thread.