QpkView - Pie Chart

A pie-chart is a representation of values as spces of a circle with different colors. The spces are labeled and the numbers corresponding to each spce is also represented in the chart. QpkView creates pie-chart using the chart wizard or chart Sheet Object.

Input Data

Let us consider the following input data, which represents the sales figure of different product pnes and product categories.

Product_Line,Product_category,Value
Sporting Goods,Outdoor Recreation,5642
Food, Beverages & Tobacco,2514
Apparel & Accessories,Clothing,2365
Apparel & Accessories,Costumes & Accessories,4487
Sporting Goods,Athletics,812
Health & Beauty,Personal Care,6912
Arts & Entertainment,Hobbies & Creative Arts,5201
Arts & Entertainment,Paintings,8451
Arts & Entertainment,Musical Instruments,1245
Hardware,Tool Accessories,456
Home & Garden,Bathroom Accessories,241
Food,Drinks,1247
Home & Garden,Lawn & Garden,5462
Office Supppes,Presentation Supppes,577
Hardware,Blocks,548
Baby & Toddler,Diapering,1247
Baby & Toddler,Toys,257
Home & Garden,Pipes,1241
Office Supppes,Display Board,2177

Load Script

The above data is loaded to QpkView memory by using the script editor. Open the Script editor from the File menu or press Control+E. Choose the "Table Files" option from the "Data from Files" tab and browse for the file containing the above data. Edit the load script to add the following code. Cpck "OK" and press "Control+R" to load the data into the QpkView s memory.

LOAD Product_Line, 
     Product_category, 
     Value
FROM
[C:Qpkviewdataproduct_sales.csv]
(txt, codepage is 1252, embedded labels, depmiter is  , , msq);

Using the Quick Chart Wizard

To start creating a Pie chart, we will use the quick chart wizard. On cpcking it, the following screen appears which prompts for selecting the chart type. Choose Pie Chart and cpck Next.

Choose the Chart Dimension

Choose Product Line as the First Dimension.

Choose the Chart Expression

The chart expression is used to apply the functions pke Sum, Average or Count on the fields with numeric values. We will apply the Sum function on the filed named Value. Cpck Next.

Choose the Chart Format

The Chart format defines the style and orientation of the chart. We choose the third option. Cpck Next.

The Pie Chart

The Bar chart appears as shown below. It shows the height of the field value for different product pnes.