17 June 2022
Whether you’re a new Qlik user, or a total pro, there’s always more you can learn about the business analytics platform, and how to make it work best for you. Qlik is a robust solution, with plenty of underrated capabilities, which means that even veteran users of the platform might not know about all of its features and functions.
Recently, we embarked on a mission to see if there were any secret Qlik functions, tips, or tricks that might elevate the way users work with the tool. We searched our communities, scoured the Vizlib offices, and took a deep dive into the online Qlik-o-sphere to find the top hidden Qlik functions that make working with Qlik easier, and more productive than ever.
When sharing a Qlik Sense app, it’s important that you share the right information with the right people. Row and level security (aka Section Access) is the process of dynamically reducing the data within a Qlik application. Said simply: this functionality allows you to give certain people access to the information they need to know and prevent others from seeing it.
This tip comes in handy for teams that operate across different territories or demographics. For example, in Higher Education, it’s common for recruiters to target students and schools across separate geographical areas. With Section Access, each recruiter only sees the data from their area.
This function might seem pretty straightforward, but it pays dividends for the teams who use it by making their apps easier to navigate, therefore ensuring a more straightforward experience.
Set analysis allows you to specify a window of data to analyse in Qlik (like data occurring between two specific dates, for example). By segregating data in this way, you can more easily and effectively analyse it. If you haven’t used set analysis yet, this video provides a great introduction to the function.
As a function, set analysis is useful as-is, but it becomes even more powerful when you use variables instead of hard-coded Field Values (sometimes called Set Values). Using variables allows you to more easily manipulate your data sets across dashboard measures. This is because changes made to your variable(s) will apply to all of your dashboard measures, automatically. Much like “alternative measurements” on graphs, variables can – for example – allow users to select which unit of measurement their data is displayed in on a given table.
This particular tool is a slightly more advanced function, but once you’ve mastered it, you’ll open a world of data exploration possibilities.
Do you have end-users who want to see a large amount of data in real-time? Then you should consider using Dynamic Views. It’s a form of On-demand App Generation (ODAG) – a template app built from a predefined set of dashboards that users can interact with and manipulate.
What makes Dynamic Views slightly different from a standard ODAG is the amount of data required to build the template app in the first instance. With Dynamic Views, you only need to extract the minimum set of data required for the end-user. This is possible as end-users will be interacting with this data alongside their workflow application, which provides the additional context they need to understand the data and gain meaningful insight.
Dynamic Views is a fave among Qlik experts. Check out these more detailed tutorials – here and here – to understand even more about how it can become your best friend.
And for a quick but in-depth video tutorial on this topic, check out this video from the Qlik Community.
This isn’t really a “hidden” function, per se, but it’s one that’s too valuable to leave off this list. (Tip: You can change properties all at once in both Qlik Sense and QlikView, and it’s easy to do in both tools!)
Instead of changing the properties of objects with common dimensions one-by-one, this functionality allows you to change them all at once. Basically, once objects are assigned to a Master Item in Qlik Sense (by simply dragging and dropping an object into your “Master Items” library), or linked in QlikView (as simple as right-click >> Paste sheet object as a link), changing the properties of one object changes the properties for all other objects.
This tip is particularly handy when you’re working with the same object(s) in different sheets. A good example is list boxes with identical fields, like countries or states. When you change one item in a linked list box, all other linked objects update automatically.
You’ll save hours of time, and ensure a cleaner, more error-free dashboard by using this tip.
If you want to learn about this functionality in-depth, the Qlik community has more info on exactly how to do this in Qlik Sense, here. And check out this article for more information about how to link objects in QlikView.
Becoming a Qlik pro is even easier and more effective when your team has access to the tools and capabilities that enhance the functionalities already available through Qlik Sense.
With Vizlib, team members are introduced to a range of products expertly and specially designed to enhance their Qlik Sense experience, making it easier to use, and increasing productivity across the organisation. For example, with Vizlib Library, users can build compelling, attractive dashboards in a no-code solution, making for an even smoother and more enjoyable creation experience. And with Vizlib Self-Service, your team will become more empowered than ever before to extract data insights quickly and easily, without ever writing a single line of code.
And the best part about Vizlib’s suite of products is that they’re ready-to-use from the moment you sign up. Your team can begin using them alongside Qlik Sense immediately, supporting data literacy at all levels of business and driving more impactful, more effortless use of Qlik.
Vizlib’s feature-rich data visualisation products will help you get started on your data storytelling journey.
Got a technical question? Our Help Centre has heaps of helpful guides, articles, FAQs and more. Access Help Centre