Qlik: Gartner's Magic Quadrant Leader

Recently Gartner has published the annual report where gives information about conditions of analytic platforms and business analytics, market and its trends. According to the report, Qlik has a dominant position of Gartner’s Magic Quadrant for analytics and BI platforms for 11th consecutive year.

«Qlik – is a leader in this Magic Quadrant. It has a strong product vision for ML and AI-driven augmentation».

Qlik’s strengths and benefits that were signed in the report:

Full report you can download HERE

Gartner Quadrant Leaders for Analytics and BI: Qlik Sense vs Microsoft Power BI vs Tableau

At this moment in time, the responsibility for analytics has shifted from IT staff to business analysts, database administrators, and data scientists. Thus, BI has gone from generating monthly reports from the record system to interactively creating and sharing forecasts and responding to business questions based on data from an extensive range of internal and external data sources. Before, businesses made decisions in a month. Now, thanks to self-service BI, they can take action in just a few days.

The problem is with the abundance of BI platforms available on the market today, it’s not easy to choose one that will suit your business needs perfectly. In this blog post we won’t be talking about tons of different BI tools but focus only on the heavyweights of self-service BI – Qlik Sense, Microsoft’s Power BI, Tableau. We’ll analyze and compare some of their main parameters to help you decide which one will be the most useful for your organization.

Qlik Sense


Qlik is the leading visual analytics platform and the forerunner of user-driven business intelligence. Its portfolio of cloud-based and on-premise solutions meet the growing customers’ demands ranging from reporting and self-service visual analysis to guided, embedded, and custom analytics, regardless of where data is stored. Qlik users gain meaningful insights exploring the hidden relationships within data from multiple sources. A fully integrated cloud platform, Qlik is powered by its unique in-memory associative data indexing (QIX) engine. Qlik’s Associative engine identifies and assembles all your data so you can explore without limits. This is easily the most powerful competitive advantage in a data-driven world.

Intuitive visualization and exploration, advanced analytics, and self-service data preparation abilities allow Qlik Sense to combine enterprise governance and readiness enabling organizations to manage the range of BI use cases from a single platform.

Let’s explore some of the key features of Qlik Sense:

Smart visualizations and analytics


Qlik Sense is not just a visualization tool. It offers advanced and intelligent visualizations that enhance the process of data analysis. The visualizations are interactive, flexible, and adjustable, with the first-rate graphics. There are many great visualizations types available like Distribution chart, Box plot, and Histogram that help users better understand their data. Users can also improve consistency in their application by applying custom coloring filters to data values within the master dimensions.

Conversational analytics and NLP

Thanks to the open API’s, Qlik has integration with the natural language generation & processing, advanced predictive analytics, and augmented intelligence. These capabilities make possible direct data exchange between third-party and QIX engine for calculations. Based on this interface, Qlik has released integrations for R and Python as well. As a result, users can visualize advanced calculations from external tools within Qlik Sense. But what’s more, Qlik users can combine the power of Qlik’s associative model with advanced analytics to support use cases like- sales forecasting, inventory management, and fraud detection.

Data storytelling and reporting

Data storytelling is one of the most powerful and unique features of Qlik Sense. It gives intelligent and in-context commentary on the data analytics visuals. The software creates the entire data story that puts things into perspective and paints a picture that will be presented for the analysis. It’s very helpful for drawing actionable insights from the data. The apps created in Qlik Sense in the form of reports can be printed or exported in Excel, PowerPoint, PDF, or other formats.


Qlik Sense was created with the mobility feature in mind. With its native touch interaction and responsive design, it allows you to explore analytics and collaborate with your team using any device. Moreover, you can experience fully interactive offline analysis on iOS, and it also supports leading Enterprise Mobility Management (EMM) platforms.

Scalability and governance

Qlik provides enterprise-class management services that guarantee data safety, control, monitoring, and centralized management. The centralized data monitoring and management are done via the Qlik Management Console (QMC) which controls all the Qlik Sense services centrally. Scalability is another crucial aspect. Elastic scaling in Qlik Sense helps to load and analyze a large amount of data.

Qlik Data Catalyst (QDC) and Attunity

Today’s hyper-competitive environment, where real-time enterprise data is indispensable to success, calls for a more agile approach to analytics and data integration. Qlik fuses Attunity’s data integration solutions with the data management and cataloging solutions of Qlik Data Catalyst and offers users an enterprise data integration platform to convert their raw data into a governed, analytics-driven information resource. This platform encourages the movement of data in real-time across multiple cloud environments and data lakes. When combined with predictive analytics and AI, it scales real-time insights throughout an entire organization.

