Qlikview 简明教程

QlikView - Straight Tables

直表是 QlikView 中使用最广泛的图层对象，用于显示数据。它们非常简单但功能强大，具有重新排列列、排序和给背景着色等功能。

Straight Tables are most widely used sheet object to display data in QlikView. They are very simple yet powerful with features like column rearrangement, sorting and coloring the background etc.

Input Data

让我们考虑以下输入数据，它表示不同产品线和产品类别的销售数字。

Let us consider the following input data, which represents the sales figure of different product lines 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 Supplies,Presentation Supplies,577
Hardware,Blocks,548
Baby & Toddler,Diapering,1247
Baby & Toddler,Toys,257
Home & Garden,Pipes,1241
Office Supplies,Display Board,2177

Load Script

以上数据已使用脚本编辑器加载到 QlikView 内存中。从“文件”菜单中打开脚本编辑器，或按 Control+E 。从“文件中的数据”选项卡中选择“表文件”选项，并浏览包含以上数据的文件。将出现以下屏幕。

The above data is loaded to the QlikView 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. The following screen appears.

单击“确定”，并按 “Control+R” 将数据加载到 QlikView 的内存中

Click "OK" and press "Control+R" to load the data into the QlikView’s memory

Create Table Box

接下来，我们创建一个类型为表框的新工作表对象。我们按以下所示菜单操作。

Next, we create a new sheet Object of type Table Box. We follow the menu as shown below.

Select the Columns

QlikView 提示选择要包含在最终表框中显示的列。我们选择所有列，并使用 Promote or Demote 选项来设置列的顺序。

QlikView prompts for the columns to be chosen which will be displayed in the final Table Box. We choose all the columns and use the Promote or Demote option to set the order of the columns.

Select Display Style

接下来，我们选择 style（样式）选项卡，为显示数据指定特定的背景色。当前样式选项列出许多预构建的样式。我们为每两行选择 Pyjama Red 和 Stripes 。

Next, we choose the style tab to give specific background colors to the display data. The current style option lists many pre-built styles. We choose Pyjama Red with Stripes every two rows.

Column Re-ordering

通过按住鼠标按键在列标题上然后将其拖动到所需位置，我们可以重新排列列的位置。

We can reorder the positions of the columns by pressing and holding the mouse button at the column headers and then dragging it to the desired position.