QlikView Keyboard Shortcuts


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

Creating the Speedometer Gauge in QlikView


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 QlikView2019-10-17T15:15:16-04:00

Using Qlikview’s Date Functions


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


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

QlikView Quick Suggestions: Moving a Comma for Quick Editing


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


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-05:00

QlikView – Suppress Splash Screen


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-05:00

QlikView – Formatting Expressions in List Boxes


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-05:00

QlikView – Limiting Record Loads with the FIRST Prefix


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-05:00

QlikView – Export All Tables as QVD Files


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-05:00

QlikView – Dynamic Chart Titles


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-05:00

QlikView – Scheduled Update of QlikView Reports


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-05:00

QlikView  – Popular Hotkeys / Shortcuts List


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-05:00

QlikView – Mandatory Include Statement to Prevent Data Inconsistencies


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-05:00

QlikView – Always View Chart Bars


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-05:00

QlikView Preserving Dates in Crosstables


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-05:00

QlikView “Allocated Memory Exceeded” Error – An Easy Check


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


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

QlikView Training


  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