Qlik Insight Bot (QIB)

Qlik Insight Bot offers a fast and simple way to ask questions and discover insights to make data-driven decisions just by having a conversation. With each question, the Qlik Insight Bot engages users and instantly brings up relevant charts and insights, including key drivers, comparisons, predictions, and more. Its self-learning AI makes the system progressively smarter.

Microsoft Power BI


Microsoft released its data visualization tool to the general public in 2015 under the name Power BI. 4 years later Gartner recognized Microsoft as a leader in “2019 Gartner Magic Quadrant for Analytics and Business Intelligence Platform” due to Power BI’s capabilities. Presently, Microsoft offers Power BI as a part of the Office 365 suit which contributes to its popularity even more.

It’s easy to understand why equally small and big business analysts adore this tool. Business users who have comprehensive knowledge of Excel intuitively understand Power BI. The same goes for technical users who are likely to adopt Microsoft Office stack. In terms of building and display, Power BI is a nice tool that offers visual data discovery and data preparation along with interactive dashboards and augmented analytics.

You can choose between Power BI Reporting Server (PBRS) option or a SaaS option in the Azure cloud in Power BI Report Server. It’s user-friendly and doesn’t require much time to create and share reports. The cloud option doesn’t entail infrastructure support but if you plan to deploy it on-premise, naturally you’ll need support no matter the size of your organization.

Now let’s take a look at some of the prominent features of Power BI that have made it a leader in Gartner’s BI Quadrant.

Appealing visualizations and robust data modeling


One of the main features of Power BI is the ability to personalize information dashboards according to your business needs. You can easily embed BI reports and create an interactive in-depth analysis for powerful data storytelling that will inspire your business users to embark on their data discovery journey. There are in-built visuals and custom visualizations created by the community available. After deciding on perfect visualization, you can get down to drill-ups and drill-downs.

As for data modeling, Power BI has a query editor. It’s an integrated ETL tool that allows you to work with data from numerous data sources to build effective data models. It is powered by a Data engine that can deal with complex enterprise use cases. In addition, Python and R that are integrated with Power BI open the door for advanced analytics, visualization, and data mining.

Smooth integration with applications

Regardless of your Microsoft product being deployed in cloud or on-premise, the integration with Power BI is smooth. It integrates flawlessly with legacy as well as modern enterprise applications and perfectly visualizes available data. Power BI has different in-built connectors that easily connect and join multiple on-cloud, on-premise, and streaming data sources to use it for data preparation. Furthermore, it supports integration with Cortana, Excel, and many other applications and services.

Fresh insights with DAX

DAX (data analysis expressions) is a collection of functions and operators, that can be used for data analysis and calculations. Microsoft developed this functional language to interact with data in Power BI, PowerPivot, and SSAS Tabular. Although for some DAX concepts may seem simple, DAX itself is quite powerful. With it, data analysts can create new measures and obtain unique insights into data through exclusive visualizations.

Promising product roadmap ahead

Since Microsoft’s Power BI is a relatively new product on the BI market, it can be improved even more. Even now, new features and enhancements are available every month. Microsoft monitors users’ requests about the features and prioritizes those that are in high demand. Regarding licenses, Power BI has several – Power BI Desktop (free), Power BI Pro, and Power BI Premium. There are also many Power BI communities that help users find solutions and suggestions to a variety of problems.



Founded in 2003, Tableau is an enterprise-scale business analytics platform with self-service capabilities. Tableau’s dashboards present organizations with an interactive interface that comes with a depth of colors, visualization options, and a robust analytics engine. Users can combine large data sources and access them instantly without the need to rely on their IT team. You can securely access Tableau through native applications even on Android and iOS.

Tableau’s popularity is accounted for by easy deployment, support, and usability. It’s a tool focused primarily on data visualization so if that’s what you’re looking for, then Tableau may be your pick. Let’s take a moment to consider what it has to offer.

In-depth insights


With Tableau, organizations can analyze data even without any particular goal in mind. This method of exploring and visualizing data from different angles may lead to sudden useful realizations and insights. You can frame ‘what if’ queries and operate data hypothetically visualizing it in different and dynamic ways by adding components for comparison and analysis.

Engage different data sources

While analyzing, you can pull data from many sources like cloud, spreadsheets, data warehouses, etc. Tableau’s data blending feature will help you blend all the data in the visuals while keeping them apart at the source. This method simultaneously accelerates the process of combining data from multiple sources and negates the need for priming data before processing it for the visuals.

