Business Intelligence

/Business Intelligence

QlikView Keyboard Shortcuts

2018-07-03T14:09:30-04:00

SkillForge SkillSheet QlikView Keyboard Shortcuts Click here to download the PDF version.   File Menu Command Shortcuts Press… For… Ctrl+N Equivalent to New on the File menu. Ctrl+O Equivalent to Open... on the File menu. Ctrl+Shift+O Equivalent to Open in Server... on the File menu. Ctrl+S Equivalent to Save on the File menu. F12 Equivalent to Save As... on the File menu. Ctrl+P Equivalent to Print... on the File menu. Ctrl+Shift+P Equivalent to Print As PDF... on the File menu. Ctrl+E Equivalent to Edit Script... on the File menu. Ctrl+R Equivalent to Reload on the File menu. Ctrl+Shift+R Equivalent to Partial Reload [...]

QlikView Keyboard Shortcuts2018-07-03T14:09:30-04:00

Tableau Training Classes from SkillForge

2018-03-20T18:43:50-04:00

Announcing Our New Tableau Training Classes Companies around the world are collecting more data than ever - about their customers, their sales and many other aspects of their business. With all of this data, though, the problem becomes how to analyze, make sense of it - and more importantly - make sound business decisions based on it. Business Intelligence tools have increased in popularity in the last few years to help companies do just that. One of the tools that is particularly popular currently is Tableau. Tableau offers five products currently: Tableau Desktop (both Personal and Professional Editions), Tableau Server, Tableau [...]

Tableau Training Classes from SkillForge2018-03-20T18:43:50-04:00

Creating the Speedometer Gauge in QlikView

2017-11-26T22:32:01-04:00

