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
-
Securely access data behind a firewall or VPC with Qlik Data Gateway - Direct Ac...
Can't see the video? Watch it here on the Qlik video site hereOrganizations of all levels are making significant investments to digitize and modernize... Show MoreCan't see the video? Watch it here on the Qlik video site here
Organizations of all levels are making significant investments to digitize and modernize business systems and operations to better take advantage of the cloud. But not every company can just pick up and move every single part of their business. Whether its regulatory or strict firewall policies, some operations, and data must remain behind a firewall or within a virtual private cloud (VPC).
Customers that fall into this category get stuck in the middle between wanting to adopt SaaS offerings but keeping data where it is. Luckily, Qlik has made it possible for customers of Qlik Cloud to deploy a full enterprise SaaS analytics environment with safe, secure access to data that lives and breathes behind a firewall.
Qlik Data Gateway - Direct Access provides an encrypted connection to Qlik cloud that allows Qlik Sense SaaS applications to securely access and analyze data that resides behind your organization's firewall. No matter if your protected data is on-premises or in a virtual private cloud, Direct Access provides a secure way to analyze that data in Qlik Sense SaaS.
Qlik Cloud offers enterprise-grade solutions for data ingestion into Qlik Sense SaaS with respect to governed access of internal data landscape(s) of an organization - no matter where the data resides, in the cloud or somewhere behind a firewall.
How it Works
Can't see the video? Watch it on the Qlik video site here
The Qlik Data Gateway acts as a bridge from data sources into Qlik Cloud, allowing Qlik Sense SaaS application to securely access and analyze data behind a firewall or within a VPC.
The Data Gateway is installed on a system in an organization’s network behind a firewall and allows secure encrypted connections between data sources and the Qlik Cloud tenant. The Data Gateway establishes a mutual authenticated and encrypted connection using HTPPS.
Qlik Cloud sends a query to the gateway and the gateway relays the query to the defined data source which is configured with a connector. The data is then streamed directly from the data source to Qlik Cloud – it’s important to know that the data is always in transit and never physically resides on the data gateway.
For a tour, please check out the Connect and Learn pane on the bottom right of your hub or inside of the QMC by going into the Data Gateway portal from the Configuration pane on the left.
Connect and Learn
Qlik Management Console (QMC)
Qlik Data Gateway and Direct Access makes SaaS analytics consumption possible for customers with data that must remain on-premises or within a VPC.
Qlik Cloud supports all types of data landscapes with safe solutions that accelerate cloud adoption and provide the innovation needed for our customers to pursuit their next chapter of analytics greatness.
Try Direct Access today with our demo app - here
Register for the Do More with Qlik Archive to see the Data Gateway - Direct Access and Direct Query webinar on demand, available soon.
-
Green River College
Previously I shared a webinar with one of our Educators, Danny Najera from Green River College. Danny's use case for Qlik is unique and we have had a ... Show MorePreviously I shared a webinar with one of our Educators, Danny Najera from Green River College. Danny's use case for Qlik is unique and we have had a great time hearing from him about how he and his students use Qlik and the Academic Program. Recently we sat down with Danny to put together a case study and we are thrilled to share the results! The case study focuses on his teachings and how specifically Qlik and the Academic Program have aided him on his quest to ensure that students are focusing on the data, and not struggling with the data tools.
Read the full here here and if you didn't already get a chance to watch his webinar, check it out!
Educators and students who wish to benefit from the program like Green River can apply today by visiting https://www.qlik.com/us/company/academic-program
-
Qlik アプリで「FIFA ワールドカップ 2022」をもっと楽しく！
2022年 11月 20日、4 年に一度のサッカーの祭典「FIFA ワールドカップ 2022」が開幕しました。世界 32 ヶ国を代表する選手たちが、中東カタールで世界王者を目指します。今大会を制するのはどのチームなのか？過去大会の対戦成績は？Qlik の「Choose Your Champion」ア... Show More2022年 11月 20日、4 年に一度のサッカーの祭典「FIFA ワールドカップ 2022」が開幕しました。世界 32 ヶ国を代表する選手たちが、中東カタールで世界王者を目指します。
今大会を制するのはどのチームなのか？過去大会の対戦成績は？Qlik の「Choose Your Champion」アプリでは、今大会結果のほか、過去大会の各チームや各選手のゴール数など、1930 年からの統計情報を見ることができます。また、どのチームが勝つのかを予測して、仲間と共有することもできます。ぜひアクセスして、今大会をお楽しみください！
アプリにアクセスする -
Qlik Sense Monitoring Applications for Cloud and On Premise
Can't see the video? View it on the Qlik Video Page.If you want to track usage capacity of users on your tenant, check out the Entitlement Analyzer. N... Show MoreCan't see the video? View it on the Qlik Video Page.
If you want to track usage capacity of users on your tenant, check out the Entitlement Analyzer. Need to optimize your Qlik Sense applications? Then perhaps the App Analyzer will help. Want more insight into your app reloads – download the Reload Analyzer. Looking to learn what users and groups have access to what space and what roles they have? Start using the Access Evaluator and finally – if you are a Qlik partner or an Enterprise that needs to centrally monitor information from multiple Qlik Cloud tenants all from a single dashboard, then check out the OEM Dashboard app. Qlik is dedicated to your success and our best and brightest have created these specific solutions to make it faster and easier to get those important insights so you don’t have to. These apps are available for you to download in the Qlik Community along with documentation.
The Qlik Sense Monitoring Applications for Cloud and On Premise
-
The most wonderful time of the year means TWO releases this month!
It’s the most wonderful time of the year! Spooky season is behind us (finally, it’s my least favorite) and the Holiday season is upon us. Thanksgiving... Show MoreIt’s the most wonderful time of the year! Spooky season is behind us (finally, it’s my least favorite) and the Holiday season is upon us. Thanksgiving is next week in the United States which means family, food and [American] football. It is, without a doubt, my favorite holiday.
All the Holiday excitement made us think we need TWO releases this month! Today, we pushed out the first round of November enhancements:
Chatbot added to more Support pages
You can now ask questions or connect to a live agent on the following pages:
Look for the blue ‘Contact Support’ button.
More Blogs! Widget
Easily access other suggested blogs with the new More Blogs! widget on the right rail.
‘Create a Post’ Button
We previously updated the Post a Question button on Forums and the Job Board to Create a Post. This was inadvertently reverted, so we fixed it.
Posting Guidelines Now on Job Board
New guidelines are available on the right rail of the Job Board. Use these templates when posting on this page.
Since next week is a Holiday week, expect to see the second round on November 29th!
Your Qlik Community Admins,
Melissa, Sue, Jamie, Nicole and Emma
@Melissa_Potvin @Sue_Macaluso @Jamie_Gregory @nicole_ulloa @emmaspickerman
-
【オンデマンド配信】東亞合成（株）× Qlik 対談：Qlik でプロジェクト進捗管理を実現し、リアルタイムなデータに基づいた意思決定でビジネスを推進
大手化学メーカーの東亞合成株式会社は、2017年より Qlik を採用。SAP 等の社内各システムからデータ統合基盤へデータを集約 / 加工して集めたデータを分析するために Qlik で独自のアプリを作成し、社内プロジェクトの進捗管理・予算管理をリアルタイムに見える化することで、生産性の向上を実現し... Show More大手化学メーカーの東亞合成株式会社は、2017年より Qlik を採用。SAP 等の社内各システムからデータ統合基盤へデータを集約 / 加工して集めたデータを分析するために Qlik で独自のアプリを作成し、社内プロジェクトの進捗管理・予算管理をリアルタイムに見える化することで、生産性の向上を実現しています。今後の展望として、Qlik により「人が取るべきアクションの促進を自動化」し、データに基づき各社員が行動することで、データ駆動型プラントの実現を目指しています。
本講演では、実際に社内で活用中のアプリをご紹介いただくほか、Qlik 営業担当者との対談にて、データ活用に関する過去 / 現在 / 未来の取り組みについて詳しくお話しいただきます。※ 参加費無料。パソコン・タブレット・スマートフォンで、どこからでもご視聴いただけます。
-
Qlik Data Integration November 2022 Client-Managed Releases - now available
Qlik Replicate November 2022 Client-Managed The November 2022 release is packed with many exciting announcements. We have new endpoints, capabilities,... Show MoreQlik Replicate November 2022 Client-Managed
The November 2022 release is packed with many exciting announcements. We have new endpoints, capabilities, improvements, and optimizations.
New Endpoints and EnhancementsThe Qlik Replicate November 2022 release brings several new endpoints and enhancements, some were made available as part of an earlier Service Release (May2022 SR) and are also included in this General Availability release.
SAP New Endpoint & Optimizations supporting many ways to enable data replication from SAP with Extractors and best-in-class log-based and trigger-based CDC, in this November release we have continued to expand on the many ways you can connect with your SAP data. You will find:
- New SAP ODP endpoint as a Source - Introducing support for the SAP Operational Data Provisioning (ODP) framework that can provide a better experience than SAP Extractors and operate under an SAP Runtime license.
- SAP HANA multi-tenants
- SNC authentication
Improved Databricks Endpoints as a Target Databricks is an important strategic technical and commercial partnership for Qlik, and we continue to improve our integration with the Databricks ecosystem and the user experience by consolidating the Databricks Lakehouse (Delta) endpoints as a target, supporting Full Load, Store Changes and Apply Changes. Both endpoints now support Databricks SQL compute as a lower cost compute layer in Databricks.
- Databricks Lakehouse (Delta) as a Target - This release adds support for both managed and unmanaged tables in this endpoint. We have also added support for Databricks Lakehouse (Delta) on AWS and Google Cloud Platform (GCP). For a better user experience, we have consolidated the three Databricks endpoints (Databricks on AWS, on GCP and Azure Databricks) into this single endpoint. Note: When upgrading to this release, any existing tasks using Azure Databricks Delta endpoints will be automatically migrated to the new Databricks Lakehouse (Delta) endpoint.
- Databricks Cloud storage as a target – This endpoint is typically used with Qlik Compose to manage the data lake and historical data sets. With this release, this endpoint and Qlik Compose now support Databricks SQL Compute, along with parquet file delivery for optimized performance with Qlik Compose.
MongoDB on ATLAS as a Source The Qlik Replicate November 2022 release supports cloud-based MongoDB Atlas, as an additional option to the existing MongoDB endpoint.
MS SQL Server (CDC) as a Source This release sees support for Microsoft’s MS CDC API which has recently come out of beta. This is a new option for the existing endpoint which adds significant value by simplifying complexities for example;
- Reading the lobs directly from the CT table without the need to do lookup.
- In addition to supporting sysadmin credentials, you can now choose to work with db_owner
New :
- AWS PrivateLink added - Improved security for Amazon S3 with the support for AWS PrivateLink which will help improve secure connections for larger AWS environments. Stay tuned for support of other targets in later releases.
- Parquet file format support added for Azure Data Lake Storage Gen 2 (ADLS Gen 2) and Google cloud
The Parquet file format provides optimizations that speed query execution due to its efficient file format. Parquet is an open-source file format built to handle flat columnar storage that enables a simple “file based” raw lake for data science use cases. It’s well known for both its performant data compression and the ability to handle a wide variety of encoding types. Aligning with our multi-cloud strategy, support for Parquet now spans across the clouds, building on Parquet support for S3 added in the Qlik Replicate May 2022 release Qlik Replicate now supports the three main Hyperscalers (AWS, Azure and GCP).
- Google BigQuery enhancements -
This endpoint now offers added Proxy support, Use-compression as an option and the ability to allow you to set any Google Region when selecting Google Locations. In most cases compression can usually improve performance, however in some cases performance could be degrade, when trying to compress an already compressed file, for example. Therefore, we have added an option to enable you to decide if you want Qlik Replicate to use compression or not when moving data to Google BigQuery. Google are regularly adding new Data Location Regions and if your chosen location is not available in Qlik Replicate’s built-in Location list, you can now select “Other”, and manually add the new Region code.
- Added Support for Primary Key (PK) changes
As any DBA knows making changes to the PK directly is a big “No, No!”. To ease downstream processing, and support best practices, this Qlik Replicate Engine improvement benefits Data Lake and streaming targets, e.g., Kafka, by turning updates to the PK into a delete of the old key and an insert of the new key.
Qlik Replicate is now using FIPS compliant libraries Qlik Replicate November 2022 release now includes the option to use FIPS compliant libraries over standard OpenSSL. FIPS (Federal Information Processing Standards) is a set of standards developed by the United States Federal Government for use in computer systems. By selecting this option in Qlik Replicate, fully compliant FIPS 140-2 SSL libraries will be used that meet a set of stringent security requirements that are associated with these libraries.
Qlik Compose May 2022 - Service Release (22.05)
Qlik Compose’s latest release offers exciting new capabilities, such as:
- Streamlined Audits - Qlik Compose maintains the history of all transactions in the Historical Data Store (HDS). When customers audit individual transactions that occur at sub-second frequency, they take the extra step of reviewing those changes in the landing area of a Data Warehouse instead of directly in the HDS. With the latest release, we are enhancing our data governance capabilities by adding support to view and manage all changes in the HDS resulting in streamlined audits.
- Expanded Automation – Currently, Qlik Compose administrators manage users and groups manually using the user interface. This Qlik Compose release augments administration capabilities via the command line interface. Administrators can further automate their Continuous Integration & Development (CI / CD) pipelines by creating and managing access to Qlik Compose using command line scripts.
- Lower Lakehouse Costs – Qlik Compose customers can now execute their automated workloads on Databricks SQL Warehouse and benefit from lower-cost computing on the latest 10.4 LTS Databricks Lakehouse Platform. Also, Qlik Compose can now consume parquet files landed by the November 2022 release of Qlik Replicate.
- Greater Agility – Qlik Compose generates SQL code to automate the lifecycle of data warehouses and different types of data marts. Additional run-time clauses are added to the generated SQL code in the latest release to reduce the number of statements executed when there is no data to process. This optimization of SQL statements for Data Warehouse projects greatly enhances data warehouse agility when minimal data changes occur.
- Windows Modernization - Compose is now certified to run on Windows 2022. Data Warehouse and Data Lake automation efforts can now utilize Qlik Replicate and Compose on this latest Windows version.
Qlik Catalog November 2022 Client-Managed
- Schedule data loads Qlik Catalog November 2022 removes the requirement that external tools are needed to load data on a predefined schedule. Qlik Catalog now provides the ability to define, schedule, and automatically run data loads.
- Publishing business names Previously, business names that were added to a data field could only be included when publishing to a Qlik target. We’ve now expanded this capability to allow business names to be included when publishing to any target.
- Increased performance We’ve improved the performance of incremental loads by only pulling changed data into Qlik Catalog.
- Updating metadata tags When importing metadata tags, one could previously only create new tags in Qlik Catalog. Qlik Catalog November 2022 gives you the option to alternatively update existing metadata tags during import.
We hope you enjoy using these new releases and would love to hear your feedback and success stories, especially in any improvement gains you achieve.
To learn about everything that is included in these releases be sure to check out the Release notes which are available here
To obtain any of these releases, go to the Qlik Downloads Site in community and filter for “Qlik Data Integration”, and then select the product and the versions you would like to download.
Note: For most products, please select the version “November 2022” or in the case of Qlik Compose please select the latest Service Release (SR) version.
For additional help in using the downloads site - watch this handy video guide here:
How-to-download-Qlik-Products -
Qlik Academic Program visits the UK
This past week I have been happy to finally get the opportunity to travel and meet some of our educators. Our Academic Program journey started last Fr... Show MoreThis past week I have been happy to finally get the opportunity to travel and meet some of our educators. Our Academic Program journey started last Friday when we visited the University of Sheffield to give a hands-on workshop to 60 students studying Digital Marketing. The majority of the students had never used Qlik before but they managed to successfully follow along with the workshop run by our Principle Solution Architect, David Sedgewick. Due to a number of updates to Qlik Sense Cloud, this was a brand new workshop and the content covered everything from data loading, to the insight adviser and master measures.
On Monday we returned to the University of Sheffield for two more sessions, this time for Supply Chain Technology in the morning and Business Intelligence in the afternoon. Our afternoon session was lead by our Solution Architect, Paul Styles, who went straight into showing the students how to get started with loading data. Throughout our Sheffield sessions, even the students who seemed unsure and asked for help, all managed to follow along and in some cases even go a step further than the workshop.
On Tuesday I attended the beautiful Greenland's Campus at Henley Business School to speak to Masters students studying Business Strategy. This is a course that is primarily studied online with a two day workshop element that invites guest presenters to speak to students about strategy and data in the work place. Our Qlik session gave students the opportunity to see all the theory they had learnt in the context of real life uses cases and an analytics tool.
From Henley I then got the train to Birmingham to speak to a class of students being taught by one of our very own Academic Program Educator Ambassadors, Nassir Ibrahim, at Birmingham City University. Nassir's students are in Semester 1 of their final year studying Business Intelligence, and they have spent the past 8 weeks building dashboards in Qlik Sense using data sets related to a car manufacturer. Two of the students proudly gave me tours of their dashboards and showed me how they added additional data and used Qlik Sense to answer business questions set by Nassir.
Throughout these university visits I have been amazed by how committed these groups of students are when it comes to expanding their skills and making themselves more employable. It's also been great to meet the passionate educators who care so much about the future of their students. If you would like to learn more about how you can support your students in getting the skills they need to succeed in the data driven world, follow this link to learn about our Academic Program - qlik.com/academicprogram.
Alternatively, if you are already an educator using our program why don't you apply to be an Educator Ambassador for 2023? Read this blog to learn more.
-
Qlik Sense November 2022 Client-Managed Release - now available
With augmented analytics, you can bring the power of your data to more people in your organization, broadening access, deepening insight, and improvi... Show MoreWith augmented analytics, you can bring the power of your data to more people in your organization, broadening access, deepening insight, and improving efficiency. Insight Advisor in Qlik Sense has been completely redesigned with UI enhancements and an always-available search box, and we have made several enhancements to chat in the hub. Our new Insight Advisor Analysis Types feature automates the creation of sophisticated analyses such as ranking, comparisons, and clustering in a few clicks. And, we’ve made a number of improvements to our visualization, connectivity, and overall platform capabilities. Read on for more details.
Below you will find supporting detail on "What's New" in this November 2022 release:
New Enhancements in Augmented Analytics:
Generate the most relevant insights through selection and search
Insight Advisor Search provides an improved Insight Advisor experience in-app, allowing users to easily auto-generate the most relevant analyses and insights from their data. A new button opens Insight Advisor, where users can select fields and generate insights without having to navigate away from their current sheet. The new Ask Insight Advisor search box is now visible at all times within dashboards, allowing users to easily generate insights using natural language processing. Auto-generated visualizations and analyses can be refined and added directly to dashboards for further exploration.
Create advanced analyses and insights in a few clicks
Insight Advisor Analysis Types is a new experience in Qlik Sense that allows users to request a certain type of analysis, such as a comparison, ranking, trending, etc., which will be generated in the best possibly way by AI. Users can choose from a variety of advanced analysis types and will be guided to select the best data and options. Analyses will then be auto generated and can be edited and added to dashboards for further exploration. With Insight Advisor Analysis, we now support multiple paths to insight – users can either use traditional natural language search or can start with an analysis type in a more directive manner, driving data literacy and insight.
Provide curated list of questions for Insight Advisor Users
Example Questions for Insight Advisor - App creators can now provide example questions for Insight Advisor within the Business Logic layer of an app. This allows them to offer sample questions that are tailored to their specific analytic content, helping users learn how to use natural language. When users ask questions, the examples will be displayed in a drop-down menu where they can be selected, modified, and submitted. And, in chat, example questions from across your apps will be offered.
Support "explore this further" for follow-up questions in Insight Advisor Chat
Insight Advisor Chat now better supports partial intent questions with the "explore this further" option, taking people directly to search-based discovery within apps for deeper analysis. Users can now ask follow-up questions to an original question, and when clicking explore this further, they will be taking into the app with selections applied for the full line of questioning, allowing them to pick up visually where they left off conversationally.
Time series breakdown as a QIX Engine function
Time-Series Decomposition Functions - Several new engine functions now allow you to decompose a time series dataset into trend and seasonality. The trend function identifies direction in the data, and the seasonality function determines seasonality with a known periodicity. The residual function identifies variation that is not associated with seasonal or trend components (i.e., noise). With these functions, you now have increased visibility into the patterns and trends in your time-series data so you can better plan future action.
New distribution functions from Cephes library
The following distribution functions from the Cephes library have been added, allowing you to perform more advanced statistical analysis of simulations. These distribution functions can be used in both the data load script and in chart expressions.
BetaDensity, BetaDist, BetaInv ,BinomDist, BinomFrequency ,BinomInv, ChiDensity, FDensity, GammaDensity, GammaDist, GammaInv, PoissonDist, PoissonFrequency, PoissonInv, TDensity
New Visualizations & Dashboards:
Custom tooltip creation for charts without dimensions
Based on customer request, the ability to create a custom tooltip for the KPI object has been added to Qlik Sense SaaS. This is the first tooltip added on a dimension-less object. The tooltip is conveniently displayed upon hovering over the object.
Add Background Layer & Properties to Agnostic Map
As part of the Nebula conversion of all charts, this will enable us to embed a map chart using Nebula.
Dynamic View Improvement
Users will now still have visibility to the chart whilst it refreshes, allowing for improved usability.
Connectivity:
MongoDB Additional Authentication
The Qlik MongoDB connector has been enhanced with new security features. Organizations can now use SCRAM-SHA-256 and LDAP authentication options when defining their MongoDB connection.
Integration of Standalone Web Connectors in Qlik Sense Enterprise on Windows
The following connectors are now available as part of the installed versions of Qlik Sense on Windows:
Facebook Insights, Google Ads, Google Calendar, Google Search Console, Outlook 365, Mailbox IMAP, Microsoft Dynamics CRM V2, OData, Qualtrics, SMTP, SurveyMonkey, and YouTube Analytics
For most use cases this means that the standalone Web Connectors are not needed, as these connectors now can be configured directly in the Qlik Sense client.
Remove of the “Disable” option for the Bulk Reader
The Bulk Reader load optimization setting was introduced in the August 2021 release, and users were given an option to either “Enable” or “Disable” this feature. This update removes the option to disable the Bulk Reader, and makes it always enabled on new connection definitions, to always ensure high-level performance when working with large datasets.
Platform:
Duplicate Tasks in QMC
Users are now able to duplicate tasks in QMC, much like they already can duplicate an app!
Client Sub-Bar for Windows
We have upgraded the Sub-Bar within Qlik Sense Enterprise Client Managed to match what is already being used in Qlik Sense SaaS. This will create an enhanced user experience for our users of both platforms, and inevitably create a much more consistent flow.
Config Files Persistence: Opt-in or Opt-out
Newly available check-box selection to allow the user to decide if they would like to enable or disable the config files persistence during an upgrade!
Allow Users to Create Custom Banners
Download Qlik Sense November 2022 here
Don't miss the next Qlik Insider, airing on November 16th - Register here
-
【オンデマンド配信】QlikWorld Tokyo オンライン
富士通・DNP が語る、データを活用した DX 推進成功例 昨今、データ活用による DX 推進は、あらゆる企業において最重要事項となっております。特に「リアルタイムデータに基づいた迅速な意思決定と行動」というアクティブインテリジェンスの考え方の重要性は、コロナ禍を経てますます高まっております。 こ... Show More富士通・DNP が語る、データを活用した DX 推進成功例
昨今、データ活用による DX 推進は、あらゆる企業において最重要事項となっております。特に「リアルタイムデータに基づいた迅速な意思決定と行動」というアクティブインテリジェンスの考え方の重要性は、コロナ禍を経てますます高まっております。
この度、アクティブインテリジェンスのためのプラットフォームを提供する Qilk は、「QlikWorld Tokyo オンライン」を開催いたします。本イベントでは、基調講演に富士通株式会社 執行役員 Executive Vice President / CIO / CDXO 補佐 福田譲様をお迎えし、同社の DX の取り組みについてお話しいただきます。また、アクティブインテリジェンスの最新動向や DNP、PayPay 銀行などのお客様の DX 推進事例をご紹介します。
※ 参加費無料。パソコン・タブレット・スマートフォンで、どこからでもご視聴いただけます。
-
Qlik Digest - November 2022
WHAT’S NEW AT QLIK?New Data Integration Capabilities in Qlik Cloud. This comprehensive solution is unique in its ability to deliver real-time data to ... Show MoreWHAT’S NEW AT QLIK?
New Data Integration Capabilities in Qlik Cloud. This comprehensive solution is unique in its ability to deliver real-time data to the cloud, automate the transformation into analytics-ready structures, and unify all enterprise data with a robust catalog and data lineage. Watch Videos
Get up to speed on the latest visualization capabilities in Qlik Sense SaaS. These include application chaining, styling updates, the ability to add a custom tooltip to your KPI object, and more. Learn More
Visit our download site to access the November release of Qlik Sense, Qlik Replicate, Qlik Enterprise Manager and Qlik Catalog.
Qlik Continuous Classroom Translations are LIVE!
You asked, we delivered! Machine translations are now live in the Qlik Continuous Classroom. The translations can be found in the closed captions of the self-paced learning videos and the Qlik Learning Portal pages.
Qlik Insider Webinar
Don’t miss the last webinar of the year on the very latest capabilities across our Data Integration and Analytics portfolio. Join us on November 16 to learn more about the latest Data Integration advancements in Qlik Cloud and Customer Managed Keys for organizations with strict encryption and governance requirements. Register now
On top of the Cloud
Qlik Cloud is helping organizations like Leroy Merlin and Urban Outfitters take advantage of new capabilities, innovate the way they manage their data and ultimately make better and quicker decisions.
Additional Featured Content
New to Qlik Cloud: Customer Managed Keys
-
【オンデマンド配信】（株）ニフコ × Qlik 対談：Qlik で会計データを見える化 - 管理会計分野における活用法とは
エンジニアリングファスナーのリーディングカンパニーである株式会社ニフコでは、約 6 年前から Qlik ソリューションを活用。SAP を基幹システムとして、そこに格納されているデータから管理会計に必要なデータの取り込み、データの活用、さらに数値から業務改善を進めていく仕組みを作り上げています。本講演... Show More -
UK GP Prescribing
UK GP Prescribing Quick Intelligence The NHS provide a wealth of data via Freedom Of Information. By seeing prescribing patterns from GP surgeri... Show MoreUK GP PrescribingQuick Intelligence
The NHS provide a wealth of data via Freedom Of Information. By seeing prescribing patterns from GP surgeries pharmaceutical companies can better target their campaigns to get relevant information to the healthcare professionals that need it.
Discoveries
This app shows prescribing trends for a number of diabetes drugs from UK GP surgeries. This can show when there are changes in the types of drugs that are being prescribed for a particular condition. These data can be blended with pharmaceutical company data to show market share in a selected market.
Impact
Having a good understanding of how other products are being prescribed means that pharmaceutical companies can better target their information campaigns, ensuring the right healthcare professionals have the information they need to make informed decisions about which products to prescribe.
Audience
These data would be of particular interest to people working in the SFE area of a pharmaceutical company. They could be of benefit to those developing treatments and to front-line healthcare professionals also.
Data and advanced analytics
The application has been built using freedom of information data and Quick Intelligence's Instant Sense Application. This application is free to download and allows you to upload your own data, along with a set of metadata, to have a working application in minutes and not hours. This is particularly useful for prototyping of applications, but can be used in production also.
See a live demo of the application here:
https://www.quickintelligence.co.uk/sense/prescribe.html
Find out more about the Instant Sense Application here:
https://www.quickintelligence.co.uk/instant-qlik-sense-app/
-
Qlik AutoML on Qlik Cloud now GA! Things You Should Know Before Getting Started
Check out Mike Tarallo's upcoming "Do More with Qlik" Session - REGISTER HERE Qlik AutoML is part of a full suite of augmented analytics capabilities ... Show MoreCheck out Mike Tarallo's upcoming "Do More with Qlik" Session - REGISTER HERE
Qlik AutoML is part of a full suite of augmented analytics capabilities available in Qlik Cloud. Qlik AutoML recognizes patterns and drivers in historical data to create machine learning models that can predict future outcomes; using a simple no code approach for business analysts and analytics teams. First, it generates machine learning models from historical data, which are then used to make predictions in conjunction with your current data - with full explain-ability. You can further explore these predictive analytics and get real-time calculations in Qlik Sense apps, by making interactive selections and testing what-if scenarios with our advanced analytics capabilities.
Fig. 1 Qlik AutoML - A ML Experiment results page after generating a machine learning modelMachine learning and predictive analysis go beyond traditional data analytics and it is important to remember that Qlik AutoML should be used to solve the right types of business problems and requires specific ingredients for architecting a machine learning ready data set. Before using Qlik AutoML be sure to check out this brief video to learn what you should know and where you should go before you get started.
Can't see the video - view on the Qlik Video Page
In Product Resource Guide
When creating a new Qlik AutoML Machine Learning Experiment in Qlik Cloud, you will see a screen pop up to guide you to the appropriate and additional resources to help you get started. I suggest you take a look at those. I am also linking them here in the post.
NOTE: This resource list will be updated in the next few days with more resources as they are delivered so please check back as needed.
- Qlik AutoML Community Forum (post questions, review documents and more)
- Sample Data Page
- Qlik AutoML Playlist (on YouTube)
- Qlik Help Documents - (will go live 8/16 this week)
- Qlik Continuous Classroom Learning Modules
-
Supporting Universities Virtually!
Last month the Academic Program had another opportunity to provide a workshop to one of our university partners, Penn State Great Valley. In the pas... Show MoreLast month the Academic Program had another opportunity to provide a workshop to one of our university partners, Penn State Great Valley. In the past, most workshops were hosted on campus where as many as 40 students would join. However, after the pandemic, the landscape of education changed and more students either chose to learn remote or did not have a choice.
To accommodate all of our members, we have pivoted the way we host our workshops. Currently we offer a hybrid model so we are able to be on campus for some students and allow others to join via zoom. Workshop information and necessary documents are shared with the class prior to joining and all students are encouraged to sign up for the program to ensure they have software and training they can go back and continue their learning with.
In attendance we have a Qlik Solution Architect on campus @ChrisReiter and @JoeHo on zoom to help field any questions.
If you are interested in a Qlik presentation or mini workshop, please apply to the program by visiting the website qlik.com/us/company/academic-program and then email us at academicprogram@qlik.com
-
5 Questions About Qlik Cloud Data Integration
I encourage you to check out the new web page, product documentation, and great video resources for more information. Finally, we know many of you hav... Show MoreI encourage you to check out the new web page, product documentation, and great video resources for more information. Finally, we know many of you have questions about this offering, so I'll devote the remainder of this article to the top 5 most frequently asked questions about Qlik Cloud Data Integration
1. What is Qlik Cloud Data Integration?
Qlik Cloud Data Integration is a powerful solution for data engineers tasked with deploying enterprise data integration and transformation initiatives. The offering forms a data fabric that delivers, transforms, and unifies your data across your organization via flexible, governed, and reusable data pipelines. These pipelines improve data timeliness, reliability, and scale, which are essential for every analytics, ML, or digital transformation initiative.
Consequently, Qlik Cloud Data Integration ensures that you can securely deliver the correct data (from on-premise or cloud sources) to the right destination (i.e. popular cloud data platforms), in the right format (with out of the box transformation features or custom SQL code), in near real-time.
2. Is Qlik Cloud Data Integration an entierely new offering
No. Qlik's journey to becoming a cloud business provided a unique opportunity for Qlik to rethink how we deliver data integration capabilities. But this wasn't the only factor. We also considered where the data integration market was going, what features our customers were requesting, and if there were opportunities we should pursue.
- Customer requirements – Customers have been assembling their own "data stacks" around the cloud data warehouse stores. The stacks are responsible for ingesting data, transforming data, cleansing data, protecting data, and serving data to various consumers. Our customers have told us repeatedly that managing all these different functions can be overwhelming.
- Market Drivers – The past few years have seen a dramatic rise in the adoption of cloud data platforms such as Snowflake, Databricks, Azure Synapse, Google Big Query, and Amazon Redshift. These platforms have become virtually every Enterprise's central data store for many downstream analytics initiatives.
- Qlik's Experience – Qlik's years of real-time data integration and transformation experience highlighted a gap that transforming transactional records into analytics-ready tables is a highly desirable and repeatedly performed activity. Most
Therefore we decided to create a new offering rather than simply porting existing client-managed solutions after analyzing all the data and research.
3. Where should I use Qlik Cloud Data Integration?
There are three common scenarios where Qlik Cloud Data integration is a great fit today:
- Real-time Data Warehouse Ingestion – You can use Qlik Cloud Data Integration to build a pipeline that continuously ingests data into a cloud data warehouse. Data can be ingested from on-premises data sources such as databases, SAP or mainframe applications in near real time. You can also load data from cloud applications too. The Illustration below demonstrates how two pipelines ingest data into Snowflake from an on-premise Oracle and MySQL database, while the third pipeline loads data from Salesforce.
- Automatic Star Schema Data Mart Generation – The second use case focuses on turning transactional records into analytics-optimized data marts. The beauty of Qlik Cloud Data Integration is that data mart generation is part of the data pipeline. Many market alternatives require the use of third-party data transformation tools, but Qlik doesn't. Qlik offers a visual data modeler, generates the necessary push-down SQL, and takes care of the execution scheduling too. The image below shows the graphical modeler automatically creating the dimension and fact tables within your data warehouse.
- Custom SQL for New Workloads – The last use case is creating pipelines for innovative workloads such as predictive analytics or machine learning. These workloads often require specialized data sets for training and prediction. With Qlik Cloud Data Integration, you can build real-time pipelines that combine data from various sources, filter and prepare the subsets, then deliver the result to the respective training and production environments.
4. Are there any changes to client-managed Qlik Data Integration?
No! Client-managed Qlik Data Integration is still alive and well and in active development. Furthermore, we have a regular release cadence and are committed to supporting our existing customers. We recognize that not all customer workloads can run in the cloud and we're not forcing anyone to migrate. Moreover, we've also made the two solutions interoperate without being integrated for those customers that want to run both on-premises and cloud workloads.
5. How can I try Qlik Cloud Data Integration?
Use this contact form link or call your account manager to get your hands on Qlik Cloud Data Integration today! Our data integration experts will help you make the most of this paid add-on to ensure that your first data integration project is a success.
Conclusion
I'll end the article where I began. I'm really excited that we announced Qlik Cloud Data Integration today, and how you can use it to create pipelines that deliver data and automate transformation in leading cloud data warehouses. However, what excites me most is the anticipation of hearing how the Qlik community and customers will embrace and deploy this fabulous new offering.
REGISTER for "DO MORE WITH QLIK" session on Nov 09 covering "Qlik Cloud Data Integration"
Clive Bearman
Sr Product Manager
-
【開催報告】QlikWorld Tour Tokyo 2022
弊社カントリーマネージャーの今井から開会のご挨拶の後、富士通 CIO の福田様による基調講演から始まりました。「日本は極めて DX への準備ができていない」という理解のもと、富士通における全社 DX の試みを「経営トップのコミットメント」「経路依存性」などのキーワードとともにお話しいただきました。 ... Show More弊社カントリーマネージャーの今井から開会のご挨拶の後、富士通 CIO の福田様による基調講演から始まりました。「日本は極めて DX への準備ができていない」という理解のもと、富士通における全社 DX の試みを「経営トップのコミットメント」「経路依存性」などのキーワードとともにお話しいただきました。
続いて、Qlik 村田からアクティブインテリジェンスの最新情報をご紹介。２社の国内事例を匿名でご紹介しましたが、その方々が本イベントに参加されておりましたので、急遽サプライズとしてご登壇いただき、Qlik への期待をお話しいただきました。また、弊社中嶋からは最新の AutoML、Application Automation、クラウドデータ統合、Snowflake との連携などのデモをご紹介しました。
コーヒーブレイク時には、協賛パートナー様（アシスト、アグニコンサルティング、インサイトテクノロジー、インサイトラボ、日立社会情報）の展示ブースで各社独自のソリューションやサービスが紹介されていました。
後半は事例セッションとなり、Qlik Sense を 2400名以上に大規模展開されている大日本印刷（DNP）様から同社の DX の取り組みと大規模展開のノウハウをご説明いただきました。
続いて、Qlik 古谷がクボタシステムズ、PayPay銀行、千趣会でのデータ統合の導入事例をご紹介しました。
最後に富士通様より、同社におけるデータ戦略を具体的にご紹介、「One Fujitsu」「One Data」の中で、アクティブインテリジェンスの理念と Qlik Sense ならびに Qlik データ統合が重要な役割を果たすことをお話しいただきました。
参加された方には、商売繁盛を祈念したご祈祷や懇親会など、リアルなイベントを楽しんでいただきました。今後もこうした機会を実施しますので、ぜひご参加いただければと思います。
なお、本イベントの講演は「QlikWorld Tour オンライン」として後日公開予定です。ご期待ください！
-
Qlik is Actively Monitoring OpenSSL Vulnerability (CVE-2022-3602 and CVE-2022-37...
Update: Dec 14, 2022 Qlik can confirm that this includes the lower severity issue CVE-2022-3786 which was announced by OpenSSL at the same time. ----... Show MoreUpdate: Dec 14, 2022
Qlik can confirm that this includes the lower severity issue CVE-2022-3786 which was announced by OpenSSL at the same time.
-----------------------------------------------------------------------------------------------------------------------------------------
Update: Nov 2, 2022
Qlik has completed its review of this third-party vulnerability and concluded it does not impact any Qlik product or service
-----------------------------------------------------------------------------------------------------------------------------------------
Update Nov 1, 2022:
The OpenSSL team has assigned the CVE reference CVE-2022-3602 to this issue and downgraded the severity to HIGH – please see https://www.openssl.org/news/secadv/20221101.txt .
Despite the lower severity, Qlik is continuing to review its products and services to ensure there are no concerns. At this time, no exposure has been identified.-----------------------------------------------------------------------------------------------------------------------------------------
Original, October 31, 2022:
Qlik is aware that the OpenSSL project has announced that a critical security issue will be patched in a release targeted for November 1, 2022.
Although we cannot be certain that there will be no impact to Qlik’s products and services until the full details are made public, initial indications are that Qlik is not impacted by this OpenSSL vulnerability.
As more details become available, Qlik will review and update this page accordingly. Subscribe to this post to receive notifications when updated.
Additional information:
https://mta.openssl.org/pipermail/openssl-announce/2022-October/000238.html
-
The Expression Search
Any search string beginning with an equals sign will be interpreted as an expression search, e.g.: =Sum(Sales)>80000 If you use this search s... Show MoreAny search string beginning with an equals sign will be interpreted as an expression search, e.g.:
=Sum(Sales)>80000
If you use this search string in a field listing customers, it will pick out customers for which the total sales number is more than 80000. This means that the Qlik engine will create a hypercube – the same as what you have in a chart – with Customer as dimension and Sum(Sales)>80000 as measure, and use this to determine the search result.
You can of course use the same search string in any field, e.g. Products or Months. But the results will be different, just as the different charts would show different numbers.
There are many implications of the above; implications you need to be aware of in order to make correct use of an expression search.
First of all: A hypercube is normally based on the current selection, which means that the search will not include excluded values. This is different from the wildcard search and the numeric search where the search is made in the symbol tables that hold all values, also excluded ones. If you want to include excluded values in your search, you need to use Set Analysis in your search string, e.g.:
=Sum({1} Sales)>80000
Further, the search string is a Boolean expression. This means that you can have several criteria, e.g.:
=Sum(Sales)>80000 or Count(distinct OrderID)>100
But it also means that you can simplify your expression, using the fact that all non-zero numbers are interpreted as TRUE. As an example, the two following expressions are equal:
=Count(If(Product='Trousers', OrderID))>0
=Count(If(Product='Trousers', OrderID))Finally, the expression search implies an aggregation. This means that you must use an aggregation function. If you don’t, the Only() function will be used. For example, if you want to search for customers from a specific country, you can write
=Country='Germany'
This will work fine if each customer is associated with one country only. However, it will not work if there are several possible values per customer. For example, if you instead want to search for customers that have bought a specific product, you might try:
=Product='Trousers'
Then you will find some customers, but probably not the ones you are looking for. You will find those that have bought only trousers and nothing else, since it is interpreted as Only(Product)='Trousers'. If you want to find all customers that have bought trousers and perhaps also other products, you should instead try one of the following
=Count(If(Product='Trousers', OrderID))>0
=Count({$<Product={'Trousers'}>} OrderID)
=Index(Concat(distinct Product, ','), 'Trousers')
=Sum(Product='Trousers')I admit that neither of the above expressions is very user-friendly, but it is nevertheless how it works.
If you want a simpler way to find these customers, you will just have to do it the manual way: Click on 'Trousers' in the Product list box, then look at the list of customers.
Further reading related to this topic:
-
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.