Real-time data analysis

Data is changing fast so it’s important to keep your dashboards always updated. Tableau gives you the ability to make live connections with the database. When there are new entries or changes in the database, you can refresh in Tableau and see all the changes reflect on your dashboard. It’s also possible to set specific time intervals for the data to refresh. This will help you draw valuable insights in real-time.

Drag-and-drop clustering

This may be the most powerful feature of Tableau since it allows you to combine similar group members. “How is it helpful?’, you may ask. With grouping, you get statistical information that will help you see similarities between different groups as well as compare their performance for segmentation analysis.

Tableau Online

Tableau Online is a fully hosted cloud solution that offers immediate setup and efficient scalability for enhancing business growth. It’s a platform where you can publish and share your discoveries with other people. You can invite customers or teammates to further explore hidden opportunities using interactive visualizations and accurate data.


By and large, all these tools work following different principles. Qlik Sense is more than a visualization tool. It has a strong and unique ETL engine and connectors that can connect you to any kind of source system. Power BI is a fantastic asset for quick insights, great user experience, and collaboration within your company. Lastly, if you want a simple interface and beautiful visualizations, Tableau might be your preferred choice. Usually, discussions may come more around commercials or individual preferences, but if it is an end-to-end BI and you don’t have anything for your ETL or Data Warehouse, then Qlik may be a better fit.

Qlik makes cloud analytics more accessible to every customer

Qlik announced new packaging and adoption programs that will give customers more options and make cloud-based analytics simpler and more cost-effective to adapt. These programs comprise new packaging of Qlik Sense Enterprise with SaaS only as well as Client-Managed options. Additionally, QlikView customers can easily adopt Qlik Sense Enterprise SaaS and host their QlikView documents in the cloud at the same time.

James Fisher, the Chief Product Officer of Qlik stated, “Customers are eager to leverage the scale and cost efficiencies of analytics in the cloud, and at the same time leverage augmented and actionable analytics to turn insights into action.” He added that with their latest Qlik Sense offering and new Analytics Modernization Program “it’s easier than ever for every Qlik customer to adopt and leverage cloud-based analytics and benefit from new AI and cognitive technologies across their entire organization.”

In the second quarter of 2020, Qlik customers will be able to coordinate the deployment of Qlik analytics with their IT strategies more effectively via two options, SaaS or Client-Managed. Those who choose Qlik Sense Enterprise SaaS will reduce management issues and minimize infrastructure costs by deploying exclusively in Qlik’s cloud. Meanwhile, customers who go for Qlik Sense Enterprise Client-Managed can deploy either on-premise or in a private cloud depending on their governance or data requirements. They can also license both and make the most of Qlik’s unique multi-cloud architecture.

Qlik’s Analytics Modernization Program will further provide QlikView customers with expanded flexibility and choice. It allows them to adopt Qlik Sense steadily, at their own pace without disruption to existing QlikView operations.

Steph Robinson, Qlik Manager Business Intelligence IT at JBS USA said, “We’re excited about the growing adoption of analytics we’re seeing in our employee base with Qlik Sense”. He noted they continue to leverage QlikView apps that have been already created but also give their developers an opportunity to adopt Qlik Sense at their own pace. “Being able to leverage our existing QlikView apps, while also extending analytics capabilities through Qlik Sense, has accelerated our journey to modern BI and is helping our organization become more data-driven”.

The Analytics Modernization Program opens up the following possibilities for QlikView users:

Doug Henschen, VP and Principal Analyst at Constellation Research pointed out, “As organizations increasingly migrate applications and data to the cloud, they look to maximize the value of that data to drive strategic advantage.” He continued saying that “by providing these new options to move analytical workloads to the cloud as quickly and easily as possible, Qlik is responding to growing customer expectations and where we see the industry headed.”

Other exciting developments Qlik Sense customers should look forward to are various new features in the April Qlik Sense release that will help them broaden analytics adoption through the cloud. Among new elements, there will be new visualization and dashboarding enhancements, the ability to share charts, notifications within the management console, and improved data file management and data connections for data flow into individual Qlik Sense workflows.

Qlik becomes a part of Snowflake Partner Connect Program

