Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Qlik Gallery is meant to encourage Qlikkies everywhere to share their progress – from a first Qlik app – to a favorite Qlik app – and everything in-between.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
On April 16th, 2024, Qlik is launching a highly anticipated capability: custom security roles.
Custom security roles introduce fine control of data export and access permissions within Qlik apps. This allows you to tailor permissions to your specific needs, enhancing data security and compliance.
The first delivery on April 16th includes the capability to control who can export content. Additional capabilities will be added soon after, such as who can create data connections, reports, and similar.
As part of this update, the existing "has restricted view" space role will gain the ability to export data to Excel. This adjustment is in line with Qlik's capacity-based pricing model, ensuring basic users have essential tools.
If you do not wish for users with the "has restricted view" space role to be able to export data, you will need to create a custom role on the release date to maintain the desired restrictions.
Stay tuned for more information and resources leading up to the April 16th launch. We are excited about these enhancements and the value they will bring to your data management and security efforts within Qlik.
Thank you for choosing Qlik,
Qlik Support
In my last blog / video. I showed you how to easily create visual buttons to apply selections and change their visual selection state so they can appear enabled or disabled (selected, not-selected). In this video I'll show you how to setup a filter panel using buttons and the layout container to create a simple collapsible filter panel that is both esthetic and functional while also providing real estate for your dashboard objects.
Resources:
Update 21st of March 16:00 CET: published CVE number
Update 27th of March 10:45 CET: added FAQ
Hello Qlik Users,
A security issue in QlikView has been identified and patches have been made available. Details can be found in the Security Bulletin High Severity Security fix for QlikView (CVE-2024-29863).
Today, 20th of March 2024, we have released two service releases across the latest versions of QlikView to patch the reported issue. All versions of QlikView prior to and including the releases below are impacted:
As no workarounds can be provided, Customers should upgrade QlikView to one of the following versions that contain the fix:
This issue only impacts QlikView. Other Qlik data analytics products including Qlik Cloud and Qlik Sense Enterprise on Windows are not impacted.
The Security Notice label is used to notify customers about security patches and upgrades that require a customer’s action. Please subscribe to the ‘Security Notice’ label to be notified of future updates.
Q: Is the vulnerability present in the QlikView Plugin or other QlikView products?
A: The vulnerability is related to the MSI files on disk.
Q: Will deleting the MSI files mitigate the issue?
A: Qlik does not consider removing the MSI files a complete workaround. A server user can restore them.
When creating Qlik Sense Apps - you can use a Button object and configure a variety of actions or navigation settings to it. One of those actions is the ability to Reload Data for the app you are in. This comes in handy during development, but also can be used where users require new data on demand.
However, when using the Reload Data action - other users may not be able to perform the reload action as they don't have ownership of the app or reload rights to the app / space the app is developed in. Here is an approach when using Qlik Cloud and Qlik Application Automation that can workaround that. This approach will also work for any App Automation that you want any user to execute.
Set analysis is a way to define an aggregation scope different from current selection. Think of it as a way to define a conditional aggregation. The condition – or filter – is written inside the aggregation function. For example, the following will sum the amounts pertaining to 2021:
Sum({<Year={2021}>} Amount)
This syntax however has a couple of drawbacks: First, it is not easy to combine a master measure with different set expressions, since the set expression is hard-coded inside the master measure. Secondly, if you have an expression with multiple aggregations, you need to write the same set expression in every aggregation function.
Therefore, we introduce an additional position for set expressions: They can now be written outside the aggregation function and will then affect all subsequent aggregations. This means that the below expression is allowed:
{<Year={2021}>} Sum(Amount) / Count(distinct Customer)
For master measures, this change will allow a very powerful re-usability: You can now add set expressions to tweak existing master measures:
{<Year={2021}>} [Master Measure]
The outer set expression will affect the entire expression, unless it is enclosed in round brackets. If so, the brackets define the lexical scope. For example, in the following expression, the set expression will only affect the aggregations inside the brackets - the Avg() call will not be affected.
( {<Year={2021}>} Sum(Amount) / Count(distinct Customer) ) – Avg(CustomerSales)
The set expression must be placed in the beginning of the lexical scope.
Aggregation functions that lack set expression, will inherit the context from the outside: In earlier versions the context was always defined by the current selection. Now we have added the possibility of having the context defined by a set expression. So, now “context” means current selection or an outer set expression.
If an aggregation function already contains a set expression, this will be merged with the context. The same merging rules as today will apply:
Examples:
{<OuterSet>} Sum( {<InnerSet>} Field )
The OuterSet will be inherited into the InnerSet, since the inner set lacks set identifier.
{<OuterSet>} Sum( {$<InnerSet>} Field )
The OuterSet will not be inherited into the InnerSet, since the inner set expression contains a set identifier.
The set expression of the outer aggregation will never be inherited into the inner aggregation. But a set expression outside the outer aggregation will be inherited into both.
Examples:
Sum({<Set1>} Aggr(Count({<Set2>} Field )))
The Set1 will not be inherited into Set2.
{<OuterSet>} Sum({<Set1>} Aggr(Count({<Set2>} Field )))
The OuterSet will be inherited into both Set1 and Set2.
Nothing changes for existing set expressions – they will continue to work. But with this additional syntax we hope to simplify your work and your expressions and allow you to re-use your master measures more effectively.
This change affects all Qlik Sense editions from the August 2022 release. It will also be included in the next major QlikView release, planned for late spring 2023.
See more on
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344
HIC
We are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! This application will enable you to answer questions like:
The Entitlement Analyzer app provides insights on:
The Entitlement Analyzer uses a new API Endpoint to fetch all the required data and will store the history in QVD files to enable even better Analytics over time.
A few things to note:
The app as well as the configuration guide are available via GitHub, linked below.
Any issues, questions, and enhancement requests should be opened on the Issues page within the app’s GitHub repository.
Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up to date with the latest Qlik Support announcements. Please give this post a like if you found it helpful!
Kind regards,
Qlik Platform Architects
Additional Resources:
Our other monitoring apps for Qlik Cloud can be found below.
Since we last spoke to Javier for our Academic Program blog he has successfully completed his PHD in data science and is now teaching at 5 universities! Javier is an adjunct professor at Saint Joseph's University, Villanova University, Drexel University, Rowan University and Southern New Hampshire University.
In 2024, Javier aims to leverage his knowledge in data science, business intelligence, analytics, and data visualization to enhance students' professional competencies and readiness. One of his aims as an educator is to bridge the gap between theoretical knowledge and practical application, so that students develop the necessary skills to excel in the data driven business landscape. He is already putting this into practice in his Data visualization class at Drexel University:
“In that class I am having students create projects that leverage the capabilities of Qlik…..My teaching is currently focusing on practical, hands-on projects that mirror real-world business challenges, encouraging students to apply Qlik's powerful analytics and visualization features to derive actionable insights. In one of the projects, the students must identify relevant data sets to tell a story about a movie that they like. To do this, they must ensure that the data they find meets the criteria for quality data. Next, they must tell a story about the movie: how much it grossed, how it performed versus movies in the same year, in the same genre, etc.”
One of Javers significant achievement from the past year has been his role in the creation of an Academy called Bright Future Schools of Professional Development, “we have an entire course dedicated to Qlik’s Essentials. The idea is to help students understand the basics of data visualization with a user-friendly software that will enable them to grow professionally.”
Javier believes that I the most important thing happening on at the moment is the AI revolution, “I think it will significantly reshape the landscape of analytics and higher education. …AI technologies like machine learning and deep learning are augmenting human capabilities by automating routine tasks, providing insights from large datasets, and enhancing decision-making with predictive analytics. And what is most important, we are barely scratching the surface of AI capabilities. We can augment ourselves as professors, students, and professionals with the use of AI.”
Javier believes that AI may revolutionize the way educators teach and students learn, “For instance, AI can personalize learning experiences, adapt to individual learning paces, and provide real-time feedback, thereby enhancing student engagement and outcomes. The demand in higher education is shifting towards graduates who are not only proficient in analytics but also in the application of AI and its subset, machine learning, within analytics.”
Javier decided to apply for his fourth year as an educator ambassador because of the knowledge sharing and networking that the program offers, “It is a great way to be surrounded by excellent professionals who are dedicated and passionate about teaching and helping students achieve their academic and professional goals. Also, to be recognized by Qlik, a leading company in BI, offers credibility in an ever-changing and competitive industry. This in turn, can be used to reach more students and help them in their data literacy journey. Aside from all that, I believe in Qlik’s Mission of getting the most value out of data by revealing hidden patterns and addressing today and tomorrow’s complex challenges in the industry.”
To learn more about the Academic Program go to qlik.com/academicprogram.
Types of accidents most common on Brazilian highways, which highways are the most dangerous and require an action plan to reduce accidents, the times and days with the highest occurrence of accidents.
Mapping the most dangerous highways for a future action plan to reduce accidents, monitoring the most critical times on the roads.
Traffic enforcement agencies, municipalities, and states
Ease of visibility of Brazilian highways and comparison between states and highways.
Update April 18th 2024: As of April 2024, the Twitter Connector will be permanently removed from Qlik Sense SaaS. The removal from Qlik Sense client-managed is scheduled for the August 2024 release, and the removal from the standalone Qlik Web Connector is targeted for fall 2024.
There are currently no plans to introduce a new Twitter Connector, although this was previously the intention.
Twitter has changed the structure for the available API access levels and removed broader access to analytics via Twitter API v1.1. Due to this change, the Qlik Sense connector for Twitter has recently stopped working. The Twitter API v2 is now required, but the current Qlik connector only supports API v1.1.
Additionally, Qlik has managed a common Twitter App for all users’ authentications, which with this change can no longer be used to support the requests made via the connector.
Qlik will introduce a new connector against the Twitter API v2. This new connector will support customer-managed Twitter Apps, allowing you to acquire the API access level specific to your needs and access the analytics data with your own account. Consequently, there will be no API access provided by Qlik.
Unfortunately, this means that the current connector for Twitter will be deprecated, and it will be removed from Qlik Cloud Analytics. It will also be removed from Qlik Sense Enterprise on Windows in the August 2023 release and the standalone Qlik Web Connectors package in December 2023.
You can find detailed information about the Twitter access levels and versions in the Getting started page in the Twitter developer portal. There is also a Step-by-step guide to making your first request to the new Twitter API v2, which explains how to manage and create a Project and connect an App within your Twitter account.
Thanks for choosing Qlik!
Qlik Global Support
This week we would like to introduce Angelika Klidas, who happens to be a returning Educator Ambassador. We are excited to select Angelika as an Ambassador for the 3rd year in a row due to her continued enthusiasm for Qlik’s Academic Program and her efforts in 2023.
Angelika’s journey with Qlik began in 2008 when she started out installing and managing a successful QlikView Competence Center as a team manager of the team for a Governmental Organization in the Netherlands. Since then, she has always been a huge Qlik Advocate in both her day job and her university teaching. Angelika works currently as an Advisor & Trainer and the Business Data Challengers and is responsible for the BDC Academy, sales and account management along with some innovative work! She also teaches Data and Analytics at the University of Applied Sciences in Amsterdam which is her part time role. She is a conceptual thinker who lives by the phrase “think big, act small, and scale fast” which she uses to inspire others to evolve in their use of data and analytics.
In 2022, Angelika began writing a book together with Qlik’s Chief Learning Officer Kevin Hanegan about Data Literacy. The book was formally launched on the 30th of November 2022 and is called “Data Literacy in Practice”. The book is available through Amazon.com and Packt.com.
Angelika applied to become a Educator Ambassador with the Qlik Academic Program as she is passionate about educating students in data analytics and championing the cause of Data & AI Literacy. Due to the change in situation in the field of education, she included new aspects in her teaching style which include setting up training materials “how to use Qlik Sense from an analysis perspective so that students know and understand the full power of Qlik Sense, using AHA Slides (to make the lectures more interactive) and the book “Data Literacy in Practice”. Her book is now also a mandatory book for the University. With the help of the techniques from the book and learning to work with Qlik Sense helps her students not only to analyze the data in a better manner but also how to help organizations form a data strategy, develop organizational KPI’s and build amazing dashboards & reports.
Angelika is proud of the fact that she is the Qlik Academic Program Ambassador and has included the Educator Ambassador badge, mentioned it on her resume and highlights it in her presentations! This year again she is presenting twice at Qlik Connect and is also a Panelist for around the topic ethical handling of data.
In Angelika’s words, “I love the power of grey, love the academic program and the great benefit that it gives to me and my students. My students can pursue their dreams when they would like to work in data and analytics .” She is excited about the fact that some of her students got a job in the data and analytics world, which is amazing! An interesting fact is that since 2008, 34% of her 295 students are working in the field of data and analytics. Her main goal for 2024 is to work on new training materials for Data & AI Literacy in Dutch and English. Angelika has developed several Generative AI trainings that help people (at school and in her commercial work field) to use the Gen AI tools, but also she trains them to question the outcome. Questioning the results, either from insights that we create or the results that we get from the Gen AI tools we use is mega important. Next to that Angelika has developed a “Serious Data Training” where she combines a the first basic concepts of Data & AI Literacy, a Data Escape Room and a session of reflecting on the soft skills that people need during the process of data informed decisions.
Angelika feels that more and more organizations are now emphasizing the importance of Data & AI Literacy. She loves to work with the four pillar system which should be the basis of every organizations journey towards “Active Intelligence” so they will be future ready!
In Angelika’s words, “I love the Qlik Academic Program, it helps the students in gaining analytics knowledge for my students. They can learn at their own pace and look for solutions through the learning platform, but also use the knowledge from the community and demos.qlik.com where they can find all kinds of cool solutions”
We are looking forward to working closely with Angelika during her tenure as an ambassador yet again and creating more links with Universities in the Netherlands.
For more information about our Ambassador Program, please visit: qlik.com/us/company/academic-program/ambassadors
Google's Universal Analytics will stop processing new hits on July 1st 2023 and makes room for Google Analytics 4.
Continue loading your data using Qlik's new GA4 connector, available for Qlik Cloud and Qlik Sense Enterprise on Windows as of today: Google Analytics 4 (Cloud) | Google Analytics 4 (on-premise)
The new Google Analytics 4 connector is also included in the Qlik Web Connector Standalone package: Google Analytics 4 (standalone)
[GA4] Introducing the next generation of Analytics, Google Analytics 4 | support.google
Prepare for the future with Google Analytics 4 | blog.google
Transformational. Innovative. Powerful. These are just a few of the inspiring terms customers use to describe Qlik and our product suite. Customer feedback and input are critical to Qlik’s success, and we regularly hear directly from our most active users through Qlik Nation, our gamified customer engagement hub.
Through interactive challenges and activities, Qlik Nation members connect, learn, and engage with Qlik and with each other. By completing challenges in the platform, members can receive early notification of new product features, boost knowledge through quality educational content, and have opportunities to influence the product roadmap. Qlik Nation also allows customers to demonstrate skills, network with peers, and amplify their personal brand. All while having fun and being rewarded!
And now, Qlik Nation members will be able to complete challenges while visiting Qlik Community. Current members will see a new carousel on the Qlik Community homepage inviting them to complete challenges, making it even easier for you to engage and earn points.
Customers are at the heart of everything we do, and Qlik Nation offers an exclusive experience for our most dedicated and passionate fans (Qlik Nation is a complementary platform to Qlik Community, which has open membership). What do our members say about their experience in Qlik Nation?
If you’re a Qlik end-user and want to learn more about how to join Qlik Nation, please email QlikNation@qlik.com. We’d love to hear from you!
Don't miss our previous Q&A with Qlik! Hear from our panel of experts to help you get the most out of your Qlik experience.
In this blog post, I will cover four Qlik Cloud features that you may not be aware of, but I find to be useful. They are:
The first feature is the option to navigate to a specific chart using button actions and navigation. We have always had the ability to navigate to a specified sheet but now, we can select a chart to highlight. In the Sales Analysis sheet below, there is a View Sales Details button on the bottom left that is used to navigate the user to the Details sheet and highlight the Sales Details table.
To implement this, the actions and navigation properties of the button need to be set to the Details sheet and the chart ID for the Details table, as seen below.
The Chart ID drop down will show all the IDs for charts on the selected sheet. (In this case, the Details sheet). To ensure you are selecting the correct chart, you can check or copy the chart ID by right clicking on the chart, clicking on …, selecting Share from the menu, then selecting Embed from the menu. These steps are illustrated below.
The Embed dialog window below will open and beneath the chart is its object ID. You can copy the object ID and paste it in the properties window for the button or note it and select it from the chart ID drop down list.
In this example, I used the “go to chart” to navigate between sheets but it can also be used on a single sheet. Now, when the user clicks on the View Sales Details button, they are navigated to the Details sheet and the Sales Details table, at the top of the sheet, is highlighted. Notice the blue colored box around it.
The second new feature is the ability to change the opacity of the background color. In the chart below, I have added a background color in the styling properties of the chart. After I select a color for the background, I can use the slider to adjust the opacity, if I choose. In this example, I set it to 60%. By default, it will set to 100% opacity.
The third new feature is the ability to add links to straight tables and pivot tables. Both tables are found in the Visualization bundle.
To add the link is easy. In the properties of the column (see image below), the Field should be the URL you would like for the link. In this example, the link is hard-coded, but you can also use a field value or expression to generate the link. The key to this working is setting Representation to Link (versus Text, which is the default).
The fourth, and last, new feature that I am going to cover in this blog is the new placement of the sheet navigation arrows when the sheet header is hidden. In a previous blog, I discussed how to toggle the sheet header and sheet toolbar. The sheet navigation arrows are in the sheet header as seen below and in the past when the sheet header was hidden, the navigation arrows were not available.
Now, when the sheet header is hidden, the sheet navigation arrows are moved up to the sheet toolbar. A small change, but quite helpful.
Now if you opt to hide the sheet toolbar as well, you may want to consider adding navigation to your sheet.
To wrap it up, this blog covers some small new features that you may find helpful. Users can now navigate to a visualization via button actions, the styling properties have been improved with the ability to set the opacity for a background color, URL links are available in straight and pivot tables and sheet navigation has become a little more flexible. Check out these new features next time you are developing an app.
Thanks,
Jennell
The New Pivot Table can quickly transform rows and columns into actionable insights with just a few clicks. You can organize, analyze, and visualize your data and even style various elements such as headers, borders, fonts, grid lines and more. Say goodbye to manual calculations and hello to dynamic summaries. Pivot Tables,. simplify complexity, reveal patterns, and take control of your information.
Try it now and elevate your data game to new heights.
Qlik Help: Pivot Object
Can't See the video? - Check it out on Qlik's video site
You can analyze visits to your web, views to you instagram profile
You can review impact on your posts.
Marketing people
You can check most visited pages on your web
Qlik Cloud Reporting packaging changes are here!
We’ll be replacing the multiple tiers with simple ‘Small and Large Add-On Packs’, alongside standardized limits for easier management.
Our new Standard, Premium and Enterprise customers using our Capacity Model, will have reporting entitlements included in their package. Customers on our User Based Model will have 1000 reports included and available to them.
All customers can purchase our add-on packages when needed.
See structure below:
Reporting Services | Product Innovation Blog
Reporting from Qlik Cloud Analytics | Qlik Help Page
Tabular Reporting Corporate Blog
Hi everyone,
Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.
The Techspert Talks session from April looked at Migrating Qlik Sense Client-Managed.
But wait, what is it exactly?
Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.
In this session we will cover:
Click on this link to see the presentation.
管理スペースで公開されたアプリケーションに対して、表形式レポートタスクを開発・設定できるようになりました。Microsoft Excel用のQlikアドインは、管理スペース内のアプリケーションに接続できるようになっています。
アプリの「シートヘッダーを表示」をオフにした場合の、シートナビゲーションの位置が変更になりました。
これらの機能強化を利用するためには、Qlik Data Gateway - Data Movement 2023.11.4 以降が必要です。
データ統合で、データセットを構成する基礎となる物理オブジェクトを表示することができるようになりました。また、物理オブジェクトのデータサンプルもみることができるようになりました。フィルタリングで表示範囲を絞ることもできます。SQL変換の結果を直接プレビューすることもできます。
あらかじめ、管理コンソールの「機能コントロール」>「データ統合でデータを表示」をオンにする必要があります。またデータ接続のあるスペースに対して「Can view data」権限が、データプロジェクトがあるスペースに対して「Can view」権限が必要です。
レプリケーション・プロジェクトを設定する際に、ソース・システムで発生した DDL 操作をターゲット・システムと自動的に同期するようにタスクを設定できるようになりました。ターゲットテーブルへのDDL変更の適用は、以下のようなイベントに対して有効にすることができます。
すべてのコネクターを1つの共通インターフェイスに統合しました。ソース、ターゲット、アプリケーションに関係なく、ユーザーは同様の合理化されたインタラクションを利用できます。全てのコネクタの表示と、最近使用されたコネクタの表示を切り替えることができます。
下記の接続が追加されています。
Direct Access gateway 1.6.4 がリリースされました。
新機能
解決された問題