Linear guage chart labeling...

[Anonymous]

Hi all,

I have two coloumns with FY Goal and Performance to FY Goal. I want to represent the status of performance with respect to FY Goal in a linear guage chart with lableling their respective values.

I have attached the sample images also.

Can anyone please help me?

For example

The needle point at where they stand now, red color bar % changes every month (for example assuming FY goal is $100 then as of YTD April, they should have reached $100/12*4 = 33.33%, if YTD April the seller only reach 30% of FY goal, they are not on par and therefore showing as below.

Please also show the actual % as well

[Anil_Babu_Samineni]

Would you able to provide sample application which demonstrates the issue

[Anonymous]

Hi Anil Babu,

Sure,I want to label at the needle point and at the segment 2 separation.

This is what I am able to do max for labeling.

But my requirement is this.

[Anonymous]

Hi Anil Babu,

Sure,I want to label at the needle point and at the segment 2 separation.

This is what I am able to do max for labeling.

But my requirement is this.

[Anil_Babu_Samineni]

Can you upload mock up application, That would better offer

[shanky1907]

You can use two segments in the Linear Gauge chart.

Like

If your FY YTD Yield<30%, the color can be red, FY YTD Yield>30%<FY YTD Goal, the color can be ample or orange & FY Goal > FY YTD Goal, will be green.

[shanky1907]

Use these links to create your own kind:

Creating a Good Looking Gauge Chart in Qlikview