This week Qlik partnered with Snowflake, a cloud data warehouse. The partnership involves Qlik’s integration with the Snowflake Partner Connect program which will provide Snowflake customers with a two-week free trial to fully experience Qlik’s first-class data integration software. The free trial comprises tutorials for swiftly ingesting and delivering data in real-time to Snowflake. Extension of the trial enables users to export data from numerous popular enterprise database systems, mainframes and SAP applications. With Qlik Data Integration platform, it’s also possible to automate the creation and updates of analytics-ready data sets in Snowflake.

“Our customers want to accelerate their modernization efforts by utilizing highly performant and robust solutions to replicate data into Snowflake,” stated Colleen Kapase, Snowflake VP of WW Partners and Alliances. “With Qlik’s real-time data integration capabilities, customers will realize an immediate benefit to easily bringing that data directly into Snowflake. We are excited about Qlik joining our partner connect program, bringing new capabilities for customers to modernize to Snowflake.”

Snowflake Partner Connect empowers new users to effortlessly connect with and integrate specific Snowflake business partners straight into their experience when creating trial accounts. With Qlik Data Integration, customers can access a wide selection of enterprise data sources in real-time and gain the most value during a Snowflake evaluation. After completion of the trial, there is an easy way to purchase the full license of Qlik Data Integration.

“Snowflake gives us a scalable data lake environment, bringing data together in one location from any source. This enhances decision making across all our varied business functions, including manufacturing, supply chain, customer service, and financing,” affirmed Dallas Thornton, Director of Digital Services at PACCAR. “Qlik’s data integration software is a huge driver in the value we see with Snowflake. Since it streams disparate data sources using change data capture into Snowflake from any platform – be it cloud, x86 databases, mainframes, or AS400 – our users now have one environment in Snowflake from which to analyze data in near real-time.”

“We’re excited to expand our partnership with Snowflake by joining their partner connect program, helping enterprises accelerate their journey to cloud data warehousing,” proclaimed Itamar Ankorion, SVP Technology Alliances at Qlik. “Qlik has a complete solution for Snowflake that continuously ingests all targeted data, automates the warehouse/mart creation without scripting, and makes data and insights readily accessible across the organization with world-class analytics.”

About Qlik

Qlik’s vision is a data-literate world, one where everyone can use data to improve decision-making and solve their most challenging problems. Only Qlik offers end-to-end, real-time data integration and analytics solutions that help organizations access and transform all their data into value. Qlik helps companies lead with data to see more deeply into customer behavior, reinvent business processes, discover new revenue streams, and balance risk and reward. Qlik does business in more than 100 countries and serves over 50,000 customers around the world.

Qlik became a Gartner Magic Quadrant leader for the 10th year in a row!

Yesterday Qlik announced they had been named a Gartner’s Magic Quadrant Leader for Analytics and BI Platforms for 10th year in a row. This recognition marks not only a decade of Qlik’s continuous leadership in the quadrant but also inclusion in Gartner’s MQ since 2006.

“Qlik is helping customers accelerate business value through data, providing a full range of capabilities to go from raw data to real-time insights and action,” said Mike Capone, CEO of Qlik. “Our company continues to grow profitably, and our strong performance has enabled us to invest in delivering an end-to-end platform that includes data integration, AI-driven insights, and conversational analytics. With our recent acquisition of RoxAI we are providing automated intelligent alerting for real-time decision making as we continue to invest in capabilities that increase data’s value for every organization.”

The report, which Gartner releases annually in February, provides an unbiased evaluation of analytics and business intelligence (ABI) platforms, analyses the market and highlights its biggest trends. This time, an appraisal of the platforms is no longer based on their data visualization capabilities since those are becoming mainstream. Instead, the focus is shifting towards integrated support for enterprise reporting capabilities and augmented analytics.

“Machine learning (ML) and artificial intelligence (AI)-assisted data preparation, insight generation, and insight explanation — to augment how business people and analysts explore and analyze data — are fast becoming key sources of competitive differentiation, and therefore core investments, for vendors.” – Gartner, 2020

Gartner lists the following strengths of Qlik:

“Empowering employees with the right information and the confidence to make decisions with it is vital,” said Director of Business Intelligence, Visualization and Reporting at Nationwide Building Society. “Qlik has proven to be fantastic in helping to consolidate disparate data, break down internal silos and drive value. By making data more visible and intuitive, business teams have gained new insights across many processes, increasing efficiency and fostering a data-enabled culture.”

You can download a copy of the full report here.

Qlik's Statement of Direction 2020: Exciting developments from Qlik that are waiting for us in 2020 and beyond

