Category Archives: Qlik

Qlik Partner Ambassador

Hello world, it’s been a while since I’ve put pen to paper, but, I have some news…

Super proud to be joining the first Qlik Partner Ambassador class of 2021. This is the first time Qlik have acknowledged those within the Qlik ecosystem who come from the Partner background. Some of you may know that I was a Luminary last year, but, due to the focus of that program shifting to be customer first, the Partners now have their own dedicated channel within Qlik. Exciting times ahead.

More info…

Canny Tip #2 – CTRL + 00 = Data Model?

This is Canny Tip #2 and its a Qlik Sense tip!

Ever wished there was a way to automatically generate some dummy data?

Perhaps you want to test out some new visuals, or make sure Section Access is working without pulling together a brand new data model.

CTRL + 00 to the rescue!

A good friend (@QlikStu) showed me this trick, quite a while ago, and at the time, it blew my tiny Qlik mind.

From the Data Load editor, create a new tab, then hit CTRL + 00

And before your eyes, a 30 line Qlik script is automatically generated and inserted.

Simply reload your App, and hey presto… 1981 rows of dummy data is loaded!

Easy 🙂

Simple data model for simple data testing!

Canny Tip #2 =

Use CTRL + 00 to quickly build some mock data!

Canny Tip #1 – HUB + CTRL + F = Search *All* Your Apps?

Hello – Welcome to a new mini series of blog posts on little hints, tips and gotchas as I work my way around Qlik Sense and other Business Intelligence tools. This is Canny Tip #1 and its a Qlik Sense on Windows tip… enjoy!

Sometimes the simple things make you stop, think, and re-evaluate.

I was looking for an app that was either published in a stream, or had been duplicated in the My Work stream.

Normally I’d jump into the QMC, and filter on the Apps page to see which stream the app resided in, then open The Hub, to find what I was looking for.

For some reason, I decided to hit CTRL + F, and before my eyes appeared a search experience I had never seen in the Qlik Sense Hub…

At the top of the screen, a search bar appeared, which allowed me to search for the App I wanted, and launch, all from the same screen. I was expecting for the standard web browser “find in page” search to appear, so I was surprised to see this common shortcut had been remapped to something a lot more useful!

“A search box, that’s not very exciting Carl” I hear you squark, however, it is a global smart search

It doesn’t just look for the App name… it searches within the App’s metadata too!

As per below, I was looking for an app called NAV, but, it also found an app with the App Description containing “navigation” – pretty cool!


Canny Tip #1 =

Use CTRL + F to search for apps from The Hub

Qlik Sense Business – you what?

Hello all, today I am mostly talking about Qlik Sense Business… You what? Qlik Sense Business? Yes, Qlik Sense Business.. let me explain!

This is blog one of many I am planning on Qlik Sense Business. I hope to explore the functionality, and comparing and contrasting with Qlik Sense Enterprise and other solutions.

Anyway, on with today’s blog

Who is Qlik Sense Business?

Qlik Sense Business is Qlik’s newest SaaS solution which brings you all that you love about Qlik Sense, and puts it in the cloud, ‘as a service’

What is Qlik Sense Business?

Qlik Sense Business (or QSB for short) is Qlik Sense Enterprise, but hosted by Qlik on their SaaS (Software as a solution) platform, based on top of Kubernetes architecture – I believe the cool kids call this K8s?.

Don’t worry, you don’t need to know about Kubernetes or anything like that, this is a simple to use, quick to get up and running with, Business Intelligence platform.

QSB doesn’t have all of the bells and whistles of standard Qlik Sense Enterprise, however, only drops API integrations, managed spaces, access to “value-added” products such as NPrinting and Alerting. You still get the core Qlik associative engine, with self service creation and ETL as well as global search, insight advisor, mobile access, and everything else you’d expect from a Qlik Sense product. 

