Adam Cooke

59 posts

Make intervalmatch work with timestmap fields

A common issue with intervalmatch is fields that are automatically recognised with as a timestamp do not work correctly when trying to perform an interval match. Never fear! You can use untag to force remove the $timestamp to make it recognise the date time field as a number - this »

Feeling Brave? Use this methodology for your next Qlik Sense app build...

If you come from a Qlikview background, you may have mixed emotions about your first Qlik Sense implementations.. maybe it looked something like this: Design specification or reporting pack provided by business that needs to be put into Qlik Sense. Traditional Qlikview developer bangs head against wall building app to »

CSSGrid feels so warm inside

Party like its 2000! Table layouts are back and better than ever. Finally a standard CSS approach to responsive design that only gives me a partial headache. Get ready to unlearn some stuff bootstrapers. The pitch: It makes responsive designs so easy to achieve from some basic experiments. Just be »

Chrome Tool for testing websocket communication with Qlik Sense

You may be familliar with postman for doing REST calls to the Qlik APIs. You can also test websocket queries using this tool: https://chrome.google.com/webstore/detail/smart-websocket-client/omalebghpgejjiaoknljcfmglgbpocdp Its pretty useful for testing network connectivity when working with Qlik Sense apps and mashups. »

Easiest way to use Qlik JSON requests in nodejs

You could use enigma, qsocks and one of the other libraries. The most straight forward way I have found however is to simply use ws. const WebSocket = require('ws'); const ws = new WebSocket('ws://localhost:4848/app/engineData'); // create a new session: ws.on('open', function open() { ws.send(JSON. »

Full List of Qlik Sense Repository (QRS) API Paths and Endpoints

So this is likely only going to be valuable if you are doing something more advanced with Qlik Sense in a web application or custom on demand scenario. Let me know what your up too – I’m always interested! This is a complete list of all Qlik Sense QRS endpoints »

Qlik Sense Video background Extension

This extension lets you use videos as a background to your Qlik Sense Dashboard. In this example I connected aerial views of different energy sources to selections made on the dashboard. It certainly adds something eye catching to your standard Qlik sense dashboard. It only works when using Qlik Sense »

All US Zip Codes with Latitude and Longitude for Qlik Sense

Hello! This is a file that contains all longitude and latitudes for the US zip codes. It has proven really useful for Qlik Sense Mapping visualizations. It contains the latitude and longitude of every United States zipcode. It also includes the City, State and County of eaech zip code. You »

All UK Postcodes.CSV with Lat and Longs for Qlik Sense

Hello! This is a file I created by scraping data from a freely available Geographical API. It has proven really useful for Qlik Sense Mapping visualizations. It contains the latitude and longitude of every uk postcode. It also includes the Easting, Northing, Grid Reference, District, Ward, District Code, Ward Code »

Handle Qlik Dates inside an extension using Moment.js

Recently I was trying to use dates as one of the dimensions inside an extension. Qlik can deal with lots of types of dates, when they are passed to the extension they come through in both a text format in the way they were formatted within Qlik using the date »

Getting data from a Qlik Sense object using the API

Qlik Sense objects each have a table of data behind them that is used by the visualisation. This is been called a ‘hypercube’ by Qlik. If you have lots of rows in your data table, then Qlik will split the ‘hypercube’ into separate pages so the data doesn’t crash »