As we’re stepping into a new decade, Qlik releases their Statement of Direction which provides an exciting overview of Qlik’s product direction and forthcoming offers. We encapsulated this fascinating read into 15 sentences that should hype you up for using the Qlik Analytics Platform in 2020 and beyond.

Qlik Sense

  1. New capabilities for customers to add business logic to the Qlik Cognitive Engine, and new sources for machine learning – including governed libraries, the analytics ecosystem and external, domain specific sources.
  2. New types of augmented analysis which include key driver analysis, statistical, predictive and prescriptive insights as well a new extension for multi-attribute (cohort) analysis.
  3. Improvements for advanced analytics integration performance, augmented data stories and content recommendations.
  4. New visualization, analytics and authoring capabilities that include moving averages, difference functions, time-based forecasting, trend indicators in tables and sparklines.
  5. Introduction of grid and bullet charts.
  6. Dynamic views, a new capability enabling in-memory database views for products such as Snowflake, SAP HANA and more.
  7. Check out / check in functionality for app objects supporting team-based development.
  8. New self-service reporting that will support authoring, scheduling and personalized distribution.
  9. A new user experience for insight management that will allow people to capture, organize, share and take action on the most relevant insights – including charts, AI-generated insights, snapshots, reports, stories and more.
  10. Annotations and discussion threads, content following and social BI in a multi-cloud hub, an insight library with tasks, goals and approvals, and workflow automation through the platform.

Qlik Sense Mobile

  1. Automatic downloads of updated offline apps and support for offline mashups.

Qlik Insight Bot

  1. Integration with the Qlik Cognitive Engine, allowing for enhanced natural language capabilities surfaced in visual and conversational user experiences.

Qlik NPrinting

  1. Integration of report distribution capabilities directly into Qlik Sense.


  1. Common scheduling with Qlik Sense

Qlik Connectors

  1. Configurable REST connectivity with Azure Data Lake, updates to Essbase connectivity, integrated connectivity to new data sources such as Amazon Athena, and expanded support for SAP HANA.

If you’d like to read Qlik’s Statement of Direction 2020, you can find it here.


The Statement of Direction 2020 suggests that from now on Qlik will be focusing on integration. They’ve acquired many great additions such as RoxAI and their Ping solution to build up a multidimensional platform, but unfortunately it lacks integration. That’s why it’s so amazing to see Qlik working on this issue while also advancing the field of analytics and expanding their platform with new additions that soon will combine into a powerful unit.

BARC named Qlik a BI industry leader

The BARC annual report showed that Qlik continues to maintain and gain leadership in many categories.

Each year, BARC experts prepare reports reviewing prominent software. For BI programs users, the analysis of such solutions is the most authoritative and extensive. As before, Qlik solutions have been named one of the best.

Out of 36 products produced by large BI providers, QlikSense is among the leaders in 24 categories and is the front-runner in the other two. Some of these categories include the following:

QlikView takes a leading position in 13 categories and is the number one in the other three. Some of the categories are listed below:

About BARC

BARC (The Business Application Research Center) is an analytical and consulting company that specializes in business applications, specifically, solutions for business analysis, data management, CRM and ERP.

Twenty years of experience in doing researches and creating reports allowed the company to gain deep knowledge of BI software and its suppliers as well as develop the ability to recognize the latest trends in the market.

Handy tips and tricks for Qlik

Qlik is one of the leading providers of business intelligence and data visualization solutions on the global market. More than 48,000 organizations use QlikView and Qlik Sense products – an impressive figure, but one that makes you think.

How many users from all these companies are really able to get the most out of QlikView and Qlik Sense capabilities?

We have prepared a few tips and tricks that will optimize your work when designing and developing applications based on QlikView and Qlik Sense. In general, they apply to both products, but some are only for QlikView. This will be indicated in each section. A number of tricks are exclusively technical, others will come in handy when creating any objects.

This article will be useful for a beginner, while a versed developer can test their knowledge.

1. Commenting in the script

Comments in scripts allow other people to understand what is going on. This does not mean you need to comment on each process. It is enough to add a comment where you encounter any difficulty or find an alternative solution that needs clarification. Comments are also convenient if you need to return to the code that you did a month or even several years ago and quickly parse it.

Leaving a comment on a line does not require much effort – just add // at the beginning or use the shortcut Ctrl + K + C. To uncomment a line, press Ctrl + K + U.

2. Take advantage of the script editor

If you do not want to run a part of the script for one reason or another (for example, it creates problems in the application), you can comment out it.