There is a seamless upgrade path to Qlik Sense Enterprise, which means once you’ve hit the capacity limits*, or want to look at different deployment methods, you can simply upscale without having to rewrite or ‘do anything’ – just the click of a button. I have to say, the capacity limits are quite high, which is good, and surprising for an entry level product. Well done Qlik! 

*App size in memory 1.25GB, storage on disk (250GB), 50 reloads per day and 3 reloads concurrently.

Where can I find Qlik Sense Business?

QSB is a SaaS solution, and can be found the Qlik website. No software is required, just you, your data, and an internet connection –

How much does Qlik Sense Business cost?

QSB starts at $30/user/month, or for fellow Brits £23.75/user/month. There is tiered pricing available too, meaning, more you buy, the cheaper it can be! If that doesn’t tempt, there is also a 30 day free trial…

When can I use Qlik Sense Business?

QSB is available now, go for it. You might, also, wish to engage with a Qlik Partner, to help with configuration

How do you get started with Qlik Sense Business?

Head on over to and click “Try It Free”. Once you’ve got your tenant setup, its super simple to get going. On the main landing page, you can ‘start your journey’ by analysing sample data, or analyse your own files by uploading a spreadsheet or connecting to a SaaS/cloud data source

Clicking on ‘analysing sample data’ imports a data model, and launches the Insights Advisor, and allows you to explore and ask those questions of your data… For example… “top sales by customer” will auto generate insights, data, and charts for you – very cool, very easy to do.

To add the automatically generated chart to a sheet, click Add to sheet, which will take you into edit mode. From here, you can start to add more objects to craft your dashboard! Ps – notice, no code was used in the gif below, all drag and drop, all using the AI and Qlik’s cognitive engine…

Why would *you* use Qlik Sense Business?

If you are new to the Qlik ecosystem, and want to give it a try, using the 30 day free trial, then this is a great way to get started quickly and cheaply – if your data sources are mostly cloud based. On premise data sources such as a SQL Server running Sage 200 would require firewall configuration, to allow your Qlik Sense Business tenant to talk to your server.

Qlik Sense Business is a direct replacement for using Qlik Sense Desktop – as this is no longer available as a freemium product**. You get the vast majority of functionality with QSB, so this is not a cut down version, the good stuff is not hidden behind an expensive paywall (like other providers…).

Why would *I* use Qlik Sense Business?

Well, being honest, in my professional life, I currently don’t – apart from as an environment for learning – however, I can see there becomes a time where all Qlik prospects start out on Qlik Sense Business, for Proof of Concept / Seeing is Believing type events, and once the time is right, migrates over to Qlik Sense Enterprise.

But, for me, this isn’t quite how it works in practice 🙂

To finish…

I hope you found that useful, stay tuned for more blogs re Qlik Sense Business

**Qlik Sense Desktop is kinda still free, if you do this:

Setting up a ‘Meet Up’…

For the last year or so, I’ve been trying to attend more Tech related events in my area, as we know, a tech community only thrives when people engage with it. In Sunderland, there is an excellent monthly meetup, creatively named, Sunderland Digital (link), however, in the North East of England, as of 2018, there wasn’t much in the way of a Data nor Business Intelligence community.

Flash forward to February 2019, and, I am now co-organising the first Qlik Meetup in the North East… the snappily named… North East England Qlik & Business Intelligence Meetup – which is proof of the above, a community only thrives when one engages with it!

As we progress on with the planning etc, I plan on blogging on what went well, what didn’t go so well, and what to think about if you are considering creating your own Meetup, or getting involved with a Meetup.

Anyway… our first event will be held on May 8th, and the speakers line-up looks something like this:

Meetup #1 Image

For more info, or to RSVP to the event, see here > 

Until then, stay safe and keep on being canny with your data!

How to choose the right Business Intelligence platform

Hi, I’m Carl, the newest Business Intelligence Developer in the Business Intelligence team at TSG, and this is the first of (hopefully… maybe…) many blogs from myself on the wonderful world of BI. I also tweet about BI on a regular basis, so if that’s your sort of thing you can follow me.

