13 July 2022 Picking the right visualizations for your dashboard Share this message Every Friday at Bitmetric we’re posting a new Qlik certification practice question to our LinkedIn company page. Last Friday we asked the following Qlik Data Architect certification practice question about picking the right visualizations for your Qlik Sense dashboard: The correct answer is D: A KPI object, a line chart, a straight table There is always a part of personal preference in creation and design of Qlik apps. However, if we want to follow the given requirements closely, then the right answer needs to contain a straight table. Let’s have a look at all four options and see how they stack up against the given requirements: The revenue of the current year and last year The average margin over the last 12 months The top 10 products with associated details Below you can see each answer visualized in a small dashboard: Now let’s see how well each of these matches the requirements. The revenue of the current year and last year The revenues for the current and previous year ar most clearly visualized in a KPI Object. The request for the revenues of the current year and previous year are most clearly visualized in a KPI Object. It will show the amount of revenue clearly where current year is shown as the primary KPI and the sales of the previous year as the secondary KPI. In this question the requirements are followed to the letter, but we could improve on this by adding a year to date comparison to the object. Comparing the same period in the last year with the same period in the current year will give us a better understanding of how good, or bad, the results are. We could also improve on this visually by using the measure for the revenue last year as limit for the conditional color. This gives a visual representation of whether the revenue of the current year is above or below last year: A green KPI with a plus symbol when the revenue is higher than last year A red colored KPI with a minus symbol when the revenue is lower than last year The pie chart (answer B) representing the revenues of each year only shows how these values are divided between the years. Not very applicable for understanding how much revenue is created. If we apply the same trick and create a YTD overview of the pie chart, while it does create a visual representation of which year currently has the bigger part of the pie, the most important request, the actual revenue, is not visible. The average margin over the last 12 months The next request is to show the average margin of the last 12 months. While technically the gauge shows this measure, there is not much point in showing it like this. The gauge object is meant to fill up to a certain value and show how far along you are, more like a speedometer in a car for example. In this case a measure like average margin is more or less likely to hover around a single value, negating the visual effect of the gauge. Also while the value shown is indeed the average over the last 12 months, there is no clear way to check and know that, the months are not visible after all in a gauge. Using a line chart makes it immediately visible over which months the margin is shown, as well the change over time. In this case while the average is around 11%, we can see that around June, July and August 2021 things have greatly improved the margin going forwards, making it able to analyze what these changes were or whether certain business changes have indeed resulted in the desired effect. The top 10 products with associated details And then finally the chart with most debate. While we agree that for a quick glance management overview Answer C is the best and visually clearest solution. However, the request in the requirements clearly stated that the top 10 products with associated details were to be shown. In this case a straight table will contain those. However we have no doubt in your abilities to find a great solution and convince the business of better solutions. That’s it for this week. See you next Friday? Mail and Deploy webinar Join our upcoming webinar and learn how Mail & Deploy helps you develop and deliver data-driven, high-impact reports from Qlik Cloud, Qlik Sense and QlikView. Test your Qlik knowledge! Check out the Friday Qlik Test Prep archive for Qlik certification questions and answers. Friday Qlik Test Prep Solution Visualization How can we help? Feel free to contact us if you have any comments or questions. Call us Mail us 30 November 2023 Qlik Sense exploited in Cactus ransomware campaign We previously reported on patches for two critical vulnerabilities in Qlik Sense Enterprise for Windows. If you haven’t upgraded already, now is the time to take heed: these vulnerabilities are actively being exploited in the Cactus ransomware campaign. 26 October 2023 TimeXtender Job Scheduling with Qlik Application Automation Unlock the power of Qlik Application Automation to schedule TimeXtender jobs efficiently. Discover automation tips for seamless data workflows. Download the template and boost your productivity today! API Automation Qlik TimeXtender 21 September 2023 Qlik Sense Enterprise for Windows – Critical Security Fix #2 A new security issue in Qlik Sense Enterprise for Windows has been identified. This resolves an incomplete fix for the vulnerability that was reported earlier this month. Patches are available and it is recommended to update your Qlik Sense Enterprise for Windows environment at the earliest possibility. New Release Qlik Security
30 November 2023 Qlik Sense exploited in Cactus ransomware campaign We previously reported on patches for two critical vulnerabilities in Qlik Sense Enterprise for Windows. If you haven’t upgraded already, now is the time to take heed: these vulnerabilities are actively being exploited in the Cactus ransomware campaign.
26 October 2023 TimeXtender Job Scheduling with Qlik Application Automation Unlock the power of Qlik Application Automation to schedule TimeXtender jobs efficiently. Discover automation tips for seamless data workflows. Download the template and boost your productivity today! API Automation Qlik TimeXtender
21 September 2023 Qlik Sense Enterprise for Windows – Critical Security Fix #2 A new security issue in Qlik Sense Enterprise for Windows has been identified. This resolves an incomplete fix for the vulnerability that was reported earlier this month. Patches are available and it is recommended to update your Qlik Sense Enterprise for Windows environment at the earliest possibility. New Release Qlik Security