Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Analytics & AI
Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Data Integration & Quality
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Explore Qlik Gallery
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.
Qlik Community
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Qlik Resources
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik Academic Program
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Recent Blog Posts
-
Techspert Talks - Stitch Migration to Qlik Talend Cloud
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 ins... Show MoreHi 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 Stitch Migration to Qlik Cloud.
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:
- Understanding the schemas
- Demonstration of the migration process
- Best practices and tips for a smooth transition
Click on this link to see the presentation
-
Qlik Gallery Contest, First Poll, & Data Integration Forum Updates
Hello Qlik Community! March is shaping up to be an exciting month! If you haven't seen it yet, we have a fantastic new contest in the Qlik Community. ... Show MoreHello Qlik Community!
March is shaping up to be an exciting month! If you haven't seen it yet, we have a fantastic new contest in the Qlik Community. Share your app in the Qlik Gallery for a chance to snag some awesome Qlik swag! Don’t forget, the deadline to enter is March 28, 2025. For all the details and contest rules, check out the Qlik Gallery.
We’re also thrilled to announce our first poll in the Qlik Community! Swing by the Integration, Extension & APIs forum and share your favorite front-end framework with us.
Lastly, you may have noticed some updates to the navigation structure and naming conventions in the Data Integration & Quality forums this month. As we align more closely with the Qlik and Talend portfolio, these changes are key to keeping our community streamlined and cohesive.
Here are the changes that would made to the Data Integration & Quality forums and navigation:
Renamed:
- ‘Qlik Cloud Data Integration’ is now ‘Data Movement & Streaming’
- ‘Move to Cloud is now ‘Talend Cloud’
- ‘Data Quality, Preparation & Stewardship’ is now ‘Data Quality’
- ‘Data and Metadata Governance’ is now ‘Talend Data Catalog’
Combined:
- ‘Qlik Compose for Data Lakes’ + ‘Qlik Compose for Data Warehouses’ combined and renamed to ‘Qlik Compose’
- ‘Design and Development’ + ‘Deployment’ combined and renamed to ‘Talend Studio’
Moved:
- ‘Application Automation’ is now listed only under ‘Analytics’
- ‘Qlik Enterprise Manager’ posts were moved into ‘Administering and Monitoring’
Archived:
- 掲示板
Before:
After:
Last month, we rolled out some exciting updates to the Analytics forums, and we're continuing the momentum with one more change:
Combined:
- ‘Security & Governance + ‘Deployment & Management’ are now combined as ‘Management & Governance’
Before:
After:
We hope you find these changes helpful as you engage with the Qlik Community! We understand that adjusting to these updates can take some time, and we're here to support you every step of the way. Our moderators are standing by to help facilitate.
We welcome your feedback and questions, whether you’d like to share them here on the blog or in the Water Cooler. Let’s keep the conversation going!
That’s a wrap on the March enhancements! Get ready for more consolidation and enhancements coming your way in April.
Your Qlik Community Admins,
Melissa, Sue, Jamie, Nicole, Tammy and Caleb
@Melissa_Potvin @Sue_Macaluso @Jamie_Gregory @nicole_ulloa @Tammy_Milsom @calebjlee
-
Free Webinar: Navigate Qlik Cloud with Confidence—Fast and Easy
Starting with new technology can feel overwhelming—like trying to navigate a Tokyo map without speaking Japanese. Without the right guidance, even bas... Show More
Starting with new technology can feel overwhelming—like trying to navigate a Tokyo map without speaking Japanese. Without the right guidance, even basic tasks can become frustrating and time-consuming.
At Qlik, we understand this challenge. That’s why we created Qlik Cloud Kickstart, a free, 90-minute onboarding session to help you make your first steps with Qlik Cloud smooth, productive, and impactful.
In this session, you’ll learn:- How to find and navigate your Qlik applications.
- The basics of how Qlik Cloud works.
- How to locate the data you need in seconds.
- How to share insights and collaborate with your team effortlessly.
- Leveraging AI to understand your data faster.
What You’ll Gain:
- Save Time: Get up and running quickly without wasting hours on trial and error.
- Gain Clarity: Understand how Qlik Cloud fits into your workflow.
- Achieve Confidence: Feel empowered to make smarter decisions with reliable data.
This session is designed for professionals like you who need actionable insights and tools to stand out in their roles. And the best part? It’s completely free—with no strings attached.
Ready to Get Started? Take the first step toward mastering Qlik Cloud. Reserve your spot today and unlock the power of your data.
-
CAPEX BI
CAPEX BICOFCO INTL• Real-time tracking: We implemented BI dashboards that provide live updates on actual spending versus budget, allowing for early id... Show MoreCAPEX BICOFCO INTL
• Real-time tracking: We implemented BI dashboards that provide live updates on actual spending versus budget, allowing for early identification of deviations and swift corrective actions. • Enhanced visualization & communication: Using combo charts, gauges, KPIs, filter panes, pivot tables, and more, we created an intuitive interface that simplifies complex financial data and enhances communication across teams. • Data-driven decision-making: Our solution enables stakeholders to compare projected vs. actual CAPEX performance, identify trends, and make informed investment decisions based on data insights.
Discoveries
o User adoption is key—training teams on data literacy and dashboard navigation was crucial for maximizing impact. o Customization matters—tailoring dashboards to user roles improved usability and engagement.
Impact
o Reduced manual reporting efforts by 70%, freeing up finance teams to focus on strategic analysis. o Automated data updates eliminated delays, enabling real-time monitoring and proactive decision-making. o Early identification of budget deviations helped prevent cost overruns, saving approximately 10% in excess expenditure annually.
Audience
The interactive dashboards allow finance, operations, and executives to access the same real-time data, enhancing cross-departmental collaboration
Data and advanced analytics
o Optimized CAPEX allocation led to better investment prioritization, ensuring high-ROI projects get funded first. o Improved forecasting accuracy reduced underutilization of assets, maximizing return on investment.
-
Butterfly Bar Chart
Last week a new presentation option for the bar chart was introduced in Qlik Cloud. The Butterfly presentation format displays two measures that mirro... Show MoreLast week a new presentation option for the bar chart was introduced in Qlik Cloud. The Butterfly presentation format displays two measures that mirror one another along the axis based on a single dimension. In the past, there have been methods used to generate the butterfly chart but now, it is a property option in the bar chart. Below are examples of butterfly charts. In the first example, the butterfly chart is comparing the average salary for men and women by country. In the second example, game stats are being compared for two selected college basketball teams.
Let’s look at how easy it is to create a butterfly chart. In the Human Capital Management example, the butterfly chart is comparing the average salary for men and women by country. The butterfly chart requires one dimension and two measures. In this example, Country is the dimension, and the two measures are as follows:
One measure for women and one measure for men. Both measures in a butterfly chart must return positive values to be displayed. If you are like me and used the old trick of creating butterfly charts by making one of the measures negative, you can simply remove that part of the expression to update your chart. In the app, both measures are master items, and a master color is applied to the measures so that males and females are different colors consistent with the rest of the app. Now, the only thing left to do is change the presentation to butterfly. This can be done from the properties of the bar chart in the Presentation > Styling section.
In both examples, the bar charts are horizontal, with mirroring measures on the y-axis. You also have the option to display the bar chart vertically. In this case, the mirroring measures will be on the x-axis.
Simple, right? As long as there are two items to be compared like male/female or team 1/team 2, a butterfly chart makes a nice alternative to the standard grouped or stacked bar chart. Try it for yourself and learn more at Qlik Help.
Jennell
-
LinkedIn Analytics Dashboard for Personal Profiles
LinkedIn Analytics Dashboard for Personal Profils Evaco GmbH Until now, it was only possible to analyze personal LinkedIn posts directly on Link... Show MoreLinkedIn Analytics Dashboard for Personal ProfilsEvaco GmbHUntil now, it was only possible to analyze personal LinkedIn posts directly on LinkedIn or by exporting the data manually. The LinkedIn Analytics Dashboard for Personal Profiles now offers a centralized solution: it allows unlimited exports to be collected within one app, making it possible to conduct analyses over periods longer than 365 days. In addition to the main dashboard, which displays metrics such as impressions, reached users, followers, and interactions, there are several additional analysis sheets available. These provide detailed insights into engagement, individual posts, and the demographic and temporal distribution of users viewing the content. An impression breakdown by content format is also included.Discoveries
It is now possible to track the long-term development of the reach of LinkedIn posts. With integrated forecasting features, you can also assess whether your goals are being met. Another key advantage: Qlik offers significantly more interactivity and flexibility compared to LinkedIn’s built-in analytics tools.
Impact
The monitoring and performance analysis of LinkedIn posts becomes significantly faster and more comprehensive with the new dashboard. Data can be analyzed efficiently, trends identified early, and posts optimized in a targeted way.
Audience
Perfect for anyone looking to analyze one or more personal LinkedIn accounts – quickly, clearly, and across extended time periods.
Data and advanced analytics
The app makes it possible to analyze LinkedIn data directly within the familiar Data & Analytics platform, using the tools and capabilities you already know.
-
Welcome to our new Educator Ambassador Chee-wai, Ho!
I am pleased to introduce Qlik Academic Program Educator Ambassador for 2025, Chee-wai, Ho from Republic Polytechnic, Singapore. Chee-wai has been act... Show MoreI am pleased to introduce Qlik Academic Program Educator Ambassador for 2025, Chee-wai, Ho from Republic Polytechnic, Singapore.
Chee-wai has been actively involved in upskilling adult learners in data literacy for more than five years in Republic Polytechnic’s Specialist Diploma in Business Analytics (SDBA) in Singapore. According to Chee-wai, “Data literacy in practical translates into identifying and correcting data issues, follow by data visualization to make informed business decisions. This is also the foundation for fruitful predictive and prescriptive analytics.”
In 2023, Chee-wai successfully added Qlik Cloud to supplement the current tool suite used in the SDBA curriculum. Three intakes of SDBA participants have experienced using Qlik Cloud and more are projected to benefit from this valuable addition, ensuring future participants receive the same well-rounded learning experience.
Chee-wai says, “While Qlik Cloud has powerful data wrangling and visualization capabilities, these are not the main draws of using Qlik Cloud for SDBA. Instead, Qlik Cloud provides SDBA participants with a practical introduction of how AI can improve the process of data visualization and analysis. With this as the focus, SDBA participants first experience with Qlik Cloud is through Insight Advisor. While Insight Advisor is not promoted as Gen AI, its output is akin to what Gen AI can produce albeit in the focused realm of discovering existing patterns and relationships within existing data.”
To Chee-wai, this is a strength and not a weakness. He further adds, Insight Advisor serves as an intelligent bridge between Qlik Sense’s comprehensive data ingestion/transformation capabilities and its sophisticated data visualization capabilities. Starting round 2023, there are LLMs touted as being capable of data analysis. Indeed, they do a credible job but only for straightforward data sets. Are they able to seamlessly connect to your corporate data warehouse, navigate a complicated star schema and present insights? What about the data visualizations produced? Can these be weaved into a coherent and aesthetically pleasing presentation easily? Likely in future but not for the time being. Using Insight Advisor, the entire cycle of ingestion and visualization is much more automated, integrated and done at scale. This is what Chee-wai wanted SDBA participants to experience from Qlik Cloud’s Insight Advisor. Having said that, he is aware that there is Qlik Cloud LLM integration. However, this incrementally improves the Qlik Cloud process and does not drive the core engine that produces Qlik Cloud’s output. It remains to be seen whether this will change going forward.
According to Chee-wai, many participants were pleasantly surprised to find that Insight Advisor was as proficient as they were in answering queries directed at a complicated RDBMS data schema. Qlik Cloud’s greatest strength lies in its ability to blend connectivity to disparate data sources at scale, automate visualization and analysis, and easily incorporate these into data stories.
As a Qlik ambassador, Chee-wai hopes to see graph database support in Qlik Cloud to identify less obvious trends and relationships between entities, further enhancing the tool's capabilities. He also hopes that Qlik's academic license will provide access to auto ML, which will significantly enhance the SDBA experience by reducing the effort and cognitive load required to access machine learning in an enterprise setting. He also understands that despite the technical robustness of the Qlik platform, without the support from the Asia Pacific Academic Programme office, the adoption and sustained use of Qlik Cloud could have been challenging for the SDBA participants. For this, he is very grateful for the support and encouragement given.
Looking to 2025 and beyond, Chee-wai sees AI being increasingly commoditized, improving access and ubiquity. Some tasks previously done by specialized, purpose-built models will be handled by GenAI. After all, a foundation model is a vast repository of encoded knowledge, and techniques to tap into this productively (and widely) will continue to improve. There is also the likelihood that several specialized models will be replaced by a single, general but equally capable model.
Away from work, Chee-wai enjoys spending time outdoors hiking mountains in Asia and playing board games that involve strategic thinking. With more automation from AI, he hopes to have even more time (and opportunities) to enjoy these activities.
For more information about the Qlik Academic Program, visit: qlik.com/academicprogram
To know more about the Qlik Academic Program Ambassadors, visit: https://www.qlik.com/us/company/academic-program/ambassadors
-
Qlik Alerting - Security Patch available
Edit 31st of March 2025: Added CVE number. Hello Qlik users, A security issue in a version of Qlik Alerting Windows has been identified. This issue wa... Show MoreEdit 31st of March 2025: Added CVE number.
Hello Qlik users,
A security issue in a version of Qlik Alerting Windows has been identified. This issue was resolved in a later patch, which is already available. Details can be found in the Security Bulletin Critical Security fix for Qlik Alerting (CVE-2025-31509.
- The impacted Qlik Alerting Windows version is July 2023 SR1.
- No workarounds can be provided. Customers should upgrade to Qlik Alerting July 2023 Service Release 2 or higher.
All Qlik software can be downloaded from our official Qlik Download page (customer login required). Follow best practices when upgrading Qlik Alerting.
The information in this post and the Security Bulletin Critical Security fix for Qlik Alerting (CVE-2025-31509 are disclosed in accordance with our published Security and Vulnerability Policy.
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.
Thank you for choosing Qlik,
Qlik Global Support -
My wines
My winesC40 CitiesAnalyzing my wine tastes and ratings just for fun! (And to get hints on what wines to try next).DiscoveriesI can see how my ratings ... Show MoreMy winesC40 CitiesAnalyzing my wine tastes and ratings just for fun! (And to get hints on what wines to try next).Discoveries
I can see how my ratings have become more strict compared to the market average as time has passed.
Impact
Not my business, but this is my grain of sand for the winery industry.
Audience
About every month, or when I want to try something differene
Data and advanced analytics
I make more informed wine purchases and know which wines I would like to go back to.
-
Welcome back Marisa Sánchez: Transforming Data Education with Qlik as Educator A...
We are excited to announce Marisa as a returning Qlik Educator Ambassador for 2025! Marisa continues to make a profound impact at Universidad Nacional... Show MoreWe are excited to announce Marisa as a returning Qlik Educator Ambassador for 2025! Marisa continues to make a profound impact at Universidad Nacional del Sur in Bahía Blanca, Argentina, where she teaches Business Intelligence for the Business Administration bachelor’s degree. Her course equips students with essential skills in data visualization, data mining, and simulation models, preparing them for data-driven decision making in their future careers.
Marisa’s dedication to staying current is unmatched. “Each year we update the course,” she shares. Last year, she revamped the evaluation process, ensuring students are assessed in ways that reflect real-world applications. This year, she’s going even further by introducing Generative Artificial Intelligence (GAI), preparing students to leverage this cutting-edge technology for automation and data augmentation.
“Generative AI opens new possibilities. Unlike predictive AI, GAI uses extensive datasets to generate new content, making it vital for future professionals to master this technology,” Marisa explains. Her foresight ensures her students are prepared for the rapidly evolving digital landscape.
The course’s data visualization curriculum is built on the Qlik Learning Portal, empowering students to create impactful data stories. Additionally, Marisa plans to integrate Qlik’s functionalities into data mining projects, ensuring students gain hands-on experience with industry-leading tools.
To foster a community of data enthusiasts, Marisa organizes an annual seminar on Data Visualization using Qlik, open to students, researchers, and professionals. This event not only showcases the power of Qlik but also creates networking opportunities that bridge academia and industry.
Although the university does not track students’ career progress, Marisa has noticed a remarkable trend: “Many students decide to take more courses on data analytics after graduation because of their experience with Qlik,” she proudly shares. Her teaching doesn’t just educate, it inspires lifelong learning and career growth.
Marisa recognizes the growing challenges of teaching in the digital age. “Teaching is increasingly challenging because of the rapid technological advancements, but it’s rewarding to offer impactful content for students’ professional lives,” she reflects. Her passion for education and innovation drives her to continually enhance her curriculum.
Being a Qlik Educator Ambassador is a source of pride for Marisa. “It is a great honor to be part of the Qlik Academic Program. It allows me to see how other educators use Qlik, get inspired by their achievements, and learn from customer success stories,” she explains. The program has also increased her visibility within the university community, helping her share the benefits of the Qlik Academic Program more widely.
Congratulations, Marisa, on your continued journey as a Qlik Educator Ambassador! Your commitment to innovation and passion for empowering students are truly inspiring.
For more on our Educator Ambassador Program, visit: qlik.com/academic-program/ambassadors
University educators and students can get access to free Qlik software and training resources, qualifications, and certifications by applying to the Academic Program today: qlik.com/academicprogram
-
Welcome Back Angelika Klidas – Qlik Educator Ambassador Class of 2025!
We are thrilled to welcome back Angelika Klidas to the Qlik Educator Ambassador Program for another exciting year! A long-standing and deeply valued m... Show MoreWe are thrilled to welcome back Angelika Klidas to the Qlik Educator Ambassador Program for another exciting year! A long-standing and deeply valued member of our Academic Program, Angelika has been an Educator Ambassador since 2021, and her passion for Qlik and commitment to teaching data literacy continues to inspire students and fellow educators alike.
Angelika is based in the Netherlands and teaches at the University of Applied Sciences in Amsterdam (HVA). She remains the driving force behind the Minor in Data & Analytics, where she seamlessly embeds Qlik into her curriculum. Her mission is clear: to empower students with the tools, knowledge, and confidence they need to find their own path in the ever-evolving data and AI landscape.
In 2024, Angelika focused on developing various trainings through her work with the BDC Academy, an initiative she’ll also be integrating into the Minor this September. Her teaching philosophy continues to reflect her signature motto: “Think big, act small, scale fast”—encouraging her students to start smart and aim high.
Angelika’s impact speaks for itself—nearly 40% of her students are now working in data-related roles, with some even leading IT departments where Qlik plays an integral role. Her classroom is a launchpad for real-world careers, and her students’ success stories are a testament to the practical and inspiring education she provides.
A true data advocate, Angelika believes that Data & AI Literacy is more vital than ever. In her words:
“Analytics is no longer a 'nice to have'—it’s a must. Data strategy, trusted data, and strong governance must be part of every organization’s roadmap. Only then can Data & AI thrive and deliver meaningful insights.”
She continues to challenge her students and organizations and her students to look at AI as a subset (advanced) of Data Literacy, as true AI Literacy requires Data Literacy, therefore it can't be seen as separate areas.
Angelika's dedication goes far beyond the classroom. She recently collaborated with her customer Van Oord on a powerful Qlik app that was spotlighted on the qlik.org platform by Julie Kae. This same project earned Van Oord the Transformation Award at Qlik Connect—a real-world success story that she proudly shares with her students as a source of inspiration and motivation.
In her personal life, Angelika also has a lot to celebrate:
Her eldest daughter was promoted to Sergeant in the Royal Dutch Navy, her son secured an exciting role in airport security at Schiphol, and her youngest just got her driver’s license and is on the verge of graduating from her nursing program. As a proud mom, educator, and mentor, Angelika’s dedication shines through every facet of her life.When asked why she continues to serve as an Educator Ambassador, Angelika answered simply and sincerely:
“I just love the program. It gives my students the opportunity to get excited about Qlik Sense—just like I did—and bring that knowledge into the companies they work for.”
We’re proud to have Angelika as part of our community and look forward to another impactful year of collaboration. Her work continues to bridge academia and industry, building the next generation of data-literate leaders.
For more on our Educator Ambassador Program, visit: qlik.com/academic-program/ambassadors
📢 University educators and students can get access to free Qlik software and training resources, qualifications, and certifications by applying to the Academic Program today:
👉 qlik.com/academicprogram -
Geomap human body
Geomap human bodyPastifício SelmiO gerente da Segurança do Trabalho me pediu para criar um relatório com os acidentes na empresa, e em especial, um gr... Show MoreGeomap human bodyPastifício SelmiO gerente da Segurança do Trabalho me pediu para criar um relatório com os acidentes na empresa, e em especial, um gráfico do corpo humano com os locais das lesões. Foi uma grande experiência e um baita conhecimento adquirido para resolver esse simples gráfico.Discoveries
.
Impact
.
Audience
.
Data and advanced analytics
.
-
【オンデマンド配信】データ分析の魅力を底上げ！映えるダッシュボード作成術
データ分析用に無味乾燥な KPI と表ばかりのダッシュボードを作っていませんか？データ活用やデータ民主化を推進したくても、そんなダッシュボードではユーザーに敬遠されてしまいますよね。 Qlik のビジュアライゼーションはここ最近大きな進化を遂げました。Qlik Sense の最新機能を使えばユーザー... Show More -
Spotify Personal Usage
Spotify Personal UsagePersonalThis Spotify analytics dashboard visualizes my personal streaming data over a year (May 2022-2023), providing insights i... Show MoreSpotify Personal UsagePersonalThis Spotify analytics dashboard visualizes my personal streaming data over a year (May 2022-2023), providing insights into my listening habits. It displays key metrics including total plays, unique songs, artists, along with detailed breakdowns of listening patterns by time of day, favorite tracks, and popular artists. The heatmap reveals when I'm most active on Spotify throughout the week, while the top 10 songs chart and artist word cloud highlight my music preferences. The dashboard serves as a personal music consumption analyzer, allowing me to discover patterns in my listening behavior, identify peak listening times, and recognize my most-played artists and tracks. Its value lies on transforming raw streaming data into visual insights that help me better understand my music consumption habits and discover trends I wouldn't otherwise notice."Discoveries
Key discoveries: 1. Peak listening occurs at 5-7 PM on weekdays, especially Mondays (500+ plays at 8 PM) 2. Daily average of 2:45 hours of music, totaling 1,003 hours for the year 3. Strong song preferences despite accessing 8,482 unique tracks 4. Highest engagement on Mondays and Thursdays, minimal weekend listening 5. Clear artist preferences (Niño Prodigio, Dudu Tassa) among 2,958 artists explored 6. Unexpected night-time listening pattern between 10 PM-12 AM on Thursdays
Impact
This personalized Spotify dashboard has transformed how I understand my music consumption patterns, enabling more intentional listening habits and better playlist curation. By visualizing my listening data, I've optimized my music selection for different activities and times of day, significantly enhancing my overall Spotify experience.
Audience
The Spotify Personal Analytics dashboard is primarily used by me as an individual music enthusiast to track and analyze my listening patterns, though I occasionally share insights with friends who are music aficionados.
Data and advanced analytics
This Spotify dashboard has enhanced my relationship with the platform by providing deeper insights into my listening habits, leading to more intentional engagement and increased usage of premium features.
-
Breaking Change in Qlik Application Automation JIRA blocks (May 1st 2025)
The Qlik Application Automation JIRA blocks List issues, List issues by project and List new and updated issues incrementally, have been updated to th... Show MoreThe Qlik Application Automation JIRA blocks List issues, List issues by project and List new and updated issues incrementally, have been updated to the latest API URL.
The changes come into effect on the 1st of May 2025.
What has changed?
The following changes in the blocks:
Input Parameter changes
List issues block:
- Current (Old) Version: Input parameter "Jql" is optional
- New Version: Input parameter "Jql" is a required parameter
List issues by project:
- Current (Old) Version: Input parameter "Project" is optional
- New Version: Input parameter "Project" is a required parameter
List new and updated issues incrementally:
No changes
Response changes
- Old Response: By default, all navigable fields are returned.
If a list of specific fields should be returned, specify the names of the fields in the "Fields" input parameter.
For an example of the raw response, see the attached .json (JIRA-old-response.json) file. - New Response: By default, the resource returns IDs only.
If a list of specific fields should be returned other than “id”, specify the names of the fields in the "Fields" input parameter.
Example of the response:[
{
"id": "157638"
},
{
"id": "156647"
}
]Example of the response if a user has specified the names of the field (such as "Summary") in the "Fields" input parameter:
[
{
"expand": "",
"fields": {
"summary": "Main order flow broken"
},
"id": "10002",
"key": "ED-1",
"self": "https://your-domain.atlassian.net/rest/api/3/issue/10002"
}
]
How do I prepare for the change?
- Update your automations to use the new updated blocks:
- Select the old block
- Then click Upgrade to latest version
Follow the same steps for all remaining blocks, such as List issues by project and List new and updated issues incrementally.
-
Since the response has been updated, the "Id" field will be returned by default if no fields are specified in the "Fields" input parameter.
After upgrading any of the List issues, List issues by project, and List new and updated issues incrementally blocks, add the relevant fields to the input parameter in the block, which is referenced by other blocks.Additionally, modify the output references in other blocks if necessary. If this is not done, it will result in a null value for the input parameter, causing referenced blocks to fail with the error "Missing mandatory parameter" whenever the input parameter is required.
Example error:
{
"response": {
"status": 400,
"body": {
"errors": [
{
"code": "HTTP-400",
"title": "Invalid Request.",
"detail": "Missing mandatory parameter \"Summary\"."
}
]
}
},
"external error": false
}
If you have any questions, we're happy to assist. Reply to this blog post or take similar queries to the Qlik Application Automation forum.
Thank you for choosing Qlik,
Qlik Support -
Sheet and Object-level Access Control in Qlik Cloud
Hey guys, it's been awhile since we had a guest blogger on, so today I am pleased to introduce you to Daniel Pilla. Daniel is a Master Principal Ana... Show MoreHey guys, it's been awhile since we had a guest blogger on, so today I am pleased to introduce you to Daniel Pilla. Daniel is a Master Principal Analytics Platform Architect at Qlik and is part of the Presales organization. He has been with Qlik for 8 years, and specializes in integration, architecture, embedding, and security. Take it away Dan!
Sheet and object-level access control in Qlik Cloud
This is a relatively common request, especially from customers coming from Qlik Sense Enterprise Client-Managed. The use case is when organizations want to show/hide specific assets in an application based on the group membership of the current user that is accessing the application. Note that this is in no way a strategy or solution for data security (which is handled with section access), but rather serves as a potential design pattern for custom tailoring apps for specific groups of users.
Example Scenario
Let’s assume a customer has a global sales application. That application contains sheets that are designed for specific product group sales that not every sales representative sells. The customer wants to show the product-specific sheets only to the sales representatives that sell those respective products. If the user contains the group “Product Group A” then they should see the “Product Group A Analysis” sheet, and likewise if the user contains the group “Product Group B” then they should contain the “Product Group B Analysis” sheet.
Solution
To achieve this in Qlik Cloud, we can use the Advanced Analytics connector, which in essence is a RESTful server-side extension. This connector offers the ability to connect to RESTful services in real-time from both the load script and from the front-end (charts and expressions). We can use this connector to connect directly to the Qlik Cloud APIs to fetch the groups of the current user, return those groups as a pipe-delimited string, and then use those groups in a show condition expression.
Setup
Prerequisites:
- The Advanced Analytics connector is going to be making API calls to Qlik Cloud on behalf of the logged in user. This means that you must have a user with the “Developer” role assigned as well as an API key issued to that user.
- The Creation of groups setting must be enabled in the Console under Settings > Feature control
- Ensure that there are groups available to the user that you are testing for in the tenant. To check this, you can enter the following into the browser, replacing {tenant} and {region} accordingly: https://{tenant}.{region}.qlikcloud.com/api/users/me -- There, you will find the assignedGroups array which contains the groups that are assigned to the logged in user.
Connector Setup:
- Import the sample application attached to this page.
- Open the application and navigate to the load script.
- Under Data connections, select Create new connection and select Advanced Analytics.
- For URL, fill in your own tenant for URL followed by ‘/api/v1/users’
- https://{tenant}.{region}.qlikcloud.com/api/v1/users
- Change the Method to GET.
- Under Query Parameters, add a parameter with the Name of ‘filter’ and the Value should resemble the following, where {subject} is an existing user subject for the filter so you can test whether the connection is operational:
- {subject co “{subject}”}
- In this example, the user I am using has a REALM value. Note that you will have to escape the backslash with an extra backslash, e.g., QLIK-POC\dpi needs to be QLIK-POC\\dpi
- Within Authorization, change the Authorization Method to Bearer Token.
- Under Token Scheme, select Bearer.
- For Bearer Token, enter in the API key mentioned as a prerequisite above.
- Within Response Table, for Name of Returned Table enter the value of ‘data’. Note that this value is only really relevant for the load script, but the field is required to be populated nonetheless.
- Under Table Path (JMESPath), enter in the value of ‘data’. Note that this is the name of the JSON object containing the data returned from `api/v1/users` and contains source of data that we require from the payload.
- Within Response Fields, deselect Load all available fields. This is so we can customize the value that is returned.
- Within Response Table, under Table Fields (JMESPath), enter a new Name value as ‘groups’, then enter the Value of ‘join(‘|’,assignedGroups[*].name)’. This will concatenate all of the values of the ‘assignedGroups’ array returned by the API into a pipe delimited string. This function is a part of the JMESPath query language that is supported by the Advanced Analytics connector. To learn more, you can refer to: https://jmespath.org/tutorial.html.
- Leave the remaining settings untouched.
- Set the Name of the connection as ‘Get Groups’. Note in this case this is important because the name of the connection is directly referenced in the expression of the accompanying sample app.
- Test the connection and ensure that it is operational.
Sample App Testing:
The sample application includes three sheets:
- Get Current User Groups – this sheet displays the current groups of the logged in user.
- Product Group A Analysis – this sheet has a commented out calculation condition to only show the sheet if the user contains the group ‘Product Group A’.
- Product Group B Analysis – this sheet has a commented out calculation condition to only show the sheet if the user contains the group ‘Product Group B’.
The application transforms the OsUser() result into the subject format, looks up the user, gets the groups, and returns them as a pipe-delimited string. You can find this process defined in the vUserSub and vUserGroups variables.
To test the application, first confirm that the first sheet returns your user groups. If it does, you can modify the sheet calculation conditions on the latter two sheets to your desired group names that you want to show based on.
Modify the expression by uncommenting it and adding in your desired group name (ensured it is enclosed by pipes so as to not partially match another group name):
In my example, I am a member of the group `Product Group A’ and not `Product Group B’, so while in edit mode, I see the following, confirming the ‘Product Group B Analysis’ is hidden from my view:
Exiting edit mode, I now see:
Additional Notes
- If users have edit-level access or greater to the application where this method is deployed, when in “Edit” mode, they will be able to see that the hidden sheet(s) exist. The user could then duplicate that sheet and remove/alter the show condition so that they could see the sheet. This is not a data security risk, as this technique only focuses on cosmetic app design, however it should be noted that if it is desired that the users cannot have access to these sheets then they must not have any roles that allow for edit-level access including “Can manage”, “Can contribute”, and “Can edit”.
- This solution relies on API calls being made by the owner of the API key.
- This user must:
- Continue to be exist
- Continue to have the “Developer” role
- Ensure that the API key does not expire and/or is rotated to prevent downtime
- This user must:
- As this solution is making calls on behalf of a single user as users are leverage the application, there is the potential for rate-limiting at the Users API. The current rate limit of the Users API is 1,000 calls per minute.
- The Advanced Analytics connector function call in the sample app leverages the "ShouldCache":"False" setting in the vUserGroups variable. This ensures that the user’s groups are not cached by the engine, however it makes more calls to the APIs. If you are experiencing or are concerned about rate limiting, this setting can be removed.
-
Knowledge Nuggets - 2025-Q1
Knowledge Nuggets - 2025-Q1Insight ConsultingThis Qlik Sense app curates and provides links to Qlik-related content published since Qlik Connect 2024.... Show MoreKnowledge Nuggets - 2025-Q1Insight ConsultingThis Qlik Sense app curates and provides links to Qlik-related content published since Qlik Connect 2024. Its purpose is to highlight and celebrate contributors from around the world for their valuable contributions to Qlik's body of knowledge. Additionally, it serves as a go-to reference tool for Qlikkies, supporting their continuous learning and professional growth.Discoveries
The app provides insight into the frequency of contributions and subject matter from various content creators
Impact
The app can be used as a reference tool to help Qlik developers to find learning material to support their continuous professional development.
Audience
Can be used by Qlik Developers as well as other stakeholders
Data and advanced analytics
Can be used by Qlik Developers as well as other stakeholders as a reference tool
-
【オンデマンド配信】リニューアル公開！Qlik Sense の基本操作と実践アプリ開発技術を習得
Qlik Sense を初めて操作する方、アプリ開発の基礎から応用を習得したい方向けに、Web セミナーをリニューアル公開しました。最新の操作画面での開発手順や使い方をアップデート機能も含めて解説しています。アプリ開発では、チャート関数や SET 分析を駆使した集計、データ変換を実現するロードスクリ... Show MoreQlik Sense を初めて操作する方、アプリ開発の基礎から応用を習得したい方向けに、Web セミナーをリニューアル公開しました。最新の操作画面での開発手順や使い方をアップデート機能も含めて解説しています。アプリ開発では、チャート関数や SET 分析を駆使した集計、データ変換を実現するロードスクリプトまで、実際のリアルな現場で使える分析アプリの作成を習得できます。
※参加費無料。パソコン・タブレット・スマートフォンで、どこからでもご視聴いただけます。
Qlik Sense 入門 ハンズオン Web セミナーを視聴する -
HITs Analytics
HITs AnalyticsPersonalEvery week, my colleagues participate in a contest where we each choose the best song proposed on a specific topic. In the app, ... Show MoreHITs AnalyticsPersonalEvery week, my colleagues participate in a contest where we each choose the best song proposed on a specific topic. In the app, we manage all the contest's KPIs, progress, and results reports. You can even listen to the songs. It's the highest-rated app.Discoveries
Tracking of the song contest among peers, where the evolution of points, positions, who gives more or less points to whom, who guesses another's song, etc. is managed. You can see from which position each contestant usually bets on to watching the videos of the songs.
Impact
It serves to create cohesion and a greater group atmosphere within the company.
Audience
The app's users are the competition participants and other members of the company following the event.
Data and advanced analytics
Contest tracking data, YouTube access to share and view videos of the songs bet on. Tests have also been conducted with ChatGPT to send the contest history and weekly bets so that users can also place bets on which song belongs to each contestant.
-
Welcome back Daniel O'Leary-Qlik Educator Ambassador for 2025!
Innovations in Course Structure Daniel has integrated Business Intelligence tools more extensively into his curriculum. He has shifted his focus on Q... Show MoreInnovations in Course Structure
Daniel has integrated Business Intelligence tools more extensively into his curriculum. He has shifted his focus on Qlik to his master’s degree class, Advanced Enterprise Systems, effectively doubling the number of students gaining hands-on experience with this software.A significant enhancement to his teaching methodology is the introduction of a group-based term project. Student teams analyze “Open Data” of their choice using Qlik, Power BI, and Tableau. They then create reports showcasing their findings and visualizations, culminating in a class presentation. This hands-on approach strengthens their data analytics capabilities and practical application skills.Career Outcomes for StudentsDaniel proudly notes that at least one of his students secured a job specifically due to their Qlik expertise. This highlights the growing demand for BI tool proficiency in today’s job market.Future Classroom GoalsLooking ahead to 2025, Daniel plans to develop an in-depth case study on the use of analytics in real-world applications. Potential topics include the utilization of Qlik by the United Nations or its role as an audit platform. He aims to conduct interviews with industry professionals to provide a deeper understanding of these use cases.As analytics education evolves, Daniel foresees an increasing integration of analytics within multiple courses, rather than treating it as a standalone subject. He dedicates a third of his Advanced Enterprise Systems course to data and analytics, a trend he expects to expand across disciplines.Professional AchievementsDaniel was recently named the Ernst & Young Professor of Accounting and received a courtesy appointment as Professor of Data Sciences and Operations, further cementing his influence in the field of analytics and education.Reapplying for the Qlik Educator Ambassador ProgramDaniel reapplied to the Qlik Educator Ambassador Program, citing the invaluable insights gained from expert-led lectures. These educator sessions not only enhance his understanding of Qlik but also provide broader analytics insights that he incorporates into his classroom discussions.Professional Recognition and BenefitsHis participation in the program has also bolstered his professional reputation. Announcing his involvement on LinkedIn sparked engagement from industry peers, further solidifying his standing in the data and analytics community.Survey Results: Student Preferences in BI ToolsIn a survey conducted in his Advanced Enterprise Systems course, O’Leary asked students to rank their preferred BI tools after completing assignments in Power BI, Qlik, and Tableau. The results were as follows:-
Qlik: 26 votes
-
Tableau: 18 votes
-
Power BI: 10 votes
These findings suggest that students find Qlik particularly effective, reinforcing its value as an essential tool in analytics education.Daniel O’Leary continues to lead the charge in analytics education, constantly refining his teaching approach to align with industry trends. Whether through hands-on projects, AI integration, or professional collaborations, he remains dedicated to equipping students with the tools they need for success in the evolving world of data analytics. -