QlikView, one of the big BI (business intelligence) programs you can get today, has a number of graphical ways to display data, which it calls charts. Among these, one of the coolest (sorry, but it is) would have to be the Gauge chart. And of the subtypes in that group, the speedometer style is probably one of the easiest to understand. For quantities, percentages, and a couple of other kinds of numbers, it’s very straightforward. Setting it up takes a little work, but it’s worth it for readability. Once you’ve got your data ready (the scenario we use is an analysis [...]

Creating the Speedometer Gauge in QlikView2017-11-26T22:32:01-04:00

Using Qlikview’s Date Functions

2016-09-28T23:54:54-04:00

When putting together a data model for a Qlikview application you will occasionally run into a field that is not formatted properly, both from a numeric and presentational perspective. Behold the transformed junk file that Qlikview organized into meaningful data. Meaningful yes, recognizable by the end user…not so much. Don’t get me wrong, it all works as you can see from this example. Selecting a date will match up with the Plant #, Production Line ID, and Estimated Production, but the average user doesn’t what to stare at the date value and disassemble so they can mentally reassemble it as a [...]

Using Qlikview’s Date Functions2016-09-28T23:54:54-04:00

Qlikview Chart Styling Using Expression Attributes

2016-09-28T00:01:27-04:00

Qlikview makes it quick and easy to assemble your data into a professional BI application. But sometimes the information needs a little boost, that extra touch that makes the difference. One way to accomplish this is using Expression Attributes. These attributes can be found on the Expression tab of your chart object. Let’s take a look at a couple of examples. The line chart in the first image serves its purpose but might benefit from a style change. By right-clicking on the chart we can enter the objects properties window. Selecting the Expressions tab allows us to see the expressions that have [...]

Qlikview Chart Styling Using Expression Attributes2016-09-28T00:01:27-04:00

Crystal Reports Performance Information Tool

2016-05-31T23:48:28-04:00

After designing a report Crystal Reports provides a built-in utility that will allow you to test performance and shine a light on areas where optimization would be beneficial. It is called the Performance Information tool and can be found by selecting Report > Performance Information in the menu. Once opened, the Performance Information dialog box has a tree structure on the left side that provides five sets of information captured by the tool. Report Definition – Information about the reports content: number of fields, number of summaries, Chart objects, Special Fields, etc. Saved Data – Data captured in the report: number [...]

Crystal Reports Performance Information Tool2016-05-31T23:48:28-04:00

Making “Can Grow” a Global Setting in Crystal Reports

2016-05-24T15:54:52-04:00

There are a lot of different setting we talk about during our Crystal Reports classes. Much of the information we end up displaying within these reports consists of text, and in our quest to make it fit we end up making constant adjustments to width and height. That is, until we are introduced to the string format option can grow. With one simple format setting we eliminate the need to make those height adjustments. Here is what we are talking about. Our example will use a simple group heading to identify the country of origin. It looks like this in print preview. We [...]

Making “Can Grow” a Global Setting in Crystal Reports2016-05-24T15:54:52-04:00

Code Hinting in Crystal Reports Formula Workshop

2016-05-23T11:33:56-04:00

When using Crystal Reports, formulas play a large role in preforming such basic tasks as conditional formatting, selecting records, and general calculations. The code window for all of these tasks is called the Formula Workshop. It is a centralized window divided into five sections; Workshop tree, Field Tree, Function Tree, Operator Tree, and Definition area. Normally when you want to create a basic calculation formula such as taking one database field and multiplying it by another database field you will expand your connection object within the Field Tree so you can see all of your available tables. Clicking the plus sign [...]

Code Hinting in Crystal Reports Formula Workshop2016-05-23T11:33:56-04:00

QlikView Quick Suggestions: Moving a Comma for Quick Editing

2016-04-27T18:18:18-04:00

Here is a simple and very straight forward suggestion when working in QlikView’s Script Editor. When you are loading data from any source and your LOAD statement has a list of fields that you may want to shorten at some point; consider this simple suggestion. The comma that divides the field values is found ate the end of the field name. Consider moving the comma to the beginning of the next line and remove it from the end of the previous line. Now if you find it necessary to remove a field or two or more from your table; just comment [...]

QlikView Quick Suggestions: Moving a Comma for Quick Editing2016-04-27T18:18:18-04:00

QlikView–Moving the “Unmovable” Object

2016-02-06T08:29:31-04:00

QlikView is without a doubt one of my most favorite programs to teach.  The capabilities for modeling and visualizing data are just amazing.  But for all of QlikView’s shine and wonder, it’s not without its shortcomings.  I really shouldn’t say “shortcomings”, but there are a few areas that could use a bit of improvement.  Take, for instance, moving objects around the report space. Normally, an object possesses a title bar (or “caption”, as QlikView likes to call it) and you can simply click and hold the caption bar and move the object.  The problem arises when a designer hides the caption [...]

QlikView–Moving the “Unmovable” Object2016-02-06T08:29:31-04:00

QlikView – Suppress Splash Screen

2016-01-28T22:26:07-04:00

We spend so much time trying to make things run as quickly and efficiently as possible, but sometimes we just can’t help ourselves when it comes to self-promotion. QlikView loves making things go fast; starting QlikView is another story. As if we were unaware that we had elected to launch QlikView, a several second “commercial” in the form of a splash screen has to tell us that we are one of the lucky ones. As much as I enjoy using QlikView, I find the startup splash screen to be a bit of a nuisance. The good news is, there is a [...]

QlikView – Suppress Splash Screen2016-01-28T22:26:07-04:00

QlikView – Formatting Expressions in List Boxes

2016-01-15T15:35:00-04:00

When adding an expression to a list box, one of the common complaints is that the numbers displayed are devoid of any number formatting.  This is especially frustrating when displaying large numbers without commas to ease readability. What most beginning report developers try is to format the values with the Number tools in the list box’s properties. […]

QlikView – Formatting Expressions in List Boxes2016-01-15T15:35:00-04:00

QlikView – Limiting Record Loads with the FIRST Prefix

2016-01-13T08:27:41-04:00

While developing a report, you may be loading thousands if not millions of records during the execution of your script.  If you are making edits to your script, and require a reload of the data to test your script changes, you may find yourself spending more time waiting than actually developing. If a sample of the data is sufficient for testing purposes, you can limit the number of records returned by using the FIRST prefix. The FIRST prefix is placed directly before the LOAD statement in the script followed by the number of records you wish to load.  For example: [Main Table]: FIRST 10000 [...]

QlikView – Limiting Record Loads with the FIRST Prefix2016-01-13T08:27:41-04:00

QlikView – Export All Tables as QVD Files

2016-01-11T11:38:51-04:00

Because QVD files load SO MUCH FASTER than the original data sources (i.e. Excel, Access, TXT, etc...), you may wish to save all of your tables to QVD files.  There are a couple compelling reasons to do this: You wish to develop your report in an offline state while retaining access to a relatively recent copy of the data. You wish to save all of your dimensional tables for reuse by other reports, and you want those tables to be optimized for fast reloads. To accomplish this task, perform the follow steps: 1. Add a sheet to your script and give [...]

QlikView – Export All Tables as QVD Files2016-01-11T11:38:51-04:00

QlikView – Dynamic Chart Titles

2015-12-20T14:38:56-04:00

It’s every chart maker’s dream to have dynamically changing titles (well, that and a coffee table that looks like a giant floppy disk.  Seriously; Google that one if you haven’t seen it.  It’s pretty cool.)  Any-hoo…  To have a chart’s title change based on data you are, or are not, filtering by is a real boon to understanding the story that the chart is trying to tell.  Take the following example: The reader of the chart can look at survey data for four categories all at once as a combined assessment, or they can filter by a specific category and evaluate [...]

QlikView – Dynamic Chart Titles2015-12-20T14:38:56-04:00

QlikView – Scheduled Update of QlikView Reports

2015-12-15T08:43:37-04:00

Suppose you want your QlikView report to automatically reload its data based on a schedule.  The manual process would be for you to open the report, click the RELOAD button, and then close the file.  If you team up the QlikView report with the Windows Scheduler, you can have this reload take place without human intervention. Step 1 – Create a Batch File Open Notepad and enter the following text: — For users running the 64bit edition of QlikView — “C:\Program Files\QlikView\QV.EXE” /R “C:\MyQVData\MyQVFile.qvw” — For users running the 32bit edition of QlikView — “C:\Program Files (x86)\QlikView\QV.EXE” /R “C:\MyQVData\MyQVFile.qvw” (Change “C:\MyQVData\MyQVFile.qvw” [...]

QlikView – Scheduled Update of QlikView Reports2015-12-15T08:43:37-04:00

QlikView  – Popular Hotkeys / Shortcuts List

2015-12-13T09:19:32-04:00

Script Editor <F5> or <Ctrl> + R Runs load script <CTRL> + <Shift> + R Partial reload <Ctrl> + T Shows model diagram <Ctrl> + E Opens table editor for LOAD INLINE statements (cursor should be placed inside statement) <Ctrl> + Q + Q Inserts script that generates several dummy tables <Ctrl> + K + C Comments blocks of script <Ctrl> + K + U Uncomments blocks of script <Ctrl> + F Allows search within the script in the debugger window […]

QlikView  – Popular Hotkeys / Shortcuts List2015-12-13T09:19:32-04:00

QlikView – Mandatory Include Statement to Prevent Data Inconsistencies

2015-12-13T09:20:18-04:00

The goal of every QlikView developer is to do as little work as possible.  When you notice that you are writing the same instructions in multiple app scripts, the notion of re-use is a red flag that flies with great fervor.  QlikView’s Include statement provide just such an ability. The advantages of re-using scripts between multiple apps has several advantages: Complex scripts can be used by multiple people with superficial knowledge of the script’s logic. Include files ensure business process consistency when performing similar actions across multiple apps. Include files expedite script maintenance because the script need only be updated once [...]

QlikView – Mandatory Include Statement to Prevent Data Inconsistencies2015-12-13T09:20:18-04:00

QlikView – Always View Chart Bars

2015-12-01T18:06:49-04:00

One of my pet peeves (wouldn’t that be a great name for a dog; “Peeve”?) when working with charts in QlikView is that I have a tendency to click on bars accidentally when showing data to colleagues.  When I do, all of the bars disappear except for the bar I mistakenly clicked on.  And for that millisecond in time, everyone receives a mental jolt that I wish would rather not have happened. Since I was trying to direct their attention to a particular month, I think a better behavior would have been for the bar to change color to visually separate [...]

QlikView – Always View Chart Bars2015-12-01T18:06:49-04:00

QlikView Preserving Dates in Crosstables

2015-12-08T17:00:41-04:00

The data transformation tools in QlikView are amazing.  When I think of the hours I have spent working with data that was output by some system trying to get that data into a format that I could then START modeling.  Oh, the wasted man hours. One of the QlikView transformation tools has the ability to take a crosstable (like a pivot table in Excel) and convert it into a straight table; a traditional flat table where data typically starts. The only problem with this tool is that it converts all of the data in the crosstable into straight text.  This means [...]

QlikView Preserving Dates in Crosstables2015-12-08T17:00:41-04:00

QlikView “Allocated Memory Exceeded” Error – An Easy Check

2015-09-08T22:05:01-04:00

If you have worked with QlikView and encountered the error message “Allocated Memory Exceeded”, there could be numerous reasons for this message.  You may have a quite a quest in store for yourself to figure out what the issue is.  But there’s quick and easy thing to check that may just be the reason for your plight. If you have been writing expressions, one of the primary culplits for generating this memory error is a simple syntax error with your expression. Here’s just such a scenerio:  You have created a fantastic pie chart and wish to add some intelligence to the [...]

QlikView “Allocated Memory Exceeded” Error – An Easy Check2015-09-08T22:05:01-04:00

QlikView 11 Script Editor Color Codes

2015-09-08T22:05:28-04:00

Have you ever been looking at your scripts in QlikView and thought to yourself, “What do all these different colors represent?”  Well, puzzle yourself no further.  I am here to explain what all of these colors are trying to say and then show you how to change them if you have your own color preferences. […]

QlikView 11 Script Editor Color Codes2015-09-08T22:05:28-04:00

PowerPivot Tutorial

2014-09-23T13:17:28-04:00

http://youtu.be/AHJIcqSFhzQ In this Microsoft Excel PowerPivot tutorial, you'll see how to use Microsoft Excel PowerPivot to import data from multiple data sources, link the data based on common fields and finally create a PivotTable and PivotChart to quickly analyze the data. This content is from our live, instructor-led Microsoft PowerPivot Training class.

PowerPivot Tutorial2014-09-23T13:17:28-04:00

QlikView Training

2013-06-21T21:55:48-04:00

  SkillForge is happy to announce QlikView Training - offered both as live, onsite classes and live, online classes. Business Intelligence is a major area of interest to most companies these days. With data stored in multiple different sources (mainframes, client server databases, etc.) - the idea of a simple "dashboard" for executives and managers to quickly analyze key performance indicators is very attractive. There are several tools in the market that can assist in building these dashboards, including Crystal Dashboard Design, SharePoint and QlikView.     From Wikipedia: QlikView can be used for all types of reporting, forecasting, and general [...]

QlikView Training2013-06-21T21:55:48-04:00