1 2 3 Previous Next

Qlik Design Blog

61 Posts authored by: Arturo Muñoz
Arturo Muñoz

Gas price analysis

Posted by Arturo Muñoz Oct 19, 2018

Some people claim that data can save the world. Although that’s probably true to some extent, the demo app I’m introducing today, Gas Stations app, has a humbler goal, it can help you to save some money (if you happen to be in Spain).




The Qlik team in Spain has been gathering gas price data for over four years now, and has created one of the most comprehensives gas price data tools out there built in Qlik Sense. We are using only a fraction of it contents to create this demo app.


The Gas Stations demo app features a calculator that helps users understand how slight changes in gas prices per liter can have an impact on the large scale.




Gas prices in Spain – and I guess anywhere else – present a compact distribution across all suppliers. In my example, I’m checking for Gas 98 prices in Barcelona, as of today the difference from the cheapest to the more expensive gas station is 0.304 euros per liter, which doesn’t look like a big deal.


To help anyone to understand the impact of small price-per-liter differences, we are mashing up the gas prices data obtained from Spanish Ministry of Industry webpage with fuel tank’s car capacity data collected from car makers.


The Gas Stations app let users search for their vehicle maker and model and indicate how many gas tanks per month they consume. With that extra information, a user can finally see what the price-per-litter gap really means.


For example, picking the right Gas Station to fill up a car’s fuel tank in Barcelona comes to 70,53 euros/month of potential savings for someone driving a Volkswagen Tiguan that runs on Gas 98 and consumes four fuel tanks.




And since picking the right gas station can have a significant impact on our pockets by the end of the month, the app includes a detailed map of all the gas stations in Spain. Users can filter down to a region and check the exact location of each gas station, and the legend color indicates the cheapest gas stations.


If you can't use public transportation to get you to your destination, and driving your car is the only option available for you, then do yourself a favor and use our Gas Station app, it will help you save a significant amount of money that you could use to contribute to save the planet.




Enjoy it!

Arturo Muñoz (@arturoqv)

If I ask you what the alpha value means in hypothesis testing, I’d bet most of you would be able to give a correct answer right away, am I right? But you are a minority, most people in the world wouldn’t have a clue – only about 1 in 5 people today are data literate.

Data literacy is the ability to read, work with, analyze, and argue with data


Some of you might argue that 4 in 5 people doesn’t really need to know what alpha value is, and surely, not everybody needs to be a data master, however being able to speak data, would help everyone, everywhere. It might give you and edge now but surely it will be vital in the future.


But, let’s focus in the Enterprise, what if we turn our heads to the people making business decisions? Should they be data literate?


A new research shows only 24% of business decision makers, from junior managers to the C-suite, feel fully confident in their ability to read, work with, analyze and argue with that data.


We have a problem


If only 24% of business decision makers can speak data, then it means we have a problem. But don’t worry, we have a plan. Qlik is on a mission to solve this important skills gap, by empowering everyone with the ability to properly use data.




We can help to fix it, and it’s free!


Qlik is offering free courses that everyone can benefit from – regardless of their role, skill level, or even the BI tools they use – designed to help people and organizations understand, analyze and use data with confidence.


Qlik’s learning program, is a product agnostic training package, designed to help anyone to read, work, analyze and argue with data.





Get started now by taking the FREE Data Literacy Skills Assessment it's a fun 15-minute questionnaire that will tell you where you are in data literacy and what next steps you should take. Then progress to the self-paced learning modules and finally complete the program by taking the free certification exam.


Some reading about the topic: https://blog.qlik.com/posts/topics/data-literacy-topic/

Data Literacy Program | Qlik

Qlik | Data Literacy Campaign



I hope you find it interesting,


Arturo (@arturoqv)

Arturo Muñoz

Qlik Sense URL "hacks"

Posted by Arturo Muñoz Aug 24, 2018

A few weeks ago, Francis wrote a piece here about the (formerly) secret developer menu accessible via URL, Developer menu is a great finding but is not the only one URL hack available. These are some of the URL “hacks” I use:




More info here: Developer menu in Qlik Sense client




Adding /language/key will change the client language for that tab session. Remember you can always check the available client languages by checking Dev Hub






/theme/theme name


Likewise, you could change the theme of an app by specifying the theme name in the URL.  Also remember you can check the available themes in Dev Hub.


https://localhost:4848/app/app_id/sheet/sheet_id/state/analysis/theme/qdt theme




By specifying an identity id you can create selection realms. For example, you could have 2 different tabs open in the same browser as:





Selections performed under “identity 1” won’t impact on the tab session “identity 2”, alternatively you could share selections in different browsers by using the same identity in each one of them.




Adding /ttl/ and a number representing seconds will override the settings of session-expiry time in the server, setting it up to the number specified in seconds. For example, adding 1800 will set the expiration time for the session to 30 minutes.




As a general disclaimer, please note that anything that isn't documented or officially supported is subject to change in the future. Handle it with care.


Arturo (@arturoqv)

The Picasso.js is an open-source initiative by Qlik. It's a charting library that is designed for building custom, interactive, component-based powerful visualizations.


Until recently, the power of Picasso.js was only reserved for developers. A few weeks ago, our colleague Steven Pressland introduced the beta version of the Picasso Designer Extension, a game changer that takes Picasso.js to the masses making it available for everyone in Qlik Sense.

Picasso Designer for Qlik Sense is an extension to aid building complex charts based on the Picasso.js library without having to write any code or understand the Picasso JSON structure. The extension also provides support for selections against the chart for the expected user experience in Qlik Sense.