Gauge chart

[Anonymous]

Friends,

I want a circular gauge chart showing KPI value and the actual value as shown in below screenshot,

But in this chart, month wise KPI values need to be shown. If I filter month and year, it has to change accordingly. Plz help..

[Anil_Babu_Samineni]

Is this you are expecting? Few setting required to show same Chart. Even sorting is running the Data point will changed

You can change below Setting with Sum(Sales) expression

And For Text of Number i've used this. Text in chart from Presentation Tab(For Ref, Check above image)

=Avg(Sales) & Chr(10) & Sum(Sales) & ' / ' & Count(Sales)

HTH, Change Accordingly as per your need

[dineshmdane]

Hi Shiva,

Kindly go through the below link which may be helpful for you.

Creating a Good Looking Gauge Chart in Qlikview

Regards,

Dinesh M

[gerrycastellino]

Try the attached: