QlikView

URL encoding in Qlik Sense and QlikView

Göran Sander · 1 min read
URL encoding in Qlik Sense and QlikView

With so much cool data available online, tools like QlikView and Sense becomes real Swiss Army knives of data integration.

Pull in some data from company internal databases, some data from previously created QVDs, and more and more commonly also from various online sources, both public and private. Depending on how you call those online APIs you might get away with just sending in query parameters as they are, but in other cases – and this is especially true if you need to send more complex text strings to the API – you need to URL encode the query parameters.

Over the years I have run into this numerous times, but the other weekend I realised it’s actually very easy. Just create a mapping table using an online source for the utf8-to-URL encoded mapping, then use MapSubstring to convert each character in the URL parameter to its hex counterpart.

Code for this found over at GitHub, it’s just 10 or so lines of code.

Occam’s razor holds true again – the easy solutions prevail and are usually preferred!

Tags QlikView Qlik Sense
Göran Sander Stockholm, Sweden

Qlik Sense consultant and toolmaker at Ptarmigan Labs. Ten years at Spotify, Qlik Luminary and Partner Ambassador, author of the open source Butler tools.

All posts by Göran Sander
Keep reading

More about

Butler

Monitoring and auto-starting Node.js services on Windows Server

When relying on various Node.js services (e.g. Butler SOS, Butler, App Duplicator etc), you quickly run into the challenge to ensure all services are always up and running. A failing service might be fine, as long as it is quickly restarted in a predictable way. A concrete example

4 min read
QlikView

Posting to Slack - and more - from Qlik Sense load scripts (part 3)

Quick update to the previous post on this topic. There is a new version of slack_proxy available on GitHub. It adds a new endpoint for creating directories on the server where slack_proxy is running. This obviously means that the apps name – “slack_proxy” – is not really that relevant

1 min read
QlikView

Generating test data for QlikView and Qlik Sense

Real data and test data – both are needed One of the great things about both QlikView (QV) and Qlik Sense is their integrations with other systems. Given the native connectivity to any ODBC source, web pages in general, Salesforce, REST APIs, BigQuery etc – combined with the dozens of connectors provided

2 min read