Hi! welcome to my channel Qlikview
This is Satheesh.
We are going to learn Pie chart and Gauge
chart today
So one of the drawback in using pie chart
is we cannot change the angel of the starting
position of the value (I mean angle is degree)
but it can be done in Gauge chart.
Drawback in Gauge chart is we cannot use the
legend.
You can see the legend highlighted here Region,
Region number (example: Region 9) and all.
This Legend cannot be displayed in the Gauge
chart.
And you can see, If you mouse over the pie
chart we can see the values as well as legend
name but in gauge chart it is not possible
to display the exact value like this according
to each segment, okay.
Actually i have disabled the popup value.
Let us see how to change this Pie chart into
Gauge chart.
Before we starting to create a Gauge chart
let us see what are the dimensions we used
in the Pie chart.
We used region, it has the data from Region
1 to Region 20.
In the Dimension Limit i have chosen only
first 5 largest values and restricted the
values.
In the Expression column i have use Amount*Price
as Sales.
And we sorted out the value bye using the
descending order in Y-axis.
That's all the parameters, dimension and expression
used in the Pie chart.
To create the Gauge chart let me copy this
pie chart and paste it.
It will form a new chart.
So i have copied and pasted it.
Right click this chart and go to properties
and then got to General tab and choose Gauge
chart and then click Apply.
So Now you can see the difference in change
in the chart pattern.
And in the dimension we do not want to use
the dimension at all in the gauge chart.
Let us remove the Region dimension and in
the expression we can use the sum of ... it
can be as it is and then in the style we have
to choose the first type it has a needle and
outer layer.
Go to the presentation tab and select the
Mode.
And in Mode select Fill to Value and select
the Speedometer style as it is.
And uncheck Show Scale and AutoWidth segment.
This Autowidth Segment if you uncheck it there
is a partial/equally divided space it will
reduce according to the value which you select
in the segment.
You can see the segment here predefined value
is zero and the second segment value is 0.5
so it is equally divided.
So if you uncheck the AutoWidth segment.
Let us uncheck and Apply it.
And also you can see the popup label here,
it is already checked (Click Apply).
Now we can see the difference, We chosen the
Fill to Value so the value is filled.
And the needle is not use here and so needle
disappeared and scale disappeared .
There is a option called Angle Span here it
is 270 degree.
If you make it as 360 degree you will get
a round circle chart like Pie/Donut Chart
like this
Let me change it to 360 degree and Apply.
So now you can see the circle pie chart and
it is completely Filled.
And now where do you want to start the Central
Angle degree.
For example: by default it is zero.
This zero means it will start at 6'O Clock.
If you wan to change it some other degree
like 90 degree and then click Apply.
So you can see here it will start at 9'O Clock.
90 degree seems start at 9'O Clock.
If you change it to 180 degree it will start
at 12'O Clock.
Let me change it to default value Zero so
the value start here from 6'O Clock.
Next we are going
to workout on
the Segments Setup.