I may have only been with TSG since November 2017, but I bring plenty of experience to the table (database joke, ha?) in reporting, data analysis and business intelligence, ensuring businesses get the data they need in a fashion they understand, to supporting them in making important decisions.

Anyway, less about me, on with the blog!

There is a battle raging in the Business Intelligence sector now, with two heavy hitters slugging it out to be crowned the King of BI™. In the left corner, we have Qlik Sense, developed by Sweden’s very own Qlik. In the right corner, we’ve got Power BI from everyone’s favourite enterprise IT provider, Microsoft (with whom we hold 8 Gold Competencies). Data literacy is very much a 2018 hot topic, so implementing the right Business Intelligence solution for your business is crucial.

Since I’m new to TSG and have previously used both Qlik and Microsoft’s last-gen BI solutions (QlikView/SSRS), as well as many others on the market (Crystal/Business Objects), I’m in a good position to compare both solutions and share my thoughts!

Here we go…

Qlik Sense


Qlik Sense is Qlik’s next-generation Business Intelligence platform utilising the same QIX engine and scripting language as QlikView, however with a brand new responsive, HTML5 front end, which is perfect for beautiful-looking visualisations, as well as plenty of improvements in the backend for developers like me!

Explore all of your data

Qlik Sense prides itself on its in-memory QIX associative engine, a patented technology which allows you to explore your data without limits. Other BI solutions are one-directional and query-based, i.e. “show me the top salesperson in the North East, please”, which will give you exactly what you want. However, Qlik Sense is different as it allows you to query in any direction.

With Qlik Sense, no data is thrown away, so in the example of “top salesperson in North East”, results that do not answer this query are still shown but in grey, rather than not being displayed at all. This is the power of “green, white and grey” and is incredibly powerful for data discovery… i.e. when you click on a value to isolate it, it goes green, anything associated stays white and anything that is excluded goes grey.

create-and-explore-on-any-deviceThe Qlik Sense front end is very user-friendly due to the in-memory engine, performance is super-fast as when selections are made, on-the-fly calculation and aggregation instantly updates all analytics with each click of your mouse or, on an iPad, with the prod of your finger. Filters can be applied to multiple graphs simultaneously, in an intuitive manner, which are then applied globally to your entire app. The “brilliant black bar” at the top of the Qlik Sense screen keeps track of what you have selected, and allows you to easily change filters or pose another question of your data.

Bringing together disparate data

Another killer feature of Qlik Sense is the Global Smart Search, which is like Google on steroids for your data. You can search for a combination of filters and then when you select those filters they are applied across the app, meaning data discovery is even faster.

Connecting Qlik Sense to your line-of-business applications, current or legacy data warehouse, or even to a shed load of spreadsheets is all possible, out-of-the-box, with Qlik’s scripting language and an array of connectors for on-premise, cloud or web-based data, using standard protocols such as ODBC, OLE DB or REST.

Qlik’s scripting language allows you to completely transform and join your data into whatever shape is required. There are literally hundreds of functions; everything from pivot, to capitalise, to performing in-depth set analysis to slicing and dicing your data to the nth degree. If scripting isn’t your thing, Qlik Sense provides an array of easy-to-use wizards, such as the Data Manager, which allows you to import and join data without one line of code. Hashtag no coding required.

Should I use Qlik Sense?

If you want a full platform for your business, you have multiple data sources and presently suffer from a series of blind spots in your data, so would be interested in true data discovery, then Qlik Sense could be for you.

Power BI


Many people think that Power BI is Microsoft’s new kid on the block, however it spawned from one of the best programmes ever developed – Excel – as PowerQuery and PowerPivot. It’s now supercharged with an Azure backend and boatloads of new features.

The Microsoft ecosystem

