Data entry with Airtable in Qlik Sense

It has been a while since I last posted. Between coaching, playing cricket and work, I haven’t found much free time this summer to blog. But now that sunny summer days are behind us, I thought I would pick up the pen (well, keyboard in this case) and share some of my ideas.

This year has been a busy year for Qlik. Qlik Sense SaaS is adding new features quicker than I can keep up with. It’s great news for all the fellow Qlikies out there. It’s no surprise that past 12 months I have been busy with SaaS and hybrid deployments to help our clients with their SaaS journey.

For all the new features in Qlik Sense SaaS, there are times when businesses demand more of the platform. And today, I would like to look at one of those use cases, which involves integration with Airtable using a simple Qlik Sense extension from yours truly!

Continue reading →

Qlik Sense User Selections Log

It’s been a while since I last posted here. Splitting my spare time in between Kids in Data, Data on the rocks and recent addition of Data literacy geek project, sadly left me with not much spare time to give this place much love that it needs. Today I aim to remedy this and share how to capture user selections in Qlik Sense Enterprise for Windows using logs and report on it.

Continue reading →

Qlik Sense Alert 2 – MS Teams + Power Automate

qlik-sense-alert-2 via Teams and Power Automate

Nearly a year ago, I wrote about sending alerts to Microsoft Teams channel using Qlik load script and REST connector. With the coronavirus sweeping through the world, forcing people in lock-downs, we are seeing surge in the use of collaboration tools such as Microsoft Teams. So, I wanted to expand on this further and send a HTML table as notification to MS Teams channel and send emails using Microsoft Power Automate (Previously known as Flow) to help people get the notifications quicker.

Continue reading →

Qlik Sense JSON Connector

Happy 2020 Everyone! 2019 seemed to have gone flying by, it had been a very busy year for me – lots of really interesting Qlik projects, learnt a lot of new skills and of course, lot more about Qlik’s internal workings. With that in mind – I wanted to share an interesting concept today – how to build and deploy a “JSON” file connector using no additional tools other than what you already have installed in your Qlik Sense Enterprise on Windows environment.

Continue reading →

Qlik Load Script Alerts to Microsoft Teams

Qlik Sense is a great platform, however, it has its shortfalls. One of them would be the lack of push notifications out of the box from QMC. Last year, I worked on a few solutions to send alerts via emails and via APIs/webhooks to bespoke applications when there is a job failure on Qlik Sense Enterprise. I utilised the QRS API as well as REST connector and webhook technologies to achieve these goals. That got me thinking, what else can be done using webhook? At Tahola, we use Microsoft Teams as part of our collaboration suite. I thought it would be a good idea to be able to send alerts to the Teams channel directly from Qlik data load scripts (via REST connector), whether be a load completion alert or just a simple KPI summary table from the data model. So, I spent few hours building a PoC Qlik application to that goal, and thought, I should share the concept with others as it might be useful in some scenarios.

Continue reading →