16 Replies Latest reply: Apr 3, 2017 7:58 AM by Sarvesh Srivastava

# Guage chart help

Hi,

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

Regards,

Suryakant

• ###### Re: Guage chart help

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

Regard's

Sarvesh Srivastava

• ###### Re: Guage chart help

Hi,

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

Regards,

Suryakant

• ###### Re: Guage chart help

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

• ###### Re: Guage chart help

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

• ###### Re: Guage chart help

Is there any solution?

Regards,

Suryakant

• ###### Re: Guage chart help

Regard's

Sarvesh Srivastava

• ###### Re: Guage chart help

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

Hi..Carlos,

Have you ever tried this.

• ###### Re: Guage chart help

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

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

Thanks..Well done !!

• ###### Re: Guage chart help

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

• ###### Re: Guage chart help

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

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

Hi..