没有合适的资源?快使用搜索试试~ 我知道了~
首页qlikview9.0开发手册
qlikview9.0开发手册
4星 · 超过85%的资源 需积分: 19 46 下载量 67 浏览量
更新于2023-03-03
评论
收藏 3.59MB PDF 举报
这是针对qlikview初学者的开发手册, 对于想了解这个BI工具的开发人员具有非常好的指导意义
资源详情
资源评论
资源推荐
Developer I
May 2009 Release
QlikView Version 9.00, English
Copyright © 2009 QlikTech International AB, Sweden
Under international copyright laws, neither the documentation nor the software may be cop-
ied, photocopied, reproduced, translated or reduced to any electronic medium or machine-
readable form, in whole or in part, without the prior written permission of QlikTech Interna-
tional AB, except in the manner described in the software agreement.
QlikTech® and QlikView® are registered trademarks of QlikTech International AB.
Microsoft, MS-DOS, Windows, Windows NT, Windows 2000 Windows XP, Windows Vista,
SQL Server, FoxPro, Excel, Access, ActiveX, the Internet Explorer logo, and MS Query are
trademarks of Microsoft Corporation.
IBM, AS/400 and PowerPC are trademarks of International Business Machines Corporation.
Borland, Paradox and dBASE are trademarks of Borland International.
ORACLE and SQL*Net are trademarks of Oracle Corporation.
Apple, TimeType, Macintosh, PowerMacintosh and MacOS are trademarks of Apple Com-
puter, Inc.
Original release: May 2009
i
QlikView Developer I |
CONTENT
1 INTRODUCTION 1
Target Audience 1
What You Will Learn in this Course 1
QlikTech 2
Who is QlikTech? 2
Course Logistics 2
Notes 4
2 QLIKVIEW ENVIRONMENT 7
QlikView Desktop 7
3 QLIKVIEW DEVELOPMENT METHODOLOGY 11
Import/Export Sheet and Document Layouts as XML 11
Qlik Wholesale Trade (QWT) Project Plan 11
Project Plan Review 11
SAFE Methodology 12
4DEPLOYMENT 15
QlikView Standalone 15
QlikView Server 16
QlikView Publisher 17
5 INTRODUCTION TO DATA AND SCRIPTING 19
Relational Databases 19
Other Data Structures 20
Comparing Database Structures to QlikView Data Structures 22
Data Structures in QlikView 23
Data Source Files 24
The QWT Primary Data Source 24
The QWT Secondary Data Files 24
Introduction to Scripting 25
6 CONNECTING TO ODBC/OLEDB DATA SOURCES 37
ii
QlikView Developer I |
CONTENT
Syntax 37
7 CREATING THE SCRIPT 45
Script Generation 45
Reading Tables into QlikView 45
Script Debugging 53
8 STRUCTURING THE SCRIPT 59
Creating Tabs in the Script 59
9 BASIC DATA CLEANSING 67
Load Statement 67
Renaming a Field 68
Script Expressions 69
Loading an XML File 70
Renaming Fields Using the Qualify Statement 73
Key Fields 76
Example Predicament 76
How Does this Affect You? 76
Loading a Field into a Table Multiple Times 77
Using a Record Counter on Key Fields 77
Is it Correct? 78
Time Functions: Creating a Calendar 80
Getting the Highest and Lowest Date from the Orders Table 80
Creating Variables in the Script 82
The Master Calendar 85
10BASIC DATA MODEL AND TABLE VIEWER 89
The Table Viewer 89
The System Table 94
Document Properties: Tables page 96
11SCRIPTING CONSIDERATIONS 97
Synthetic Key Tables 99
iii
QlikView Developer I |
CONTENT
Circular References 102
Causes of Circular References 102
Loosely Coupled Tables 105
Check the Numbers 105
12QLIKVIEW DATA (QVD) FILES 109
QVD File Format 109
Use of QVD Files 109
Creating QVD Files 110
Manual Creation of a QVD File in the Script 110
Automatic Creation of a QVD File in the Script 115
QVD File Script Functions 117
13LAYOUT BASICS FOR DEVELOPERS 119
User Friendly Design 119
Natural Human Behavior 120
Chart and Object Choices in QlikView 121
Import/Export Sheet and Document Layouts 130
14REPORTING BUGS IN QLIKVIEW 133
15ADDITIONAL INFORMATION 137
Reference Materials 137
Data types in QlikView 137
剩余147页未读,继续阅读
wclluck
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- RTL8188FU-Linux-v5.7.4.2-36687.20200602.tar(20765).gz
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论5