Skip to content

Guilherme Approbato

Management Consulting | Certified Qlik Data Architect and Business Analyst

About Me

Guilherme

  • About me
  • LinkedIn
Animated English Qlik

Tips to create Animated charts – Data Visualization

Avatar photo
Guilherme Approbato
No Comments

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

Read more
English Exploring data Qlik

Qlik Tips Series

Avatar photo
Guilherme Approbato
No Comments

Recently I started a series of short videos with some tips for those who develop in Qlik. You will probably find something new there, so check it out! The first video is embedded below, but you can find the playlist here in this hyperlink.

Read more
English Qlik

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

Avatar photo
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.

Read more
English Exploring data Qlik Script

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

Avatar photo
Guilherme Approbato
No Comments

How to split a database using a Where clause with For loop.

Read more
Português

Dados do IBGE – Painel Agronegócio SIDRA

Avatar photo
Guilherme Approbato
No Comments

Nesse post a visualização foi criada usando Power BI. O portal SIDRA do IBGE é extremamente rico na diversidade de setores e no nível de detalhes em suas pesquisas. Considerando o nível de detalhe disponibilizado (município), é possível analisar área plantada, quantidade produzida e valor da produção de diversos cultivos. O dashboard abaixo foi criado […]

Read more
Português

Web Scraping em Qlik Sense – Português

Avatar photo
Guilherme Approbato
No Comments

Existem algumas formas de automatizar a busca em páginas / web scraping, e eu sempre usei python para isso (módulos requests + pandas). Há um tempo, assistindo o canal BIdeAZ, vi que era possível fazer web scraping usando o próprio Qlik Sense. Usando FOR e variáveis podemos mudar a url de forma dinâmica e extrair […]

Read more
English Qlik

Change colors in Qlik using variables

Avatar photo
Guilherme Approbato
No Comments

In this video/post I describe two ways to dynamically change the colors of your visuals in Qlik Sense

Read more
English Qlik

Customize your Qlik page css without themes – trick

Avatar photo
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.

Read more
English Maps Qlik

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

Avatar photo
Guilherme Approbato
No Comments

Did you know we can import elements from any city using OpenStreetMaps and QGIS? And it is quite simple.

Read more
English Maps Qlik Web scraping

Web scraping with Qlik

Avatar photo
Guilherme Approbato
No Comments

How to scrape the web using Qlik Sense.

Read more

Posts navigation

1 2 Next
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

  • Qlik Tips Series
  • 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

The Qlik Sense Express Course is ready!
Save time and work more efficiently using Qlik.
Click here to know more!

Use the Coupon QLIKBLOG and get 10% OFF