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
-
Qlik Management Console: Integration
Another blog entry, and another section of the Qlik Management Console. Today we will be going over the third section of QMC known as Integration. API... Show MoreAnother blog entry, and another section of the Qlik Management Console. Today we will be going over the third section of QMC known as Integration.
API Keys
Within this section a tenant admin can manage APIs. API keys are used by developers to gain programmatic access to the Qlik platform, acting as their own user. Admins can edit the settings for the keys as well as revoke the keys. Please note that only users with the ‘Developer’ role can generate or delete these keys. In order for someone with an ‘Admin’ status to generate or delete keys, they must assign themselves the ‘Developer’ role.
Content Security Policy
This section displays the origins and the directives of the Content Security Policy HTTP header. Here origins can be added for specific resource types to allow resources to be loaded. This section also allows users to not only add these origins and directives, but once loaded, they can be edited and deleted as well.
OAuth
This section shows the OAuth clients that are used for authentication. OAuth is a standard security protocol that allows third party applications to access API resourced without disclosing the end-user credentials. This means that OAuth allows clients to use a code, instead of their log-in credentials for added security, protecting that information.
Web
Qlik Cloud allows third-party domains to interact with your Qlik tenant. Here you can view the Name, ID, Number of Origins, Updates and Creation dates of these connections. You can also edit and delete these connections once they are added to the tenant.
Webhooks
Webhooks allows Qlik Cloud to send information about events in your tenant to other applications. In this section, the name of the Webhook, along with the Owner, Status, Level, Creator and Updater can be viewed. Users can also view the Endpoint URL, or the destination of these events in this section. This section also allows users to delete a Webhook.
That would be it for the fourth section of the Qlik Management Console: Integration. Thank you for giving this blog post a read, and if you see any information missing, feel free to drop it in a comment below. Join us next time where we’ll take a look at the fourth and final section: Configuration.
-
Help us test a new tool
Hello Qlik Community! For the month of October, we have been on a development freeze which is why we have been quiet. With the rollout of the new navi... Show MoreHello Qlik Community!
For the month of October, we have been on a development freeze which is why we have been quiet. With the rollout of the new navigation, we wanted to make sure everything was stable and work out any kinks that popped up.
Naturally, we couldn’t make it the entire month without pushing out something new. We were close though! 😊
We are piloting a new engagement tool and want your feedback. The goal is to keep you engaged and informed about what’s happening within Qlik Community and Qlik as a whole. It will also give you the opportunity to earn more badges!
In the next couple of days, you may see this on the right hand side of your screen:
THIS IS EXPECTED! Please do not be alarmed 😊
You will need to click the “Login With Qlik” button and your credentials will pass through. You should only need to complete this step once (please tell us in comments if that is not the case for you)
Our initial goal is twofold:
- Offer improvements to the onboarding experience for new members by targeting rank = new member with a link to the 'getting started' guide
- Offer improvements to the onboarding experience for newly registered Partners by targeting rank = partner with a link to the new partner area.Our intention is to start slowly. In fact, after the login, you may not even see anything else for some time.
Tune in next month for another update on our progress.
As always, we welcome your feedback (But please abide by Community Do's and Don'ts when delivering feedback)!
Your Qlik Community Admins,
Melissa, Sue, Jamie, Nicole and Emma
@Melissa_Potvin @Sue_Macaluso @Jamie_Gregory @nicole_ulloa @emmaspickerman
-
Communicating data by storytelling
When you hear the term “data analysis,” what do you think of? Your mind may jump to scouring spreadsheets, implementing algorithms, and making mathema... Show MoreWhen you hear the term “data analysis,” what do you think of? Your mind may jump to scouring spreadsheets, implementing algorithms, and making mathematical calculations—all “hard skills” of data analysis. Yet, hard skills are useless without their soft skill counterparts. It’s not enough to just analyze data; you need to know how to communicate the story it tells in a clear, compelling manner—a skill called data storytelling.
So, WHAT IS DATA STORYTELLING?
Data storytelling is the ability to effectively communicate insights from a dataset using narratives and visualizations. It can be used to put data insights into context for and inspire action from your audience.
To know more about data storytelling and how to craft a compelling data narrative, read this wonderful article by Catherine Cote from HBS Online: https://online.hbs.edu/blog/post/data-storytelling#:~:text=What%20Is%20Data%20Storytelling%3F,inspire%20action%20from%20your%20audience.
If you are a student or educator, and wish to learn data analytics, check out Qlik's amazing academic program resources: qlik.com/academicprogram
-
Academic Program Translations are live!
The Qlik Learning Portal which offers QCC training has completed its translations which are now live! The portal now offers training in 15 languages!... Show MoreThe Qlik Learning Portal which offers QCC training has completed its translations which are now live! The portal now offers training in 15 languages! The training includes ALL of the resources you receive as a member of the Qlik Academic Program member! We hope that you return to your resources and take advantage of the training that may have once been challenging due to language barriers.
For the full blog and explanation about these changes visit the Education Blog Post - Translations
To access your resources as an Academic Program member, visit the QCC - Academic Program, login and select your language and get started!
If you no longer have access to these resource you can reapply as an educator or student by visiting the website, https://www.qlik.com/us/company/academic-program
-
The intelligent responsive design
Sometimes it’s the small details that make a very big difference. Intelligent responsive design is completely integrated in Qlik Sense; it seems so br... Show MoreSometimes it’s the small details that make a very big difference. Intelligent responsive design is completely integrated in Qlik Sense; it seems so brilliant to me that I don’t want it to go unnoticed for you.
Responsive web design (RWD) is an approach to web design aimed at crafting sites to provide an optimal viewing experience—easy reading and navigation with a minimum of resizing, panning, and scrolling—across a wide range of devices (from desktop computer monitors to mobile phones).
A site designed with RWD adapts the layout to the viewing environment by using fluid, proportion-based grids, flexible images (…)
Qlik Sense has taken it one step further than the RWD described above, by adding responsive intelligence into the objects themselves.
Intelligent responsive design is not just adjusting the layout to make objects and charts to fit nicely into your device’s screen, but it’s a product smart enough to know when to switch between summary and detailed information based on the available real estate. Qlik Sense is automatically adjusting and tweaking each individual object and chart to give us the right visualization anywhere, optimizing the entire user experience for the device being used.
Let’s review some of my favorite examples of intelligent responsive design in Qlik Sense:
This scatter chart is displaying Product group Sales Amount vs Margin. As soon as I fine-tuned some basic chart properties, Qlik Sense will do the rest, maximizing the information displayed based on the available real estate. It’s a fluid chart.
As you will notice in the scatter chart above not all the labels are visible, Qlik Sense is adjusting the amount of information to increase user comprehension.
The same chart displayed in a smaller device introduces some changes; first, we notice that even fewer labels are being displayed so we can easily see the patterns and correlation. Second, the x-axis’ scale is a bit wider to avoid adding noise into the chart.
Within the chart shown above, the same visualization is in yet another size while the form factor is adapted to the available real estate. Elements such as dot size, dot labels and axis are scaled again. In this smaller version of the chart, the axis labels and the home icon have been removed automatically and font size has been adjusted.
Line thickness is adjusted in line charts and a scrolling mini-charts appears when needed.
Pie chart labels and values only appear if enough space.
Qlik Sense has adapted these charts, rescaling the level of detail and functionality to maximize the user experience; this is not just resizing, but intelligent responsive design.
Enjoy Qliking!
AMZ
---
PS: I’ve had to force Qlik Sense to let me do a pie chart like that; by default Qlik Sense is preventing me to commit the crime. I do not recommend a rainbow pie chart to represent that data, a bar chart or a treemap would've been more effective… but if you still want to do it, do it in style.
-
Qlik now offers Multitenant Provisioning in Qlik Cloud for our OEM and ISV partn...
Can't see the video? Visit our Qlik Video Page to see this video.Qlik now offers multitenant provisioning in Qlik Cloud for our OEM and ISV partners M... Show MoreCan't see the video? Visit our Qlik Video Page to see this video.
Qlik now offers multitenant provisioning in Qlik Cloud for our OEM and ISV partners
Multitenant provisioning provides our OEM and ISV partners with a deployment model that fits their deployment patterns with each end customer receiving their own tenant. Using multiple tenants logically separates end customers, removing any potential data security issue and, importantly, allowing end customers to use all features in Qlik Cloud.
Multitenant Provisioning for our OEM and ISV partners addresses the following use cases for an OEM partner:
- Creation of a new tenant
- Configuration of a tenant
- Hydration and updates of a tenant
As the preferred cloud deployment pattern, a multitenant approach allows our partners to provision tenants in a low cost, quick and efficient manner with API-supported automations. CTO Tim Burke, at ISV partner Arch Systems, mentioned during his participation in Qlik’s Early Access Program, “One of the things we’ve been excited about collaborating with Qlik on is increased levels of automation for multitenant scenarios like ours…we’re exploring some of the more advanced Qlik APIs they have…allowing us to increase even further our levels of automation around deploying a Qlik app, especially an update to all of our individual customers.”
With this deployment model, our partners will realize the following:
- Faster deployments and time to market for their solutions using public, documented APIs and organizational credentials
- Reduced cost and complexity for maintenance, upgrades, infrastructure and security
- Fewer product walls and custom security requirements
These benefits will improve our OEM and ISV partners’ total cost of ownership, ease the journey to Qlik Cloud and provide immediate access to best in class analytics with a full range of augmented capabilities.
Additionally, our existing Qlik Cloud monitoring apps now support multitenancy. Data spanning multiple tenants will be able to be collected and viewed from a single parent tenant. An ISV partner can now see metrics and information from all of their Qlik Cloud tenants within a single dashboard, which will be made available in the near future as the ‘OEM Dashboard’. This new capability is entirely additive to our existing monitoring apps. This capability can be toggled on or off, allowing both OEM partners (and enterprise customers) to use the same monitoring apps.
To learn more about Qlik’s approach to multitenant provisioning, please watch the following introductory video https://youtu.be/xDhqFTgaBLU
For OEM and ISV partners, our approach will ease your journey to Qlik Cloud with onboarding capabilities that can be integrated into your own onboarding flows so that your customers receive our full platform experience from point of purchase.
Qlik Cloud APIs support provisioning automations and further extend data analytics in an OEM’s solutions downstream – faster, easier time to market, less manual overhead, flexibility to integrate analytics provisioning as an OEM prefers.
We encourage you to learn more about our multitenant approach through the resources below:
- Introductory Blog
- Register and watch the OEM Tech Town Hall here
- Qlik platform operations overview at qlik.dev (live week of October 24th)
This capability can be toggled on or off, allowing both OEM partners (and enterprise customers) to use the same monitoring apps - learn more
We’re here to help you with your journey to Qlik Cloud. Please find additional information on multitenant provisioning in our Partner FAQ.
-
Omnia - Client Profitability
Omnia - Client Profitability HSBC Omnia is the Wholesale Client Reporting Platform in HSBC, providing a complete view of client performance, an... Show MoreOmnia - Client ProfitabilityHSBC
Omnia is the Wholesale Client Reporting Platform in HSBC, providing a complete view of client performance, analysis and insights. Omnia includes finance actuals, client plan, deal pipeline and activity reporting accessed through an interactive, intuitive and consistent user experience. The application suite is utilised by 10,000 users across the Wholesale Frontline, Product, Finance and Senior Executive groups.Omnia utilises a Qlik backend, and a custom React front end to create highly bespoke Mashups
Discoveries
Omnia has brought together large data sets across the HSBC Wholesale estate, building a re-useable data asset thats used both within Qlik Sense and outside in other workflow/reporting systems. Utilising Qlik's associative engine, the data has been spliced with a complex entitlements model to restrict data access to only whats required in a users portfolio
Impact
Delivering a one stop shop across the Wholesale frontline for its analytics capabilities. Omnia provides access to granular profitability tro thousands of users, leveraging a custom platform.
Audience
Front line staff including Relationship Managers, Global Bankers, Product Sales, Country/Sector/Product heads, Finance, Business Management, and Senior Executives
Data and advanced analytics
Providing data to the business that was previously unavailable. Joining large quantities of data (billions of rows) into a highly performant data model, with sub 10second response times on even the most complex of visualisations. Analytics capabiltiies include, deep dives, trend analysis, transaction intelligence and ESG insights.
-
Qlik Replicate May 2022 Service Release and Qlik Catalog August 2022 Client-Mana...
Qlik Replicate The Qlik Replicate May 2022 Service Release release is one of two scheduled service releases that Qlik distributes each year. In addit... Show MoreQlik Replicate
The Qlik Replicate May 2022 Service Release release is one of two scheduled service releases that Qlik distributes each year. In addition to bug fixes, we’ve made a number of improvements related to our most popular cloud-based targets:
Databricks
Qlik now supports all-purpose clusters and SQL Warehouses in Databricks
- As part of our close partnership with Databricks and their lake house strategy, this release provides a low-friction method to ingest data into Databricks lake house delta tables on any cloud provider in real-time.
- We’ve also added support for Databricks SQL Warehouse compute, which often comes at a reduced cost for enterprise customers who have Databricks, while providing equivalent performance with Databricks Photon engine.
Continuing support of all-purpose clusters will help organizations planning to migrate to Databricks SQL Warehouse. Organizations on a lower Databricks tier, where SQL Warehouse is not available, can continue to leverage real-time ingestion with Qlik Replicate.
AWS PrivateLink
- We’ve added support for AWS PrivateLink which will help improve secure connections for larger AWS environments. This release supports S3 endpoints and other targets will be added in later releases.
Parquet file format supported across clouds
- The Parquet format is now supported for both ADLS GEN2 and Google Cloud Storage. This builds upon our support for the Parquet format within S3 in an earlier release.
Qlik Catalog
In addition to bug fixes, the Qlik Catalog August 2022 release gives customers more control over how they want to configure LDAP usernames. Qlik Catalog August 2022 also adds support for recent releases of Tomcat, Postgres & Ubuntu so customers can take advantage of new capabilities within these solutions.
We hope you enjoy trying out the new releases and would love to hear your feedback and success stories, especially in the improvement gains.
As always, if you would like to try out this release, go to the Qlik Downloads Site, filter for “Qlik Data Integration”, and then select the product and version you would like to download.
-
Qlik Continuous Classroom Translations are LIVE!
Qlik Education is pleased to announce that machine translations will be available all users on the Qlik Learning Portal starting October 17, 2022. The... Show MoreQlik Education is pleased to announce that machine translations will be available all users on the Qlik Learning Portal starting October 17, 2022. These translations are automatically provided using API calls to Google, without any human intervention.
We offer translations in 14 languages to our customers as a convenience to their learning experience and with awareness of its limitations. The translations are primarily focused in the Qlik Continuous Classroom, self-paced learning video's closed captions (not audio) and Qlik Learning Portal pages. See Machine Translation Updates Page for an exhaustive list.
To engage machine translations to translate the text to a different language, select a language from the language Dropdown:
After launching a video from a course page, select CC from the tools to display the closed captions with machine translations:
Additional Notes:
- Limitations mentioned above include inconsistency in Google translations across various languages, and they should not be considered perfect translations.
- See Machine Translation Updates Page for known issues and improvements we are working on.
- For consistency across the in-app experience, other languages and other platforms using this solution, there are words which we have chosen not to translate. These words generally include product names, technical Qlik-specific terminology, user roles, syntax language, etc.
We appreciate your patience and feedback as we work to improve your learning experience. Please provide feedback within any self-paced course.
Access Qlik Learning Portal and check out the Machine Translations!
-
Use Case Reference Architecture - #5: Event-Driven Reference Architecture - Kapp...
The architecture comprises the following components:Data is ingested in real-time using change data capture for real-time data replication without imp... Show MoreThe architecture comprises the following components:
Data is ingested in real-time using change data capture for real-time data replication without impairing production system performance.
Analytics is used to discover, interpret, and communicate meaningful patterns in data to apply toward effective decision-making.
Monitor data ingestion tasks with a single pane of glass view.
Orchestrate data ingestion tasks based on pre-set conditions or calculations.
APIs to automate and integrate with other monitoring and orchestration applications.
Event-Driven Architecture - Kappa
-
Qlik Use Case Reference Architecture - #4: Event-Driven Reference Architecture -...
The architecture comprises the following components:Data is ingested in real-time using change data capture for real-time data replication without imp... Show MoreThe architecture comprises the following components:
Data is ingested in real-time using change data capture for real-time data replication without impairing production system performance.
Batch / Incremental Load is used for historical data with fault-tolerant, distributed storage, ensuring a low possibility of errors even if the system crashes.
Analytics is used to discover, interpret, and communicate meaningful patterns in data to apply toward effective decision-making.
Monitor data ingestion tasks with a single pane of glass view.
Orchestrate data ingestion tasks based on pre-set conditions or calculations.
APIs to automate and integrate with other monitoring and orchestration applications.
-
Use Case Reference Architecture - #3: Data Lakehouse Reference Architecture
The architecture comprises the following components:Data is ingested from transactional systems with low latency. Change data capture for real-time da... Show MoreThe architecture comprises the following components:
Data is ingested from transactional systems with low latency. Change data capture for real-time data replication ingests data without impairing production system performance.
Data Warehouse Automation accelerates the availability of analytics-ready data by automating the entire data warehouse lifecycle.
Data Lake Automation powers the process of providing continuously updated, accurate, and trusted data sets for business analytics.
Custom Transformation allows users to create flexible, fit-for-purpose data pipelines to transform raw data into data that is ready for analytics.
Data Profiling enables users to assess the quality and structure of data sources to fix data quality issues and promote good data governance.
Machine Learning enriches data with prediction, scoring, classification, and more.
Catalog & Lineage capabilities empower users to discover, govern, and protect data using AI and machine learning built on a layer of common enterprise metadata.
Analytics is used to discover, interpret, and communicate meaningful patterns in data to apply toward effective decision making
Reverse ETL replicates enriched data from the warehouse back to the operational systems of record.
-
Use Case Reference Architecture - #2: Data Lake Reference Architecture
The architecture comprises the following components:Data is ingested from transactional systems with low latency. Change data capture for real-time da... Show MoreThe architecture comprises the following components:
Data is ingested from transactional systems with low latency. Change data capture for real-time data replication ingests data without impairing production system performance.
Data Lake Automation powers the process of providing continuously updated, accurate, and trusted data sets for business analytics.
Custom Transformation allows users to create flexible, fit-for-purpose data pipelines to transform raw data into data that is ready for analytics.
Data Profiling enables users to assess the quality and structure of data sources to fix data quality issues and promote good data governance.
Machine Learning enriches data with prediction, scoring, classification, and more.
Catalog & Lineage capabilities empower users to discover, govern, and protect data using AI and machine learning built on a layer of common enterprise metadata.
Analytics is used to discover, interpret, and communicate meaningful patterns in data to apply toward effective decision making
Reverse ETL replicates enriched data from the warehouse back to the operational systems of record.
-
Reduce Costs by 75% With Data Warehouse Automation
Data Warehouse ChallengesWhen an organization needs real-time data to feed the warehouse, they typically hire a third-party consultancy to create a ma... Show MoreData Warehouse Challenges
When an organization needs real-time data to feed the warehouse, they typically hire a third-party consultancy to create a manual change data capture (CDC) process and a data vault. However, after initial implementation, errors in this manual CDC process take many months to uncover and rectify. Adding new tables to the data warehouse will take many days since administrators make updates in a limited time window off business hours.Hence an organization should develop and configure its CDC and DWA processes without depending on third-party integrators or consultants. This way, they can increase the scalability to accommodate new data sources with minimal downtime and not be forced to choose between database availability and development effort.
An Ideal Data Warehouse Automation (DWA) Solution
The principal component of a DWA solution is the metadata repository. The development team uses metadata to describe and generate all data structures, data flows, and presentation data objects. They can use a client tool or a web portal to edit the metadata, thus saving a lot of manual coding effort.
The DWA solution will read a source database's data definition language (DDL) and import it into its repository. The DWA solution can also generate unique code to transition from one state to another, i.e., to unload the data mart, reshape it and then merge and reload the data in its new form. The same applies to generating test code harnesses.
Most DWA tools assist with data vault data modeling, which needs a well-disciplined approach as it uses many physical tables. A data vault sits on top of a data warehouse storing all changes made to the data warehouse and outlining the facts and dimensions of the data model.
Qlik's DWA Solution
Qlik's DWA automatically creates data vault-like structures with a data history, addressing one of the primary goals of a modernization project. Another critical benefit is eliminating reporting issues caused by missing rows in tables with compensating records for late-arriving dimensions.
Qlik's data replication automatically copies data table structures and data description language (DDL) to build the data pipelines and automatically update to changes. The Qlik solution is straightforward to use compared to legacy systems, helping to deliver the time savings described above.
Qlik's DWA Benefits
Qlik's DWA solution reduces development costs for data warehouse and data vault construction, resulting in cost savings from retired legacy systems and support. It increases business agility and future proofs with modernized data architecture. It also serves as a valuable tool for risk reduction, governance, and adoption of best practices.
Customers, on average, achieve 75 percent cost reduction in creating CDC processes and data vaults and 75 percent on data warehouse development. The time required to add new source systems to the data warehouse also shrinks by 4x - 20 days to 5 days. Additionally, the time to create new data mart facts and dimensions reduces, resulting in delivering a new data mart from scratch within a couple of weeks, an increase in speed of 400 percent on average.
Data and analytics teams can handle incoming new and ad-hoc BI requests for reports as they pop up and incorporate new data sources as needed. Also, with the new, flexible architecture, they are not dependent on outside database administrators or integrators, and organizations typically recoup deployment costs midway through a license subscription period.
Self-Service Click-Through Experience
Get a hands-on experience on Qlik's DWA solution here. Also, read here about a Qlik customer who experienced the results.
-
Inner and Outer Set Expressions
Today I am going to blog about inner and outer set expressions. If you have ever used set analysis in your measure expressions, then you will like thi... Show MoreToday I am going to blog about inner and outer set expressions. If you have ever used set analysis in your measure expressions, then you will like this new capability. Set analysis is a very powerful feature often used to define a scope that may differ from the scope that is defined by making selections in an app. For example, in the set expression below the sales are summed where the product line is camping equipment. This is considered an inner set expression and probably familiar to those who use set analysis. The set expression is in the aggregate function which is sum in this case.
If this expression was written as an outer set expression, the set expression would be outside of the aggregate function as seen below. When using an outer set expression, it must be before the scope. In this example, both the inner and outer expressions return the same result.
Now, where the outer set expression is helpful is when you have more than one aggregate function in your expression. For example, in the inner set expression below, there are three sum aggregate functions and in each one, set analysis is being used to set the scope to camping equipment.
Using an outer set expression, this expression can be written like this:
Notice that the set expression sits outside of the expression and at the beginning of the scope. Written this way, [Product Line]={'Camping Equipment'} is applied to all the aggregate functions. This is a cleaner way to write the expression and ensures that it is applied to all the aggregate functions. The outer set expression can also be used with a master measure. Assume I have master measures named Sales and Margin %. I can use outer set expressions like the ones below.
A set expression, like the outer set expressions above, are applied to the entire expression. If the set expressions were in brackets, then the set expression applies only to the aggregate functions within the brackets. For example, the set expression below is in parentheses which means that it only applies to the aggregate functions within the parentheses and not to the aggregate function that sits outside of the parentheses. Written this way, the resulting value will differ from the set expression without any brackets/parentheses.
A few things to remember about set expressions. Inner set expressions have precedence over outer set expressions and if the inner set expression has a set identifier, it replaces the context. Otherwise, the inner set expression is merged with the outer set expression. Check out Qlik Help for more examples and rules around inner and outer set expressions and try it for yourself in your next app.
Thanks,
Jennell
-
Qlik’s Response to March 2022 Spring Framework Vulnerabilities (CVE-2022-22965 "...
Qlik is aware that a set of well publicized vulnerabilities have been identified in the popular Java Spring Framework. These vulnerabilities have been... Show MoreQlik is aware that a set of well publicized vulnerabilities have been identified in the popular Java Spring Framework. These vulnerabilities have been assigned references CVE-2022-22965 (also known as "Spring4Shell"), CVE-2022-22947, CVE-2022-22950 and CVE-2022-22963.
- CVE-2022-22965: Spring Framework RCE via Data Binding on JDK 9+ (Critical)
CVE-2022-22947: Spring Cloud Gateway Code Injection Vulnerability (Critical) - CVE-2022-22963: Remote code execution in Spring Cloud Function by malicious Spring Expression (Critical)
- CVE-2022-22950: Spring Expression DoS Vulnerability (Medium)
Qlik has been diligently reviewing our product suite since we’ve become aware of these issues. We want to ensure Qlik users that your security is our upmost priority. As always, we recommend customers stay up-to-date on the most recent releases available for your product.
Products Not Impacted
The following products are NOT affected:
- Qlik Cloud
- Client-Managed Qlik Sense Enterprise and QlikView (all versions)
- GeoAnalytics (all versions)
- Qlik Compose (all versions)
- Qlik Compose for Data Lakes (all versions)
- Qlik Compose for Data Warehouses (all versions)
- Qlik Enterprise Manager (all versions)
- Qlik NPrinting
- Qlik Replicate (all versions) **
** Qlik Replicate contains libraries that contain the affected code, but they are not used in a way that is exploitable. These will be removed in a upcoming patch.
Products ImpactedOur testing shows only client-managed versions of Qlik Catalog are directly impacted (by CVE-2022-22965 and CVE-2022-22950) and a patch will be available as Feb 2022 SR2 and for the May 2022 release. Mitigation steps for earlier releases are linked in this knowledge base article.
Update 4/04/2022 8:15p.m EST
Qlik Catalog Feb 2022 SR2 is now available on the Downloads Site. Please be sure to be logged into Qlik Community with your Qlik ID to access.
Please subscribe to our Support Updates blog for continued updates as they become available.
Thank you for choosing Qlik,
Qlik Global Support
- CVE-2022-22965: Spring Framework RCE via Data Binding on JDK 9+ (Critical)
-
Content Highlights: QlikView to Qlik Sense Transition
As we settle into Q4, we know 2023 planning is underway. At this point, you’re likely evaluating your KPIs to determine whether they will continue in ... Show MoreAs we settle into Q4, we know 2023 planning is underway. At this point, you’re likely evaluating your KPIs to determine whether they will continue in the new year or be adjusted to meet new business requirements. As your business evolves, whether through modernization, operational cost reduction, or to maintain competitiveness, so too must your analytics initiatives and the metrics upon which you gauge organizational health in your market.
This year, we made a tremendous amount of progress helping QlikView customers get up to speed on Qlik Sense through the Analytics Modernization Program, but we realize you may still have some questions about modernizing and the transition process. We’ve built out several resources to reduce your concerns and have compiled some of the most popular ones here.
We recommend you review following:
OnDemand Webinars (Qlik login required):
- Demystifying Your Analytics Modernization with Qlik Sense SaaS
- Modernize Your Analytics on the Cloud with Qlik Sense SaaS
Technical Briefs:
- Analytics Modernization Best Practices for Qlik Sense SaaS
- Analytics Modernization Best Practices for Qlik Sense Client-Managed
eBook (Qlik login required): Top 3 Reasons to Modernize Your QlikView Analytics
Strategy Datasheet: Modernize Your Analytics Experience
The Analytics Modernization Program entitles QlikView users to Qlik Sense SaaS for a modest uplift on your annual maintenance rate, which converts to an annual subscription. With Qlik Sense SaaS, you’ll gain more options and control over your analytics leading to a competitive advantage and lower total cost of ownership for analytics.
For more information, contact EMEA: q2cemea@qlik.com; Americas: q2camericas@qlik.com; APAC: q2capac@qlik.com.
-
【オンデマンド配信】7 つの動向 - 優れた効果をもたらすデータ分析部門とは
分析がもたらす組織全体への効果は、データ分析部門次第です。優れた効果を得ている組織は、どのように分析を活用して成功しているのか。 本 Web セミナーでは、TDWI 社の最新レポート「データと分析を支援して組織を刷新」を基に、ディスカッションを交えてご説明します。 ※ 参加費無料。パソコン・タブレ... Show More分析がもたらす組織全体への効果は、データ分析部門次第です。優れた効果を得ている組織は、どのように分析を活用して成功しているのか。
本 Web セミナーでは、TDWI 社の最新レポート「データと分析を支援して組織を刷新」を基に、ディスカッションを交えてご説明します。
※ 参加費無料。パソコン・タブレット・スマートフォンで、どこからでもご視聴いただけます。日本語字幕付きでお届けします。
- 最新の組織体制とテクノロジーの導入
- 統制されたセルフサービスの実現
- データリテラシープログラムの導入
- データを資産として活用し、組織を統率する方法
- 最新の組織体制とテクノロジーの導入
-
Qlik reaches milestone with FedRAMP Moderate Authorization for Qlik Cloud Govern...
Qlik announced our authorization under the US Federal Risk and Authorization Management Program (FedRAMP) has been approved, with the sponsorship of t... Show MoreQlik announced our authorization under the US Federal Risk and Authorization Management Program (FedRAMP) has been approved, with the sponsorship of the US Environmental Protection Agency (EPA). This authorization allows US Federal, State, and local agencies to use Qlik Cloud Government safely and securely for data integration, analytics, machine learning, and more!
FedRAMP is a U.S. government program that approves cloud products and services for the U.S. Public sector. The goal of FedRAMP is to accelerate the adoption of cloud solutions for agencies and support their transition from older legacy infrastructures to mission-critical, secure, and cost-effective cloud-based technology.
“As federal agencies and organizations rapidly modernize and migrate to the cloud, they must ensure the transition is protected under the strictest secure protocols and authorizations,” said Andrew Churchill, Vice President of Federal at Qlik. “Achieving this FedRAMP milestone validates Qlik's ability and commitment to meet the unique and ever-changing needs of our government clients and equips them with greater access to state-of-the-art solutions to reach their mission goals.”
Qlik worked closely with their sponsoring agency, the EPA, who implemented Qlik Cloud Government to ignite innovation and evolve their current analytics program. The EPA leveraged Qlik Cloud Government to unlock more value out of their data in addition to improving operational efficiencies and reducing costs across the agency.
“Working with Qlik in their pursuit of FedRAMP authorization allowed EPA to shift resources to delivering analytics to protect human health and the environment rather than IT administration,” said Arthur Zuco, Program Manager at EPA. “Our world is moving to the cloud and, by adopting SaaS, we are setting ourselves up to take advantage of the kinds of new capabilities that will be delivered by the SaaS market in general for years to come.”
Federal, state, and local agencies worldwide trust Qlik for data integration and superior analytics capabilities through a state-of-the-art platform built to enable end-to-end data analytics pipelines that close the gaps between insights and action. Now our US Public Sector customers can take advantage of that vision in a FedRAMP-compliant cloud environment.
Qlik’s FedRAMP Moderate authorization is also recognized by the Department of Defense (DoD) at IL2 and has started uplift certification for IL4.
To read the press release, see here.
To learn more about Qlik Cloud Government, link here (already linked 2x above)
To speak with someone from our Public Sector team, click here.
-
Mini Charts
With the June 2020 release of Qlik Sense came many chart enhancements. My favorite is the addition of mini charts to a table. In a table, a measure c... Show MoreWith the June 2020 release of Qlik Sense came many chart enhancements. My favorite is the addition of mini charts to a table. In a table, a measure can be visualized via a mini chart as either bars, dots, sparklines, or positive/negative.
This enhancement not only makes a table more appealing to look at, but it can easily point out changes and trends in the data. To add a mini chart to a table, follow these simple steps:
- Add a measure to the table. In the example above, Sum(Sales) is the measure.
- In the Properties window of the table, change Representation to Mini chart.
- Select the dimension to indicate what data to view. In the table above, Month was the selected dimension.
- Select the Type of mini chart to add (bars, dots, sparklines or positive/negative).
That is it, the mini chart is added to the table. There are other options that can be adjusted to change the look and feel of the mini chart. In the Colors area, there is the option to select the color of the bar/dot/line as well as the option to select the color of the max value, min value, first value and last value. If showing a sparkline mini chart, you also have the option to show dots on the line for each data point of the selected dimension. The y-axis can also be adjusted for the mini chart. There is the option to use local or global so you can decide if the y-axis range is based on the specific row or all rows. There is also the choice to select auto, zero as baseline or zero as center for the y-axis. Read more about mini chart in Qlik Help.
Mini charts are eye candy for your table. Dress up the measures in your table with mini charts to provide another layer of information in an easy to digest manner. Learn more about the Qlik Sense June 2020 release by checking the links below:
- Qlik Sense App - What’s New App
- Video – What’s New – Qlik Sense June 2020
- Video – June 2020 Feature Demonstration
- Blog – Qlik Product Innovation Blog – Qlik Sense June 2020
Thanks,
Jennell