To do this, select text in QlikView and right-click. In the context menu, select “Comment” or “Uncomment”.

In Qlik Sense, you need to select the text, and then click on the comment icon.

To comment out the entire section of the script, place the appropriate markers at the beginning and at the end of the section:

/ * marks the beginning of a commented section.

* / marks the end of the commented section.

It looks like this:

Additionally, to make the code readable, you can align the selected lines of the script using the Tab key or the Shift + Tab combination.

3. Write code faster

Macros will help speed up work in the QlikView script editor. To get hints for them, use the combination Ctrl + Q, S, C (CTRL + Qlikview ShortCut) while in the editor. It will open a window with all the keyboard shortcuts.

4. Backus-Naur uniform

The syntax of the QlikView command line and scripts are described in a notation called Backus-Naur Form (BNF). It is one of the metalanguages ​​used to describe programming languages ​​in order to standardize them. Defining a clear language structure is very important for it to be correctly converted to machine language during script execution.

To see the BNF code syntax, in the QlikView script editor, press CTRL + Q + B + N + F.

5. Plan your escape

If you have a complex script that needs to be debugged at some point, don’t panic.

A great way to take control of this process is to create a tab with the “EXIT SCRIPT” command. Moving it among other tabs, you choose exactly when you want to complete the script.

After debugging, be sure to remove the tab.

6. Get rid of everything you no longer need

Temporary objects must exist temporarily. That is why after carrying out the necessary calculations and transformations, temporary tables or fields must be deleted.

Thus, not only do you free up memory, but also avoid synthetic keys and loops, which negatively affect the data model and disrupt the display of data in dashboards.

To prevent such problems, develop two habits.

First, check all the messages that you receive after the completion of the script. They may contain information about the existence of circular references, which must be eliminated in time.

Secondly, upon the outcome of data loading, verify using the system fields that the loaded tables do not contain temporary keys. If they are found, remove them immediately.

Having developed this routine, you will ensure there won’t be any unpleasant “surprises” in the future.

7. Limit the load

If you need to debug a table with a lot of rows or containing complex joins, you do not need to load all the records.

After launching debugging mode on the quick access panel, you can specify in the opened window the number of records you want to download. The First prefix to the LOAD statement solves this problem as well.

This can also be done in Qlik Sense, as shown below:

8. Usefulness of the third ApplyMap parameter

Mapping tables greatly simplify the life of the developer when working with scripts in QlikView and Qlik Sense. With their help, you can find a single value in another table and replace the field values ​​during script execution without loading unnecessary data.

Using the third parameter of the ApplyMap function, you can find values ​​that you may have missed. The function returns them if they were not found in the table.

For example, try ApplyMap (‘MyMappingTable’, LookUpField, ‘No match’).

Look for the value “No match” or “NA” in this field to identify gaps in the matched data.

9. Guaranteed error detection

When working with include files, using the $(Include) command is not worthwhile, because if the include file is not found, you will not receive an error message.

In this case, it is better to use $ (Must_Include), which is guaranteed to cause an error message if the include file is not found.

10. Table Viewer / Data Models Viewer is your indispensable helper.

We have already mentioned that by using system fields you can detect temporary tables and circular references. You will achieve the same result using the Table Viewer function.

Moreover, Table Viewer in QlikView and Data Model Viewer in Qlik Sense are especially helpful when you add tables or make changes to the links between them.

These tools will help find incorrect joins, synthetic keys, and randomly created island tables before they cause data inconsistencies.

11. If is not always the best solution.

Having diagrams and table expressions that contain a huge amount of data, it is better to refrain from using the if statement. If () processes data line-by-line, which as a result may slow down your applications.

In this case, Set Analysis will help achieve better performance. The ability to use it is essential for effective work in QlikView and Qlik Sense, since set analysis is one of the foundations for creating dashboards. It will facilitate your work if you need to compare different time periods or create selections that are different from the general data set.

12. Detect locked files

In the case of an odd QlikView reload, when you know for sure the script does not cause this problem, pay attention to the QVD files and logs.

Under some circumstances, one of these files can be locked. As a result, you see an error in the LOAD statement, as well as when you try to reboot the system.

In this situation, close all instances of QlikView Desktop and try launching it again.

13. A sudden reboot? No problems!

For everyone who spends a lot of time creating a good project, it’s a huge tragedy to lose it due to some error in the application. Fortunately, QlikView has a useful option that allows you to save a document before reloading.

Thanks to it, you do not need to worry about the safety of your report, when one small error leads to big troubles in the script.