Being a Microsoft product, as you’d expect, Power BI is firmly embedded in the Microsoft ecosystem. It has complete integration with all of Microsoft’s cloud solutions, such as Dynamics and Office 365, and can seamlessly import data from all these solutions via out-of-the-box connectors.

The ability to transform data from source is very powerful, with the ‘Get Data’ process. You can, with a point-and-click interface, quickly change data types, pivot, cleanse, and create new data from your source systems. For more advanced operations, Power BI has its own programming language called DAX, which allows advanced calculations and transformations. It might be a new(er) kid on the block, but it packs a serious punch for data wranglers like myself.

The fastest-growing BI platform

The development team behind Power BI is currently pushing out new features quicker than you can say “where’s my report”, with new releases of the Power BI desktop client published monthly. In the time I’ve been at TSG alone, they’ve released 35 new features (which is astonishing) – from the simple “Bar/column padding control” to the complex “High density sampling for maps based on latitude and longitude”. It’s safe to say Microsoft is investing heavily in its new BI solution, and it’s here to stay.

Power BI is the only product with Natural Language Query capabilities. You simply type a question (i.e. “What was our average transaction value over the past 3 months?”) and Power BI selects a visualisation for you to explore. This goes hand-in-hand with Quick Insights, a series of advanced analytical algorithms developed by Microsoft Research to help you to analyse your data further.

A big selling point of Power BI is the Power BI Service, which is the cloud-based platform where the magic happens. However, if you aren’t ready for the cloud, Power BI can be deployed on-premise, with the Power BI Report Server. Your rich, interactive reports are published to the Power BI Service, and then can be shared with end users via Office 365 groups, meaning you can deliver reports and dashboards to the right people, first time, in a repeatable, auditable, tightly-controlled manner. Reports and dashboards published to the Power BI Service can be reconfigured for mobile use too, meaning you can take your data with you, while on the road.

Should I use Power BI?

If you are heavily invested in the Microsoft ecosystem, and would like reports, dashboards and analysis from reasonably straightforward data sources, then Power BI could be for you.

When I first started using Power BI, due to my knowledge of Qlik Sense, I was disappointed with the filtering capabilities. Qlik Sense filters work across an entire “app” – i.e. a series of reports. However, in Power BI, filters are only available per visualisation, per report page, not globally. This slows down the discovery of data, and initially felt like a deal breaker to me. Microsoft has acknowledged this issue, as the lack of a global search is the most upvoted feature request. I’m sure Microsoft will rectify this missing feature, as it has finally acknowledged the deficiency, in the coming releases… hopefully!

In Conclusion…

Originally, this blog was going to be a comparison between the two platforms, concluding with me hailing a winner. However, the more I’ve learned and developed solutions with the products, the more I find this to be quite a difficult question to answer. Like comparing apples and oranges, both are fruits (but tangerines are better). Or, as Stu Wannop, TSG’s Business Intelligence Specialist, says… “It’s like asking who would win in a fight between a gorilla and a shark – it depends if it’s on land or in the sea!”

Both solutions offer beautiful, dynamic dashboards that everyone from the Operational Manager to the CFO would be wowed with, however my personal preference is Qlik Sense. Qlik Sense trumps Power BI with features such as governed data, the associative engine and mobile capabilities. However, Power BI’s cloud offerings are more mature and scalable than Qlik Sense, as its built on top of Azure, and integrates brilliantly with Office 365.

The future of BI

Qlik shouldn’t rest on its laurels, as Microsoft is quickly catching up, especially in the cloud and advanced analytics space, and if/when Microsoft nails the Power BI global filtering, its functionality set could outpace Qlik Sense – it’s an interesting time in the BI world!

You frankly can’t lose if you’re implementing either of these solutions, and TSG can assist you with all of your Business Intelligence requirements, because getting the data you need, to answer the questions you have, in the format you understand, is imperative in a modern business.

The only true way to pick the King of BI™ is to find that shark and gorilla..


The above article was originally posted on my employers blog – see here