Skip to content

Guilherme Approbato

Management Consulting | Certified Qlik Data Architect and Business Analyst

About Me

Guilherme

  • About me
  • LinkedIn

Category: Qlik

English Qlik

Create groups based on metrics (and change it with variables)

Guilherme Approbato
No Comments

Variables are really useful in Qlik. If you wish to create groups based in thresholds, this could be a good way to go. In the video below I show how to group Countries (for example) based on dynamic values, creating a new dimension that will be using variables to calculate which countries are in which […]

Read more
English Exploring data Qlik Script

Split a table in multiple files (For loop) – Qlik Script

Guilherme Approbato
No Comments

When you need to create separate files from the same table using a filter, this is a good way to go: Let’s consider that we have a table with many countries in the Country column and you need to split this table creating one csv file for each country. If you are new to Qlik […]

Read more
English Qlik

Change colors in Qlik using variables

Guilherme Approbato
No Comments

In this video/post I describe two ways to dynamically change the colors of your visuals in Qlik Sense. Click here to download the QVF created in the video. The first one is quite simple:Qlik uses the RGB color scheme, so we can color the visuals by expression using the RGB() function. Inside the function it […]

Read more
Animated English Qlik

Tips to create Animated charts – Data Visualization

Guilherme Approbato
No Comments

Who doesn’t like those animated charts?
Read here some tips to create this kind of visuals.

Read more
English Qlik

Customize your Qlik page css without themes – trick

Guilherme Approbato
7 Comments

Did you know you can change the css class of your page without using themes? You just need a Multi KPI object (with a measure or dimension to “activate” it). In the Appearance section of this object you can change the css of the page elements. You can inspect the page elements to find the […]

Read more
English Maps Qlik

Shapes from buildings, parks and others from any city in Qlik

Guilherme Approbato
No Comments

Did you know we can import elements from any city using OpenStreetMaps and QGIS? And it is quite simple. OpenStreetMaps lets you export maps layers in a osm format, which can be read in GIS software like QGIS. It is quite simple to save the selected layer as kml. If you do so, you can […]

Read more
English Maps Qlik Web scraping

Web scraping with Qlik

Guilherme Approbato
No Comments

I used to scrape the web with Python (Beautiful soup), but it all changed when I found out how to do that with Qlik. In this video I demonstrate that by looping in a list of addresses and converting them in coordinates, finding in the html the latitude and longitude. There are lots of use […]

Read more
Certified Qlik Data Architect

Listed on the “Qlik Blog Portfolio” by QlikMap (click here and check other Qlik Blogs).

 

Most videos/posts are in english but there is also a category of videos in portuguese below.

A maioria dos vídeos/posts são em inglês mas também há uma categoria de vídeos em português abaixo.

Categories

  • Animated
  • English
  • Exploring data
  • Maps
  • Português
  • Qlik
  • Script
  • Web scraping

Recent Posts

  • Create groups based on metrics (and change it with variables)
  • Split a table in multiple files (For loop) – Qlik Script
  • Dados do IBGE – Painel Agronegócio SIDRA
  • Web Scraping em Qlik Sense – Português
  • Change colors in Qlik using variables