14. No need for data

In QlikView and Qlik Sense it’s possible to launch a recently opened application without data.

This will come in handy when your application holds a large amount of data or you inadvertently created a monster with poor joins.

To do this, in QlikView, click on the “Home Page”, then on “Recently Opened Documents” and, having selected the desired document from the list, right-click and select “Open without data”.

In Qlik Sense, you just need to right-click on the application in the hub and select “Open without data.”

15. Saving data from temporary tables

Sometimes we rely on temporary tables to process the data again or store them separately before they are combined. Of course, at the end of the script, they are gone.

Debugging problems in such tables may seem difficult, but there is a solution. You can store them into a QVD file using the STORE command. This way you can save all data after a reboot. Then you can view QVD files with EasyQlik QViewer.

16. Scaffolding

When working with new data, try using the QUALIFY * command at the beginning of the script when loading tables from the source. This will keep the tables separated until you decide which key fields are needed.

Presenting data in the form of table blocks greatly simplifies the initial stage of work. After that, you can easily move on to charts and straight or pivot tables.

Some experts call this method “scaffolding” – the frame (table blocks) disappears as soon as a permanent structure takes shape.

17. Unified calendar

QlikView and Qlik Sense developers often deal with certain dates in the application (financial periods, time ranges, and much more). To organize the workflow and avoid confusion, use the master calendar.

Make it a rule to attach the data in the application to one calendar, avoiding multiple data selections. Otherwise, you run the risk of confusing the user and complicating your work while maintaining separation.

Speaking about the organization of work …

18. Store information in one place

We often must work with data from different systems. Naturally, each system has a fact table incorporating dates and a series of dimensions.

To steer clear of potential chaos in the QlikView and Qlik Sense associative models, gather all the data in one table. This will help simplify joins and generally works efficiently.

Important! Before combining, make sure that the aggregated fields have different names so that the data does not suddenly mix.

19. Copy the colors …

Another convenient option in QlikView is ability to copy color from any source. This also applies to copying colors from an expression where they are selected using logic.

You just need to right-click on the color field and select “Copy.” Having decided on your destination, select “Paste All” and you’re done!

20. … and even expressions!

In QlikView, among other things, you can copy expressions from one object to another. Moreover, you are not just copying text, but all formatting, including colors, text formatting, etc.

As before, use the right click to copy and paste as the need arises.

21. Gone! Or not?..

While we’re on the subject of QlikView, it’s worth mentioning the developer can use the “conditional show” feature to hide certain objects and sheets until they need to be displayed.

Very convenient, but if you make a mistake in the logical condition, you can say goodbye to them.

In this case, do not despair. To restore them, follow these steps for the sheets:

Document Properties> Sheets

To restore objects:

Sheet Properties> Objects

22. Qlik Community as a platform for collaborative problem solving

Faced with a problem in QlikView or Qlik Sense, look for a solution on the Qlik forum. Surely you are not the first to go through this. If not, you can ask a question and people will gladly help you.

In addition, do not forget about the similarity of the scripting language and functions in QlikView and Qlik Sense. Solutions for each of them are useful in most cases.

Qlik: Using data to your advantage

“No matter how big or small your business is or how competitive the industry is, choosing the right analytical tool is essential for the company’s success and vitality. It’s all about data nowadays”, says Denys Smakovskyi, Founder & CEO at DataLabs.

For quite some time, it’s been common knowledge that information can be used as an asset. However, recently organizations began considering information as a means of getting ahead of the game. With the growing trend of digital transformation, data and analytics naturally turn into strategic priorities that are crucial for accelerating digitization.

“This is why business intelligence (BI) is on everyone’s lips”, continues Denys. “It guarantees your business can access the cleanest and most comprehensible data anytime, anywhere. But most importantly, you can transfer such data to the customers enabling them to reach optimal decisions fast.”

These days there are so many BI tools, it may be disorienting to choose the one that suits your needs. Fortunately, Gartner’s Magic Quadrant evaluates trends in BI market as well as strength and weaknesses of its vendors each year so that you can choose your tool wisely.

We asked Denys Smakovskyi to share his knowledge about Qlik , one of the leaders in the quadrant for 9 consecutive years.

What, in your opinion, makes Qlik a leader in the quadrant for almost a decade?

It’s rather simple. Their stated mission is to create a data-literate world where people can use data to make meaningful discoveries that bring about actual changes. So, they continuously put in maximum effort to produce solutions that are user-friendly and exploration driven. They’re always looking for innovative ways to deal with business challenges.

