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 site uptime via Power Automate

qlik-sense-power-automate-uptime-notification

Nearly a year ago, I blogged about using Power Automate from Qlik Sense to send notifications to Teams channel and send emails. This time I would like to explore a different area, how to use Power Automate to monitor your Qlik Sense Proxy Service (QPS) availability and send notifications when it’s not accessible.

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 →

Coronavirus Outbreak Data Feed

2020-03-06 UPDATE: Added daily UK feed including total tested figures, GitHub and Azure Notebooks both have been updated.

With the spread of coronavirus and the general panic around it, it’s hard not to ask or hear questions like –

How many people have been infected so far?
How many people recovered?
Wonder how many people have lost their loved ones?
Which countries’ been affected so far and in what rate?

TLDR: A python script to scrape Wiki table to get up-to-date summarised information on coronavirus outbreak. The link to my Azure notebooks (Jupyter hub) or GitHub.

Continue reading →

Qlik Chat

The vision of democratising data, making everyone explore and find insights from corporate data is one of the biggest drivers behind Qlik Sense. But what happens when you find the insights you have been looking for? How do you share that with your peers? We have seen some great examples which allow you to share links with your selections (using app API) or take a snapshot and share it via email. But that is lacking the true intuitiveness that we are so used to from a platform. We also have seen extensions such as Lets comment and few other similar chat/commenting options, but they require 3rd party services that business will have to setup and sign up to.

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 →

Sitting in the shadows no more…….Cloud deployments: My learning and the best practices

I have been sitting in the shadows and reading up on all the good work the people from the Qlik community are producing. I have benefited from it more than I can count and have tried to add my small contributions to that many times. Unfortunately, finding the time has always been a bit of a challenge. Now, I have decided to make the time and write something meaningful, in the hope that someone will read my blog, find it useful and benefit from it.

Continue reading →