33 articles in this selection
| 2011/10/18 QlikView blog round-up: If-statements, INLINE tables and EDX
Time to dust off a posting category that hasn’t been getting as much love as it should have; the QlikView blog round-up. Today I have for you three blog posts that I read recently and found very interesting: * What a big “If” you have * Nifty trick for INLINE tables * EDX in QlikView...
| |
|
|
|
|
| 2011/06/10 Not all QlikView variables are created equal
Starting an expression with or without an equals sign may almost seem like an arbitrary decision. Most developers quickly figure out that this is not true for text objects. However, there is another, less obvious area where the use of the equals sign can greatly impact how (and more importantly, when) your expression is calculated....
| |
|
|
| 2011/02/09 Merging tables in QlikView: how to use the JOIN prefix
This is the second post in a series on merging tables in QlikView. In the previous post I wrote about appending rows to tables by using the CONCATENATE prefix, this time I will show you how to add columns to a previously loaded table by using the JOIN prefix....
| |
|
|
| 2011/01/18 How to start learning QlikView
Lately I have been getting a lot of inquiries by people asking me how to get started with the Personal Edition of QlikView. It seems to be a very popular new year’s resolution this year, and one that is definitely a lot easier to keep than losing weight, getting fit or quitting smoking (hang in there everyone!). Rather than answering everyone individually, I am trying to take a more efficient approach by writing this post in which I lay out what I believe is a good path to get started with QlikView, without having to immediately draw your wallet to buy training....
| |
|
|
| 2010/12/28 Creating a custom sort order in QlikView: load order & dual
In a previous post I described how to create a custom sort order in QlikView by assigning a sort order value in the load script or by using the match function. This post describes two other clever methods that I recently became aware of.
| |
|
|
| 2010/12/17 Consistent dimension colors in QlikView
A short tip today on how to ensure that dimensions in different charts get assigned the same color, regardless of how the data is sorted or if dimensions are missing.
| |
|
|
| 2010/11/29 How to custom format table cells in QlikView
A short tip today about something that actually took me quite some time to figure out: how to easily format table cells. Where in Excel you can just right-click on a cell and choose “Format Cells”, that option seems to be missing in QlikView … or is it?...
| |
|
|
|
|
| 2010/10/18 Regular expressions in the load script
How to use VBScript Regular Expressions in QlikView's load script to provide additional validation, cleansing and extraction capabilities to QlikView.
| |
|
|
| 2010/10/10 Decile analysis
Decile analysis is a popular segmentation tool. Where a pareto analysis splits the top 20% customers (or products, regions, etc.) from the bottom 80%, decile analysis divides them into equally sized groups of 10%. Here's how to do it in QlikView.
| |
|
|
| 2010/10/10 The Qlik Fix!
A blog about QlikView tips, tricks and tutorials.
| |
|
|
|
|
| 2009/12/08 Leverage Statistical Control Limits
One factor that is not appreciated enough is that every metric that you report tends to have a natural "biorhythm", i.e. those metrics will fluctuate up or down and change due to "natural occurrences" that just happen (I can see some of you cringe! :)). These biorhythms are hard to understand, harder still to predict and since many of us live in the Puzzle world rather than the Mystery world we spin our cycle like crazy to understand the numbers to "explain" them to the management so that they can take some action. Imagine getting a daily / weekly trend and it goes up and down and you have no idea what the heck is causing it, even after you have done your damdest to isolate all the variables. The result of these natural biorhythms is that it causes Analysts and Marketers to do analysis and deep dive where none is necessary, it causes some of us to look "bad" because we can't explain the data, and it causes a lack of faith the the ability of data to provides insights....
| |
|
|
| 2009/12/02 9 Ways to Visualize Proportions
With all the visualization options out there, it can be hard to figure out what graph or chart suits your data best. This is a guide to make your decision easier for one particular type of data: proportions.
| |
|
|
| 2009/09/29 Wayne Eckerson's Five Steps to Self-service Nirvana
Despite its allure, self-service BI can cause overall BI usage to plummet, report backlogs to grow, query performance to diminish, and information inconsistency to increase. To avoid such unintended consequences, here are five ways to implement self-service BI properly....
| |
|
|
| 2009/09/25 PTS Blog
I've put together an extensive web site (http://peltiertech.com), which has an emphasis on working with Excel charts. Many of the tutorials and examples are techniques for achieving charting effects that, at first glance, seem impossible. I am active in Microsoft's newsgroups and in other online forums, such as Mr. Excel. I can be reached at jonxlmvp@peltiertech.com...
| |
|
|
|
|
|
|
| 2009/07/22 Sorting Text Alphabetically using Excel Formulas
Sorting text is such a day to day activity that it always surprises me why Excel hasn't provided a simple spreadsheet formula for doing it. Of course you can use the sorting menu command (menu > data > sort) but this requires manual steps (or VBA). Most of the times we get raw textual data from various sources and we need it to be sorted. While fooling with the COUNTIF() formula, I have realized a powerful yet little known feature that can be exploited to sort text using formulas....
| |
|
|
|
|
| 2009/07/17 COGNOiSe.com - the COGNOS community
COGNOiSe.com began life in July 2005 as a COGNOS technical forum but now boasts an ever-increasing arsenal of tools that encourage the effective use and development of the COGNOS product range.
| |
|
|
|
|
|
|
| 2009/07/16 Managing the Complexity of Content Management
Content management systems suck. Or so you would think from the strife heard from analysts and practitioners alike. And yet, many websites regularly publish vast amounts of information with superior control and ease compared to manually editing pages. So where's the disconnect between what’s possible and the too-often failure of CMS?...
| |
|
|
| 2009/07/16 Writing Your First VBA Function in Excel
Excel provides the user with a large collection of ready-made functions, more than enough to satisfy the average user. Many more can be added by installing the various add-ins that are available. Most calculations can be achieved with what is provided, but it isn't long before you find yourself wishing that there was a function that did a particular job, and you can't find anything suitable in the list. You need a UDF....
| |
|
|
| 2009/07/10 Excel VBA Performance Coding Best Practices
In this post I'm going to share with you the most important performance tips I know about. There are tons of sites, pages, and people who are experts as well on this subject, have performed their own tests, and shared their results and ideas. If you think I missed an important concept for how to optimize Excel VBA performance, or if you've got a valuable comment or link to share, please feel free to post here so everyone can benefit. Thanks!...
| |
|
|
| 2009/07/10 The Spreadsheet Page
Excellent list of Excel tips on formatting, formulas, charts and graphics, printing, VBA, command bars and menus, userforms and VBA functions.
| |
|
|
| 2009/07/08 A Pop-up Calendar for Excel
This tutorial shows you how to create a pop-up calendar using the Microsoft ActiveX Calendar Control that is installed with Excel. The user will be able to call up the calendar with a keyboard shortcut, from a toolbar button or menu, or from the right-click context menu. When the user selects a date it is automatically entered into the active cell on the worksheet....
| |
|
|
| 2009/06/29 Wikipatterns
Wikipatterns.com is a toolbox of patterns & anti-patterns, and a guide to the stages of wiki adoption. It's also a wiki, which means you can help build the information based on your experiences! Beyond this site, there are many other additional resources....
| |
|
|
| 2009/06/23 Top 10 tips to make better use of business intelligence
Business intelligence is getting a lot of attention amid the economic downturn as organisations try to use data they gather to become more efficient and compete more effectively with rivals. With this in mind, silicon.com has picked the brains of analysts specialising in BI to come up with some top tips about how you can make the most out of this growing area....
| |
|
|
| 2009/06/21 Microstrategy Blog
Blog with unofficial tips, tricks and information about Microstrategy.
| |
|
|
| 2008/05/02 BOB: BusinessObjects Board
The purpose of this forum is to provide a free and open discussion area for people to ask questions, provide answers, and share experiences with the products offered by Business Objects SA. This is not the official Business Objects technical support site....
| |
|
|