Plus, they allow their customers to choose whether they want to install Qlik tools on-premises or in the cloud. This kind of freedom is what draws people in.

How do these environments compare? Does the cloud-based environment have an advantage over the on-premises one? 

Both options have their advantages. Qlik Sense in the cloud is more flexible. It allows users to store and manage their applications without the need to worry about the maintenance of the infrastructure or the on-premises equipment. You only pay a provider for the resources you use. It’s cost and time effective for small and medium companies, which is the key to improving business agility and scalability.

On the other hand, customers have Qlik Sense and QlikView on-premises implementation, deploying resources in-house and within their IT-infrastructure. As a result, the enterprise gets full control of their data. It’s an option for medium and large businesses, and those who take security very seriously. Additionally, it allows advanced customization of your dashboards.

Speaking of dashboards: is it possible to share them with other people in Qlik Sense in the cloud?

Businesses can use Qlik Sense Cloud solution which is accessible through a web client on any device. Users can upload all the necessary information via a simple drag & drop interface, create applications and interactive dashboards, and share them with their colleagues. Furthermore, they can easily embed interactive dashboards either into a website or within any app.

Qlik introduced Qlik Sense Cloud licenses for businesses of all sizes that offer more storage, larger app sizes, and wider sharing, but Qlik Sense Cloud Basic is a freemium service. You just have to log in or register, if you don’t have a Qlik account, and start working right away.

Can business users participate in data preparation as well?   

Up until recently, data consolidation and preparation were way over non-tech savvy user’s head. The process required engineers and data analysts’ skills to organize data for business users. It still holds true for QlikView where in order to manipulate data, one should know how to work with scripts.

On the other hand, there is Qlik Sense where advanced data preparation is also possible, but business users have a say in the matter as well. In contrast to QlikView, Qlik Sense is a visualization-driven tool used for creating powerful dashboards. And it uses the same visual approach for data preparation with data profiling features to load data sets.

Qlik has something that other BI tools don’t, namely the Associative engine that keeps all data at hand no matter what dimensions of data the user explores. That’s why business users can make the most out of available to them functions collecting, shaping and cleansing their data. Qlik’s considerably simplifies these processes and makes data blending more flexible and intuitive to boot.

As a result, making actionable insights and reaching the right decisions becomes easier and, above all, more effective.

To wrap it up, what, in your opinion, lies ahead for Qlik? Will they still be a Gartner Quadrant’s leader ten years from now? 

I can’t predict that far ahead, but I think if they stay true to their mission, it’s quite possible. What makes Qlik so successful is their drive to improve and create more possibilities for business users to take full advantage of their data.

They started with creating QlikView, which evolved into an efficient reporting solution, and followed through with powerful dashboarding solution Qlik Sense as well as many other products. Their great input into the BI industry is indisputable, and it’s exciting to look forward to what they’ll introduce next.

How we were mentors

DataLabs establishes connections with future programmers!

The philosophy of our company is to find a perspective while looking into the future. Therefore, we are well aware of the importance of contact with children who already dream of their professional development in the field of innovative technologies. After all, they will conquer new peaks!

Our acquaintance with the future IT guru started at Lyceum of Information Technologies, Dnipro. Our experts helped students to develop their certification course and introduced the basics of programming Qlik® products. For modern young people, wise mentors and self-belief are extremely important. We sincerely hope that our cooperation has strengthened the interest in the world of information technology of high school students and inspired them to make new achievements.

Here are the impressions left by some students:

“My certification work allowed me to understand the operation of accounting system, to understand the new program, new programming language. It was important to have the opportunity to ask professionals questions about issues I had. They were very attentive, patient, helpful in finding and correcting mistakes. We have received all the necessary information for the successful completion of the task. We were only required to be attentive, diligent and apply the knowledge practically. I’m really grateful for this highly topical program.”  Polina (grade 11)

“I think I was very fortunate to participate in this project as it gave me an opportunity to get experience in adapting to different development environments, technology, tasks. We got acquainted with SQL and its variations, QlikView, databases, visualization methods of information. It was a pleasant surprise that with the help of a program the documentation was written in two evenings. It was also interesting to look behind the scenes of the workflow of a large enterprise.”  Vladimir (grade 10)

We plan to expand our collaboration programs with educational institutions as we understand how important it is to stay a socially active company in the 21st century. It is likely that new Elon Masks are now sitting at the school desks! And we want to help find their voice!

GoUp Chat