data warehouse Use Qlik Sense as a data warehouse Most organisations and people in business intelligence are aware of the term Data Warehouse and its percieved benefits: A Data Warehouse Delivers Enhanced Business Intelligence A Data Warehouse Saves Time A Data Warehouse Enhances Data Quality and Consistency A Data Warehouse Provides Historical Intelligence
correctly format dates Using tags in the Qlik Sense Table Viewer to make sure fields are stored correctly Normally Qlik Sense does a great job of picking up whether the field is a date or text. Sometimes you get some data thats fallen off the back of a lorry that doesn’t seem to be identified correctly by Qlik Sense automatically. You
qlik inline table Store data within Qlik Sense with an inline table Sometimes you may have some data that you want to store just within the load script and not have a completely separate data source. You can use an inline table to do this: TableName:<br></br> Load * inline<br&
Qlik Sense Accessibility Qlik Sense Voice Control Extension Now you can control Qlik Sense dashboards with just your voice using this extension in Chrome. Chrome is currently the only browser that properly supports MIC usage. This extension has
adding external data The Qlik Sense Datamarket - what is it and how do I use it? Datamarket is an attempt to give you access to reliable external data such as Weather, Demographics to provide insight with your own data set. Practically it means that once you go through the datamarket wizard, it will generate a Load statement that will pull
Qlik Sense Consulting Are Qlik Sense extensions Safe? Questions to ask yourself before putting an extension in a live app Extensions are cool and wizzy. They are great for early buy in on a Qlik Sense project, but in production there are some important questions to ask before utilizing them: Who built the extension? How often is the extension updated? Does the extension work
dev-hub The Qlik Sense Dev Hub - Overview If you were wondering how to manage extensions or Mashups in Qlik sense you can do this directly in Qlik Sense Desktop by accessing the new Qlik Sense Dev-Hub. It
qlik sense 2.1 features Qlik Sense 2.1 has variable editor, media library, visualization exploration and more Yesterday Qlik released Qlik Sense 2.1. This one has loads of things and is really worth a download, the product is starting to mature and i’m very sure there’s loads more to come. The variable editor is back If you are
qlik sense consultant Tag dimensions and measures in Qlik Sense to help users The dimensions and measures library has a really handy search function to help end users find fields and measures that they want to drag onto a visualisation. Sometimes the fields are not in the most helpful names, especially if they have been pulled directly
Dimensions and measures What is the difference between dimensions and measures in Qlik Sense? If you have just started using Qlik Sense then you may be confused about what exactly the difference between a dimension and measure is in Qlik Sense or Qlikview. Any visualisation can be said to contain dimensions and measures. A measure is a calculation.
date and time functions Correctly format a date from a string in Qlik Sense using MakeDate function Sometimes you get some data and the dates are just not right. They are stored as text or as a string or in some wierd format that you just don’t know what to do with. An easy way to make sure the date
Qlik Sense Consulting Split a string into seperate fields using the subfield function in Qlik Sense Subfield() is a great function for splitting a long string into seperate fields. You can use this to split out a date or anything where you have a common delimeter in a string. For example. If you have the string field name: TextString line
Load Script What is a QVD file in Qlik Sense and how do I use it? A QVD (QlikViewData) file is a file containing a table of data exported from Qlik. QVD is a native Qlik Sense and Qlikview format and can only be written to and read by Qlik. The file format is optimized for speed when reading data
Qlik Sense Using Qlik Sense to connect to a web API with dynamic URLs If you want to bring in data from a web API then this can be done with Qlik Sense out of the box. Go to data connection library as shown below. click on ‘Web File’. Great! In here you can paste an API call
Qlik Sense Consulting Qlik Sense high vis mode Maybe you need to see your dashboard in bright high visiblity colors? When accessing a Qlik Sense dashboard through your browser just put theme/highvis at the end when your on a sheet. http://localhost:4848/sense/app/ %5C%5Cpsf%5CHome%5CDocuments%5CQlik%5CSense%
Qlik Sense Consulting Put non standard Characters inside Qlik Sense Using char() If you have a need to put rare characters into Qlik Sense this can be done inside objects using the Char() function. http://www.yellowpipe.com/yis/tools/ASCII-HTML-Characters/
Qlik Sense Consulting Create a custom Current Selections Bar in Qlik Sense You may be comfortable with the Qlik Sense default current selections box: What if you or your end users aren’t keen on the look and feel? Especially inside a web application you may not want to always use this to control your Qlik
Qlik Sense Consulting Select searchable fields in Qlik Sense Global Search So this is something new in Qlik Sense that you can do with the load script. If you are familiar with Qlikview you will be aware of the search object and the ability to select fields you can search. This is also possible in
Extensions Branded templates for Qlik Sense in Workbench editor This is a great example of using workbench editor to get the most out of Qlik Sense and achieve things that no other product(including Qlikview) can with drag drop functionality for users with no HTML/CSS skills! Hopefully more to follow. The branch
Qlik Sense Consulting Qlik Sense Web Applications Quick start HTML layouts to get your Qlik Sense web application looking good quickly You don’t need to be an expert in web devleopment to throw together some stunning web based dashboard using Qlik Sense. There are loads of websites that give free HTML5 layouts that you can use and modify as a starting point for your
Qlik Sense Consulting Introduction to Git for Qlikview people Basically Git is change control for your working directory. It is platform independent, you can install it on Windows, Linux, Mac whatever… and these people will all be able to work together using GIT. You can use GIT with a command line or with
Qlik Sense Consulting Introduction to Bootstrap for Qlikview people This post may be of interest to you if you want to do a branded layout in Qlik Sense. With Qlikview it was very easy to throw a layout together and use show hide conditions to make intuitive layouts. Qlikview people often comment that
qlik sense consultant What is a mashup? A **mashup ** is a web page that uses content from more than one source to create a single new service displayed in a single graphical interface. In the context of Qlik this means we can combine the powerful Qlik Sense data modelling engine with
Qlik Sense Consulting Heroku and Qlik Sense - A great combo for hosting analytics mashups Before we start please note the below is my own opinion and is in no way endorsed by Qlik as a company. Follow at your own risk :). The aim of this post is to explore the possibility of hosting a Qlik Sense mashup on
