关键词：
QlikView 学习资料
一封QlikView的演讲稿
QlikView Script - 进阶篇1Script调用Macro 之变化
QlikView Script 基础教程1- 注解
QlikView Script 基础教程2- MapSubString（）使用
QlikView Script 基础教程3- 组合件处理
http://blog.itpub.net/10158957/
· Applications are missing a dashboard summaryoverview tab, which gives the users a quick summary of the current state of thebusiness.
o Recommendation: Look into implementing the DAR methodologyfor your applications. We suggest creating an application that is made up ofthree different parts: Dashboard page – which gives an overview of thebusiness, an Analytical page – which gives the users interactive KPI’s to dotheir analysis, and a Reporting page – which provides the user detail databehind the analytics. Further description on this methodology can be found at: http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/08/dar-methodology
· Inconsistent layout between the threeapplications. The CBA dashboard has a different layout from the Secured Financeand Sources and Users dashboards.
o Recommendation: Create a template QVW of all the colors andlayout you want your dashboards to consist of. To leverage your existing data models, use the binary load function toload the data into your template.
· Lack of linked objects.
o Recommendation: Usethe linked objects features to maintain common objects look and feel betweensheets. This eases maintenance. When oneobject is updated, the rest of the linked objects will get updated as well.
· Gradient backgrounds and slanted dimensionlabels can hinder the readability of the dashboard.
o Recommendation: Use asolid background, and if there’s space try to avoid using slanted dimensionlabels.
· Coloring all text within a chart columncounteracts the intent of highlighting the important values.
o Recommendation: Use asingle color to highlight only the values that are important for the user tofocus on.
· Avoid using filters on the top and right pane ofthe dashboards
o Recommendation: Havingyour filters on the top pane of your dashboard uses valuable chart real estate. In addition, having your filters on the rightpane may not be visible to users where their monitor resolution does not fitthe entire dashboard. Like web pages and software applications,keep your filters on the left side to adhere to that mainstream userexperience. http://community.qlik.com/blogs/qlikviewdesignblog/2013/04/25/left-or-right-side-navigation
· Use of Pie Chart when there are many dimensionvalues.
o Recommendation: Ratherthan using a Pie chart, consider using a sorted bar chart to highlight the highperformers.
· Ensure the correct chart is used when selectingthe type of analysis.
o Recommendation: First determine the type analysis you wouldlike the chart to portray. Generallythere are four different types: Comparison, Relationship, Distribution, andComposition. Below are examples of the differentcharts to consider for each type:
§ Comparison– Bar Chart, Radar Chart
§ Relationship– Scatter Chart
§ Distribution – LineChart
§ Composition– Stacked Chart, Pie Chart
Below is a chart thatfurther explains the thought process when selecting a visualization:
For further details on the topic: http://www.qlik.com/us/blog/posts/patrik-lundblad/dissecting-how-to-choose-the-right-chart
· As you adopt an Ajax implementation, high numberof objects per a sheet creates delays in Ajax rendering.
o Recommendation: Limitthe number of objects per a sheet. Textboxes used as borders or UI should be made part of an image to be used as thesheet backgrounds. Doing so will reduceindividual objects that need to render on their own.
o Recommendation: In result of separating objects, you willend up with a document with many sheets. To manage this, look into using these methods to maintain them:Container Objects, Sub Tabular, Pick List, or a combination of the three. Further details to how to implement thesesheet maintenance methods can be found here: http://community.qlik.com/docs/DOC-4379
· Look into using Comparative Analysis for yourcharts:
o Recommendation: Byusing Alternate State and Set Analysis, you can build dynamic group comparisonswithin your charts. Below is an example from our FinancialStock Analysis Demo. As you can see from the chart below, the user candynamically choose which stocks he wants compare against in the Group A vs GroupB Comparison. Having this flexibility,the user can go through different scenarios within his Business Discoverysession. More details can found here: http://community.qlik.com/docs/DOC-3837
有没有办法使用 R 读取 Qlikview 数据对象并执行统计操作并将结果返回给 Qlikview？
】有没有办法使用R读取Qlikview数据对象并执行统计操作并将结果返回给Qlikview？【英文标题】：IsthereawaytoreadQlikviewdataobjectusingRandperformanstatisticaloperationandreturnresultstoQlikview?【发布时间】：2013-11-2709:43:40【问题描述】：我们正在尝... 查看详情
Microsoft 商业智能平台与 QlikView
】Microsoft商业智能平台与QlikView【英文标题】：MicrosoftbusinessintelligenceplatformvsQlikView【发布时间】：2012-05-2203:25:59【问题描述】：我完全没有使用QlikView的经验，但我读过关于它的好评。根据Gartner2012年研究报告，QlikView与微软、... 查看详情
如何使用 QlikView 加载 RData 文件？
】如何使用QlikView加载RData文件？【英文标题】：HowtoloadanRDatafilewithQlikView?【发布时间】：2013-05-2004:33:39【问题描述】：有人知道使用QlikView加载RData文件吗？我想这样做的原因是我在R中有一个大型数据集，我想用QlikView进行交互... 查看详情
Web 浏览器中的 QlikView 应用程序。如何？
】Web浏览器中的QlikView应用程序。如何？【英文标题】：QlikViewapplicationinwebbrowser.How?【发布时间】：2012-11-2310:23:22【问题描述】：我对QlikView很陌生。我创建了一个测试QlikView应用程序。我想知道，是否可以在网络浏览器中访问该... 查看详情
在 Qlikview 中循环和限定加载
】在Qlikview中循环和限定加载【英文标题】：LoopingandQualifyloadinQlikview【发布时间】：2014-05-2512:30:08【问题描述】：我想在qlikview中创建两个表；一个叫车站，一个叫火车。我曾计划应用QUALIFY语句，这样两个表之间的任何匹配字段... 查看详情
QlikView - 使用变量来设置分析表达式
】QlikView-使用变量来设置分析表达式【英文标题】：QlikView-Useavariableintosetanalysisexpression【发布时间】：2014-03-2301:12:16【问题描述】：我有变量varCurrentYearvarCurrentYear=Year(Today())我写了这个集合分析表达式结果不正确。顺便说一下... 查看详情
qlikview中的rowno()函数
函数介绍RowNo()返回当前行的行号，在QlikView载入后的数据表中。第一行的值是1。使用注意：此函数没有參数。可是括号不能省略。适用范围，能够用于Load脚本，也能够用于Chart的表达式。实例脚本样例：SETThousandSep=',';... 查看详情
如何从 QlikView 连接到 Databricks Delta 表？
】如何从QlikView连接到DatabricksDelta表？【英文标题】：HowtoconnecttoDatabricksDeltatablesfromQlikView?【发布时间】：2019-09-2611:34:28【问题描述】：我需要使用databricksDeltaLakes中的数据创建QlikViewDashboard。有没有人尝试使用从QlikView仪表板连... 查看详情
事实表中的多个字段引用一维 Qlikview
】事实表中的多个字段引用一维Qlikview【英文标题】：MultiplefieldsinfacttablereferringtoonedimensionQlikview【发布时间】：2017-10-1121:35:38【问题描述】：我是Qlikview的新手。我有一个包含CheckinDate和CheckoutDate字段的事实表Fact_Transaction。我有... 查看详情
qlikview基础设置及初步了解
改变语言环境 开发工具条勾选出来创建selectionbox创建searchbox编辑脚本重加载数据基本联动思路：tableview tableview 查看详情
使用批处理文件在 QlikView 中导入文本文件或压缩文件
】使用批处理文件在QlikView中导入文本文件或压缩文件【英文标题】：ImportingtextfilesorcompressedfilesinQlikViewusingabatchfile【发布时间】：2014-09-0123:34:37【问题描述】：我在一个文件夹中有多个文本文件。我需要每天将这些文件导入Qlik... 查看详情
将版本控制系统与 QlikView 一起使用
】将版本控制系统与QlikView一起使用【英文标题】：UsingversioncontrolsystemswithQlikView【发布时间】：2016-07-2915:04:52【问题描述】：我是QlikView的新手，想使用一些版本控制系统（例如Git）来跟踪更改。但我不确定如何执行此操作，因... 查看详情
在 Qlikview 中加载脚本期间创建变量
】在Qlikview中加载脚本期间创建变量【英文标题】：CreatingvariableduringloadscriptinQlikview【发布时间】：2014-10-2006:00:49【问题描述】：我正在尝试使用以前加载的表在我的加载脚本中设置一个变量，例如：Data:load*inline[Year,Store,Revenue20... 查看详情
qlikview 文件是不是存储有关文档作者和修改者的任何线索？
】qlikview文件是不是存储有关文档作者和修改者的任何线索？【英文标题】：Doesqlikviewfilestoreanytrailabouttheauthorandmodifierofdocument?qlikview文件是否存储有关文档作者和修改者的任何线索？【发布时间】：2016-09-1511:24:37【问题描述】：... 查看详情
Qlikview：如何创建汇总表以过滤多个关联表
】Qlikview：如何创建汇总表以过滤多个关联表【英文标题】：Qlikview:howtocreatesummarytabletofiltermultipleassociatedtables【发布时间】：2015-09-2800:00:22【问题描述】：每个ID有4-5个单行和多行表。我想生成一个汇总表，列出每个ID以及各种... 查看详情
在 qlikview 中，是不是可以保持脚本窗口始终打开？
】在qlikview中，是不是可以保持脚本窗口始终打开？【英文标题】：Inqlikview,Isitpossibletokeepthescriptwindowalwaysopen?在qlikview中，是否可以保持脚本窗口始终打开？【发布时间】：2020-05-1502:06:59【问题描述】：在代码开发过程中，如果... 查看详情
QlikView 如何在其他表格中按属性分组
】QlikView如何在其他表格中按属性分组【英文标题】：QlikViewHowtogroupbyattributeinothertable【发布时间】：2018-05-0820:46:38【问题描述】：您好，我目前有2个这样的表：具有idParcel,quantityParcel,idProduct的包裹和具有idProduct、nameProduct的产... 查看详情
Qlikview 滚动 12 个月财政
】Qlikview滚动12个月财政【英文标题】：QlikviewRolling12MonthFiscal【发布时间】：2012-06-1510:01:59【问题描述】：这个论坛似乎更适合更多编程问题，但如果有人会查看以下链接中的逻辑问题，我会很感兴趣。我的问题是如何使用已经... 查看详情