w0w

Technical blog

w0w
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

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
1 min read
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.

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
1 min read

Great data visualisation from The Simpsons

😀

  • Adam Cooke
    Adam Cooke
1 min read
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.

  • Adam Cooke
    Adam Cooke
1 min read
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/

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
2 min read
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

  • Adam Cooke
    Adam Cooke
1 min read
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

  • Adam Cooke
    Adam Cooke
3 min read
Qlik Sense Consulting

How to find Qlik Sense object IDs

You can quickly find Qlik Sense object IDs by visiting http://localhost:4848/single.html This can save lots of time!!

  • Adam Cooke
    Adam Cooke
1 min read
Qlik Sense Consulting

Creating a combined Qlikview and Qlik Sense access point

In places where Qlikview is already alive you may want to give your users a single place for them to access both types. This can be done using this project on Qlik Branch:

  • Adam Cooke
    Adam Cooke
1 min read
Qlik Sense Consulting

Qlik Sense D3 Visualisation Example Library

Here are some great examples of D3 inside of Qlik Sense: http://sense.axisgroup.com/sense/app/1dadc9e8-d2f5-47f8-ad21-a2209257cc20/sheet/xtcwya/state/analysis This is the github repository: https://github.com/skokenes/Qlik-Sense-D3-Visualization-Library This

  • Adam Cooke
    Adam Cooke
1 min read
Qlik Sense Consulting

Do a fuzzy search on a value with Qlik Wildmatch function

There are lots times in Qlik Sense and Qlikview where you want to be able to search a value for a particular string. Some people might call this semantic analysis, some people might

  • Adam Cooke
    Adam Cooke
1 min read
Qlik Sense Consulting

Qlik Sense class function

The class function enables you to group numeric values into buckets that you can then use as a dimension in a chart. Imagine you have the following data table: NameAgeBob32Ellie55Fred5Steve20Say you want to

  • Adam Cooke
    Adam Cooke
1 min read
Qlik Sense Consulting

Authenticate Qlik Sense in a nodeJS + express app on an external web host

Note: This is all my own opinion and in no way is endorsed by Qlik. Use at your own risk!! Why would you want to do this? ExpressJS is one of the most

  • Adam Cooke
    Adam Cooke
3 min read
Qlik Sense Consulting

Simple mashup user access permissions

A simple way to think about a mashup is as an extension of the particular Qlik Sense application you have embedded. If a user does not have access to the application inside a

  • Adam Cooke
    Adam Cooke
1 min read
Qlik Sense Consulting

Qlik Sense Workbench dev-hub location and other mashup links for developers

To normal mortals like me it took a while to work out how to actually access the Qlik Sense Workbench in Qlik Sense Desktop. At this time it is not a separate product

  • Adam Cooke
    Adam Cooke
1 min read
w0w © 2019
Latest Posts Ghost