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
-
Data Science among high-demand upskilling courses
In today's tough job market, landing the job you want is a challenge. Many have the same degree and some may have better scores. How can you stand you... Show MoreIn today's tough job market, landing the job you want is a challenge. Many have the same degree and some may have better scores. How can you stand you? Is there a way you can enhance your career prospects by doing something more than others?
In the competitive job market, standing out requires more than just a degree. Some cutting edge courses for upskilling for engineers to enhance their careers includes data science. To read more on this, visit:
http://timesofindia.indiatimes.com/articleshow/102936706.cms?utm_source=contentofinterest&utm_medium=text&utm_campaign=cppstIn order to enhance your data analytics skills, if you are a student or educator, for free training and certifications, visit: qlik.com/academicprogram
-
Developing for the Qlik Sense Mobile for SaaS app
Qlik Sense Mobile for SaaS was recently released to the general public and judging by what I have seen on my social media feeds, it has been well rece... Show MoreQlik Sense Mobile for SaaS was recently released to the general public and judging by what I have seen on my social media feeds, it has been well received. Having had the experience of working with the app leading up to the release, I thought it might be helpful to share some of the things that I learned about developing an app for the Mobile SaaS app.
Be conscience of the design real estate
Let’s face it, there is much more design real estate on a desktop than on a mobile device. You need to keep this at the top of mind when developing your app. Also, note that the current version of the Qlik Sense mobile app can only be viewed in portrait. With all of that in mind, when designing a sheet, most times, less is more. Only include those visualizations that are relevant to the story being told. Visualizations will be resized to meet the size of the device on which the app is consumed, so be conscience of pie charts that contain many dimensions or dimensions with small slivers of data as these can be tricky to analyze for the user. Scatter plots with data density can also be difficult for a user on a mobile device. And finally, because of the portrait only view, standard tables and pivot tables will only have the first couple of columns visible to user. To see the rest of the screen, he/she will have to scroll.
Small Screen Layout - Grid View vs List View
In the sheet properties of Qlik Sense sheets, there is a powerful property, Small screen layout, that allows you to decide how you want the visualizations to appear on mobile.
Grid View will display the sheet exactly as it is laid out on the desktop. This is good for sheets where you may want the user to be able to see the overall picture of the data.
List View will display the objects on your sheet in a horizontal card scroll view. The objects will appear one at a time and they will be sorted in the order in which they appear, starting from the top left of the sheet to the bottom right. The horizontal scroll is different from the traditional vertical scroll that you have seen in the past so it may take a little getting used to for the users.
If you prefer the vertical scroll don’t fret, from what I understand, look for the return of vertical scrolling in future editions of the Qlik Sense mobile app.
Filters
Keep this in mind, unless a field is hidden in the script, it is available to the user for filtering the data in the Available selections section. You can also, create Master Items that will also be available in the app. Current selections, bookmarks, and clear selections are also accessible through the same interface.
The Qlik Sense mobile for SaaS app is awesome. I recommend that you download it from the app store and take it for a test drive. There are so many cool things in the current version of the app, but from what I have seen, there are so many more enhancement coming in future releases that the mobile app will be a “must have” for Qlik Sense users.
-
Ctrl-Q NR
Ctrl-Q NR Ptarmigan Labs Low-code, open source tool for both client-managed and cloud Qlik Sense versions. Built on top of the excellent Node-RE... Show MoreCtrl-Q NRPtarmigan Labs
Low-code, open source tool for both client-managed and cloud Qlik Sense versions.
Built on top of the excellent Node-RED platform, Ctrl-Q NR let you quickly build data integrations, on-prem-to-cloud workflows, set up monitoring of critical app reloads and more.
Node-RED itself has more than 4600 modules covering all kinds of source systems, IoT modules, databases etc. All of which can now be integrated with both client-managed and cloud Qlik Sense.
More info at https://ptarmiganlabs.com/ctrl-q-nr-qlik-sense-nodes-for-node-red/
Discoveries
Given Node-REDs rich ecosystem of add-on modules your imagination is the limiting factor of what can be done... One example is hybrid Sense environments where on-premise/client-managed Qlik Sense is used to process data from local systems/sources. Ctrl-Q NR can then act as the hub that orchestrate cloud app reloads starting when on-prem systems have reloaded. A reload fails? That can be detected and alerted upon. Another example is integration of IoT data with Qlik Sense. Use Node-RED to collect the data and feed it to Sense, then Ctrl-Q is used to visually manage the various Qlik Sense resources that are involved (app reloads etc).
Impact
Easy prototyping and deployment of integrations that would otherwise be difficult and/or time consuming to create.
Audience
Qlik Sense admins and developers for both client-managed and cloud Qlik Sense.
Data and advanced analytics
Being able to quickly test and prototype ideas is an important capability in a fast-moving IT landscape. Thanks to the low-code nature of Node-RED (on top of which Ctrl-Q NR runs) integrations between Sense and other systems and tools can often be done in minutes. Node-RED runs on most platforms, including Windows, Linux, macOS and Docker.
-
Global Country Insights
Global Country Insights AnyChart Explore global metrics using the powerful Decomposition Tree tool in Qlik Sense, broken down by countries, cont... Show MoreGlobal Country InsightsAnyChartExplore global metrics using the powerful Decomposition Tree tool in Qlik Sense, broken down by countries, continents, and alliances in an intuitive interactive visualization.Discoveries
Explore countries, alliances, and continents using a decomposition tree, which brilliantly represents data across multiple dimensions and enables effortless ad hoc analysis.
Impact
Analyze population, area, debt, internet usage, and some other statistics, seamlessly navigating by country, continent, or alliance (APEC, NATO, etc).
Audience
Data analysts and business managers aiming to deconstruct totals and averages across multiple dimensions to empower informed decision-making about optimizing strategies and resource allocation. Anyone interested in exploring global population and other figures.
Data and advanced analytics
This app features a decomposition tree built with AnyChart's extension for Qlik Sense, the only way to add decomposition trees in Qlik Sense, utilizing The World Bank's data.
-
Transform First, or Load First? Comparing ETL and ELT Approaches
First, let's define the acronyms. ETL stands for Extract, Transform, Load. The extract step collects data from various sources. Next, the transform st... Show MoreFirst, let's define the acronyms. ETL stands for Extract, Transform, Load. The extract step collects data from various sources. Next, the transform step cleans, filters, aggregates, and prepares the data for analysis. Finally, the load step inserts the transformed data into the target destination
Conversely, ELT is Extract, Load, Transform. As the name suggests, the order of operations is slightly different. With ELT, data gets extracted from sources and then loaded directly into the target system. Transformations occur later and often within the database itself.
A core difference is where data transformation logic resides. With ETL, transformations typically happen outside the target database in a specialized engine or external programmed logic.
ETL is more flexible and can handle semi-structured and unstructured data like JSON, different text formats, files, images, and video. ELT is better suited for structured data like tables and CSV files.
By cleansing and anonymizing data prior to loading, ETL minimizes the risk of regulated data entering the target system. When there are simpler compliance requirements in unregulated industries that the cloud platform can handle, ELT can be used.
ELT is desired when simplicity in management is prioritized. However, if cloud and data warehouse design and operations management skills are in-house, ETL might come out ahead.
ETL is a mature technology with wide adoption. ELT is newer but gaining popularity as cloud data warehouses emphasize scalability and flexibility.
For small or mid-sized datasets, especially relational sources, ETL remains a sound choice. But as data volumes grow, ELT becomes more compelling with its faster loading and transformation times.
To summarize some key considerations:
- For data warehousing use cases, ELT is typically better suited, with SQL handling transformations
- In data lake environments, ETL remains preferable in most situations. ETL shines when data movement involves files and transformation is done with Spark processing.
- However, for data lake use cases demanding low latency, by offering the flexibility to consume raw data without transformation.
- When compliance with data privacy regulations is a top priority, ETL's data cleansing protections are appealing.
- ETL requires more upfront investment into integration tools and expertise, while ELT leverages existing infrastructure.
- ETL remains the prudent choice for small, relational data sources.
- As data volume, variety, and velocity increase, ELT becomes more attractive.
The optimal approach depends on your specific data environment, use case requirements, and team skills. ETL and ELT both have pros and cons, and often they can complement each other rather than act as mutually exclusive options. By understanding the key differences outlined here, you'll be better positioned to choose the right strategy or combination of both for your organization's data integration needs.
Whether you choose ETL or ELT, we have an offering for you. Take a guided tour or trial here.
-
【オンデマンド配信】Qlik ハンズオン Web セミナー：明日から使えるノウハウを習得
クリックテック・ジャパンの技術担当者が、Qlik 製品の技術的な内容や操作方法などをご紹介するオンデマンドの Web セミナーシリーズです。操作方法だけでなく、実践的なアプリを作成するためのヒントを習得することができます。 ※ 参加費無料。パソコン・タブレット・スマートフォンで、どこからでもご視聴い... Show More -
Qlik Digest - November 2023
Qlik Insider: Product Release Webinar Stay at the forefront of technological advancements to gain a competitive edge with our exclusive year-end webin... Show MoreQlik Insider: Product Release Webinar
Stay at the forefront of technological advancements to gain a competitive edge with our exclusive year-end webinar. We’re unveiling our latest breakthroughs in AI-enhanced data integration, quality, and analytics as we wrap up another incredible year of innovation here at Qlik.
Join us December 6, 2023Forrester Wave™ Augmented BI Platforms List
Catch Forrester’s take on Qlik’s presence as a Strong Performer in the enterprise augmented BI market – touting time to value, security, governance, NLQ, and the strongest customer references in the evaluation. Dive into the current state of the industry and the importance AI now plays in evaluating BI platforms.
Apply to be a Qlik Luminary!
Are you a big Qlik advocate who loves driving measurable impacts from data? Why not apply to be a #QlikLuminary? Luminaries gain exclusive Qlik perks and networking opportunities. Applications for the Qlik Luminary Program are open now and close on December 15.
Tips & Tricks of the MonthWatch this recent Do More with Qlik webinar for uses of simple and complex set analysis, along with new approaches that leverage AI and Insight Advisor to develop set expressions quickly and easily.
Increase adoption for your Qlik Apps with custom training designed specifically for your users. Help your team innovate and stay competitive in the market at qlik.com/training
-
Qlik Cloud Government is StateRAMP Authorized
As U.S. public sector organizations digitally mature and seek to be data-driven, adopting a “platform mentality” becomes essential to deliver the full... Show MoreAs U.S. public sector organizations digitally mature and seek to be data-driven, adopting a “platform mentality” becomes essential to deliver the full potential of data. Public sector agencies encounter various unique challenges around managing data governance across a disparate data landscape, navigating end-to-end analytics lifecycles, and ensuring seamless interoperability across teams. Qlik Cloud Government is here to the rescue. Created exclusively to empower U.S. public sector clients in optimizing their data potential, this cloud platform ensures both safety and compliance while fostering the seamless integration of analytics with advanced technologies like AI, ML, and automation.
What is StateRAMP?
StateRAMP, established in 2020, was designed to support state and local entities adopt cloud-based services and emerging technology in a secure way. Much like the US Government’s FedRAMP, the goal of StateRAMP is to accelerate cloud adoption and modernization by providing a standardized approach to the cybersecurity standards required from service providers offering solutions to state and local governments.
How does Qlik help customers reach StateRAMP compliance?
Qlik Cloud Government meets StateRAMP requirements. This simplifies the compliance process of authorization and streamlines deployment and implementation for customers. Qlik Cloud Government also supports FedRAMP, DISA, TX-RAMP, and more.
"I appreciate Qlik’s commitment to the StateRAMP process and investing in demonstrating the security capability and compliance of Qlik Cloud Government. This commitment by Qlik to the StateRAMP program supports our efforts at the State of Arizona for an effective and streamlined security review process, and it demonstrates a deep commitment by Qlik to security and compliance for the broader Public Sector community,"
J.R. Sloan, State Chief Information Officer, Arizona Department of Administration.
Summary:
Qlik Cloud Government can play a pivotal role in revolutionizing state and local government organizations across the United States. Serving as a comprehensive data platform, it empowers agencies to overhaul their operations and utilize data more intelligently. This ultimately enhances the delivery of public services, addressing social issues with greater efficiency, and promoting transparency and trust with citizens. The platform seamlessly integrates extensive capabilities across data integration, analytics, and provides a unified experience that makes it easy to deploy and manage. This cohesiveness results in significant benefits such as improved efficiency, cost savings, and streamlined compliance processes. Qlik Cloud Government supports a diverse range of use cases throughout the data lifecycle, from data ops for constructing sophisticated data pipelines, to enterprise BI and advanced technologies like artificial intelligence (AI) and automation. To learn more about how to create real-time insights in Qlik, check out our eBook here.
To learn more about Qlik Cloud Government, please visit out U.S. Public Sector site.
-
Maps: About Mercator projection
Like all map projections, the Mercator projection (a cylindrical map projection presented by the Flemish geographer and cartographer Gerardus Mercator... Show More
Like all map projections, the Mercator projection (a cylindrical map projection presented by the Flemish geographer and cartographer Gerardus Mercator in 1569) is attempting to fit a curved surface onto a plane distorting the results. If you look at a map constructed using Mercator projection (see example above) you will get a distorted idea about the size of geographical objects. For instance, take a look at Greenland and compare its extension with Australia. It seems to be bigger, isn't it?
If we overlap the shapes of the continent and the island we can see that, in fact Australia is 3+ times bigger than Greenland.
The classic way of showing the distortion inherent in a projection is to use Tissot's indicatrix, as in the picture below you will notice that the size of the red ellipsis representing distortion becomes bigger in areas that are far from equator, in fact by construction, the Mercator projection is perfectly accurate along the equator and nowhere else.
Map projections in Qlik Sense
The current release of Qlik Sense ships with two map projections, Mercator and Unit (1:1 projection). We recently covered the available Geo Functions in a post called Hidden gems in Qlik Sense geospatial functions.
By using some of those functions we could create maps as in the example below where the projection function helps to shrink the Canada shape.
Please note that in many free KML files some sort of projection (usually Mercator) has already been applied. AMZ
Thanks to Jonathan Pole and Yang Yang
-
WoWizer Telemetry and Performance Monitoring(TPM) for Qlik Sense
WoWizer Telemetry and Performance Monitoring ensures that you are in control of the Qlik Sense environment with timely alerts for anomalous behaviou... Show MoreWoWizer Telemetry and Performance Monitoring ensures that you are in control of the Qlik Sense environment with timely alerts for anomalous behaviour so that end user experience stays good even at times of high usage.
Discoveries
- Monitoring via metrics and logs
- User telemetry, usage, and adoption trends
- Real-time Alerting
- End-user feedback
Impact
- Positive end user experience during peak usage
- Qlik champion freed up from monitoring support
- Fast Troubleshooting reduces downtime
- Budgeting
- Load balancing
Audience
- Qlik Champion
- Qlik Admin
- Qlik CSM
- Business Users
Data and advanced analytics
- Time-stamped unstructured big data expertise
- Get started in a day with no hardware req.
- Optimal user experience for end users
- Freedom from mundane monitoring and stress for Qlik Champions
WoWizer TPM Useful Links:
-
Qlik Cloud 10月の新機能
分析の新機能 フィルターパネルの改善 フィルターパネルに、選択の確認を行うツールバーの表示をオフにするオプションが追加されました。常に折りたたむか折りたたまないかも指定できます。 新しいテキストオブジェクト 新しい柔軟なテキストオブジェクトがダッシュボードバンドルに加わりました。高度なスタイリ... Show More分析の新機能
フィルターパネルの改善
フィルターパネルに、選択の確認を行うツールバーの表示をオフにするオプションが追加されました。常に折りたたむか折りたたまないかも指定できます。
新しいテキストオブジェクト
新しい柔軟なテキストオブジェクトがダッシュボードバンドルに加わりました。高度なスタイリング設定でメジャーやテーブルの挿入ができ、背景の設定も可能です。
新しいストレートテーブルから複数ページの出力
新しいストレート テーブル拡張により、要望の多かった機能である複数ページの PDF 出力が導入されるようになりました。テーブルの現在の表示部分以外もダウンロードできます。最大 50 ページをダウンロードできるようになりました。
アプリの自動化の新機能
- Qlik Reporting に、レポートにチャートを追加する Add Chart to Report ブロックが追加されました。
- Qlik Cloud Services にビジネス用語集の管理を自動化するブロックが追加されました。インポートやエクスポートを自動で行うことができます。
- OpenAI Chat Completion block が追加されています。
- AWS KMS 用の コネクタが追加されています。
- Amazon Bedrock コネクタが追加されています。
管理者の新機能
Talend Cloud へのナビゲーションリンク
Qlik Cloud および Talend Cloud テナントを使用中のお客様は、Launcher メニューからアクセスして、テナント間を簡単に切り替えられるようになりました。
Qlik Cloud テナントの削除
有効期限終了時のQlik Cloud のテナントの削除方法がヘルプに記載されました。
Qlik の カスタマー マネージド キー (CMK) の拡張
カスタマー マネージド キー (CMK) に、より多くのお客様をサポートするための機能が備わりました:
- 既存データを使ってテナントを Qlik 内部 KMS から AWS KMS に変換する
- 既存データを使ってテナントを AWS KMS から Qlik 内部 KMS に変換する
- 既存データを使ってテナントを AWS KMS から別の AWS KMS キーに変換する (キー回転)
- Qlik Cloud 内でプロバイダー エントリーのライフサイクル管理を許可するパブリック CMK API
アプリの自動化に対応するAWS KMS 用の コネクタが追加されています。
新しいユーザーの役割：Embedded Analytics User
Qlik Sense のアプリにのみアクセスできるユーザー権限が追加されました。このユーザーは他の機能の使用を制限されます。
管理コンソールでのアプリの自動化の管理
管理コンソール 内で、テナントのすべてのユーザーの自動化をシームレスに監視できるようになりました。テナント管理者は、特定の時点で実行されている自動化の概要、スケジュールされた自動化の表示、特定の期間内に失敗した自動化の確認ができます。
データ統合の新機能
レプリケーションとデータレイクランディング
レプリケーションプロジェクトで、サポートされているデータソースからターゲットへのリアルタイムのデータレプリケーションをサポートします。
ターゲット：
- オンプレミスのMicrosoft SQL Server （Qlik Data Gateway - Data Movement 2022.11.74 以降が必要）
- Amazon RDS
- Googleクラウド
- Microsoft Azure（Microsoft Azure Managed InstanceおよびMicrosoft Azure Database）
レプリケーションプロジェクトに、新たに Land data in data lake タスクが追加されました。選択したデータソースからデータレイクにフルロードの配信を行い、変更データをデータレイク内のファイルに新しいデータとして自動的に配信します。サポートされているデータソースからCSV、JSON、またはPARQUET形式のファイルとしてデータレイクへ配信します。
ターゲット：
- Amazon S3（Qlik Data Gateway - Data Movement 2023.5.10 以降が必要）
プライベート接続サポートの拡張
プライベート接続に対応するターゲットが追加されました。インバウンドのファイアウォールポート、プロキシデバイス、ルーティングテーブルを開く必要がなく、VPC（仮想プライベートクラウド）のネットワーク管理とセキュリティの両方を簡素化し、データトラフィックの安全性とコンプライアンスを確保することができます。
- Databricks
- Microsoft Azure Synapse
- Google BigQuery
- Amazon
データパイプラインの系列と影響分析
データ統合パイプラインの中で、データセットとフィールドの系列や影響分析を参照することができるようになりました。
Qlik Data Gateway - Data Movement
Qlik Data Gateway - Data Movement 2023.5.10 にアップデートされました。
-
Distilling Data with Filter Panes
Throughout my series of blogs, we have been taking a look at the many charts that Qlik has to offer. From Bar Charts to Scatter Plots, we’ve covered a... Show MoreThroughout my series of blogs, we have been taking a look at the many charts that Qlik has to offer. From Bar Charts to Scatter Plots, we’ve covered a good portion of the catalog, but today we’ll be looking at an option that can work in conjunction with every chart or sheet; Filter Panes.
Filter Panes display dimension values to enable the precise selection of data. This means that you can design a filter plan, assign it a field and then you can filter your data through that field. Let’s look at a few examples to better understand what filter panes can do and how they can transform, learn, make discovers and answer questions about our data, sheets, and visualizations!
Here we have a screenshot of the Overall Equipment Efficiency app on the Qlik Demo site.
The purpose of this set of treemaps is to visualize Breakdown by Machine and Breakdown by Cell, as shown by their titles. As we can see, these treemaps are comprised of many intersecting data values, such as the machine, the type of machine, the shift type, and time frame.
Let’s put ourselves in the shoes, or work boots, of a factory manager. While this would be great for getting an overview of how the machines we’re responsible for are running, we might want a more specific picture, filter panes would be a great solution.
By adding a few filter panes to the sheet, we can drill down to our desired data. Let’s say we only want to view the Rolling machines, during the afternoon shift, with two clicks, our data has been filtered down and our three rolling machines are on display.
Diving even further, we can select the time period, such as February of 2023.
Again, our visualizations will update to reflect our selections.
One of the great things about filter panes, is that they are not limited to just one selection per filter pane. Let’s say we want to get an idea of how often the rolling machines breakdown compared to the forming machines, we can do that with filter panes!
With these selections made, we can quickly gather two insights. The first is that we only have three rolling machines compared to the five forming machines. Next, we can see that three of the forming machines are over 75% efficiency, whereas only two-thirds of the rolling machines are at the threshold. Keep in mind, these selections are not interfering with the app with the selections cleared, if I were to cancel my selections made within my filter pane, the app would return to the original state.
Filter panes also take advantage of the associative selections model.
In the screenshot above, we are given four examples of the associative selection states. We can see that 2023, February, and Forming and Rolling are in a selected state, shown colored green and with a checkmark. Both shift types are white, showing they are possible selections. The light gray for Jan in the month filter pane shows that it could be an alternative selection to the selected Feb. Last, we have the dark gray 2023, to show that that selection has been excluded from our visualization. The associative selections allow for a quick view of the selections made and the data presented, helping users gain insights on their data.
This has been an overview of filter panes as offered by Qlik. If you would like to learn more about how you can customize a filter pane, Jennell McIntire has written blog entries on the new updates for filter panes, and how users can customize their filter panes.
-
Qlik Data Integration Client-Managed Releases in November 2023
Qlik Replicate November 2023 General Availability Release November brings us to autumn/fall with darker winter nights approaching, and in some countri... Show MoreQlik Replicate November 2023 General Availability Release
November brings us to autumn/fall with darker winter nights approaching, and in some countries there will be bonfires and fireworks that can bring frights and bangs to many an excited crowd, against the cold, dark night air.
This release of Qlik Replicate November 2023 helps to minimize the frights and keep the lights on to protect against the dark. Security is always top of mind for IT depts around the globe, and this release sees some serious enhancements across endpoints.Security enhancements
- Snowflake targets (Google, AWS, and Azure) support for OAuth2 authentication - OAuth offers a more secured method of authentication compared with using native accounts and is becoming the preferred option for many organizations
This builds a solid foundation to support OAuth in many more endpoints. Stay tuned for further announcements in upcoming releases - Kafka target support for certificate + username and password authentication
- A new Certificate + Username and password authentication option has been added to the configuration options securing publishing data schemas to Confluent Schema Registry
- Amazon S3 and Amazon Redshift Targets support for IAM Roles Anywhere
- IAM Roles Anywhere can now be selected as the Access type for Amazon S3 Staging and Amazon S3 Storage within the configuration options for these endpoints
- MySQL-based targets support SSL - It is now possible to connect via SSL for all MySQL based target endpoints
New Endpoints and enhancements
- New - Microsoft Data Fabric target endpoint
- We are really excited to announce the ability to support replication from any supported source to Microsoft Fabric Synapse Data Warehouse. Note: Microsoft Fabric is currently in Public Preview and further updates may be required when it reaches GA
- New - Google Cloud SQL for SQL Server source endpoint
- This version introduces support for replicating data from Google Cloud SQL for SQL Server to any supported target.
- New - Confluent Cloud target endpoint
- This version introduces support for replicating data from any supported source to Confluent Cloud.
- Enhanced - Google BigQuery target endpoint
- Removed the dependency of having Google Cloud SDK installed.
Qlik Replicate May 2023 General Availability Release
Continuing the security enhancements, we are excited to announce a long awaited ability in Qlik Enterprise manager for more granular access control at an endpoint level.
From Qlik Enterprise Manager November 2023, it is now possible to set user permissions for a specific endpoint, both for individual users and for groups.As always, each new release is fully supported for two years. To find out more, please visit the Downloads and Release Notes section on Qlik Community.
We hope you enjoy using Qlik Data Integration products and would love to hear your feedback and success stories, especially in any improvement gains you achieve.
To learn more about what 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 the Community and filter “Product Category” by “Qlik Data Integration”, and then select the product and the versions you would like to download.
Note: For most products, selecting “Latest release and patch” under the “Show Releases” should be enough.
If required, you can filter further by selecting the latest “Release” and/or Service Release (SR) version under “Release Number”.
For additional help in using the downloads site - watch this handy video guide here:
How-to-download-Qlik-Products - Snowflake targets (Google, AWS, and Azure) support for OAuth2 authentication - OAuth offers a more secured method of authentication compared with using native accounts and is becoming the preferred option for many organizations
-
Techspert Talks - Using Kafka with Qlik Replicate
Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insi... Show MoreHi everyone,
Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.
The Techspert Talks session from November looked at Using Kafka with Qlik Replicate.But wait, what is it exactly?
Techspert Talks is a free webinar held on a monthly basis, where you can hear directly from Qlik Techsperts on topics that are relevant to Customers and Partners today.In this session, we will cover:
- How Replicate works with Kafka
- Kafka terminology
- Configuration best practices
Click on this link to see the presentation
-
Situational Awareness
Situational AwarenessQlikThe application focuses on the 17 high threat diplomatic missions, based on the State Department's directorate within the Dip... Show MoreSituational AwarenessQlikThe application focuses on the 17 high threat diplomatic missions, based on the State Department's directorate within the Diplomatic Security Service (DSS). The application analyzes data from multiple sources, including data from the Global Terrorism Database and the Department of State website, to provide the user a complete picture on situational awareness.Discoveries
The #1 category of weapons used by terrorists are explosives. Also, the vast majority of terrorist incidents are not linked to any terrorist group.
Impact
The app helps enabled diplomats to gain a better understanding of terrorist activities within their respective regions across the globe.
Audience
It could be used by Department of State, or any government entity.
Data and advanced analytics
It allows for an easy and fast way to do in-depth analysis on terrorism.
-
Apple Health App
Apple Health AppClimber UKThis is an app which I developed for the purpose of analysing my health data on a daily basis taken from my Apple Watch and ... Show MoreApple Health AppClimber UKThis is an app which I developed for the purpose of analysing my health data on a daily basis taken from my Apple Watch and Apple Health App. Here I can look at my calories, step count, and look at routes of my daily exercise.Discoveries
I discovered that only certain sports such as running are most beneficial for me with burning calories.
Impact
The impact of this app has made me go out on a daily basis for exercise, to keep up my interest in analysing my health data
Audience
this is a social app, so it's audience can be anyone who is interested in their health statistics.
Data and advanced analytics
This doesn't have any advanced analytics involved. It does use REST APIs to load the data in however.
-
Qlik Gears Up for Hybrid and Multi-Cloud Data Integration
Data Lineage and Impact Analysis With data lineage at the field and dataset levels, data and analytic users can enhance their understanding of the dat... Show MoreData Lineage and Impact Analysis
With data lineage at the field and dataset levels, data and analytic users can enhance their understanding of the data’s origins and how it has transformed throughout the data pipeline. With this latest release, Qlik Cloud Catalog automatically captures dataset and field lineage within the context of a Qlik Data Integration pipeline, bringing more transparency and enhancing trust in data-driven outcomes for data and analytic users.
Additionally, impact analysis on the data pipeline artifacts facilitates proactive exploration of “what-if” scenarios, allowing for a comprehensive assessment of how changes in the source system may impact downstream data pipelines and transformations. This proactive approach aids in the prevention of potential issues before they occur.
Expanded Replication and Cloud Targets
Qlik Cloud Data Integration will gain expanded replication abilities for use cases like data sharing, synchronization, and incremental ETL. Microsoft SQL Server and Amazon S3 will be supported as targets for replicated data. To enable connectivity with private networks, QCDI can be configured with Qlik's data movement gateway’s private link capabilities when accessing data on the Microsoft Azure cloud platform.
Broader Native Data Type Support
Qlik Cloud Data Integration will also remove limitations on replicating complex data types like timestamps, geospatial data, and binaries from source systems. This builds on Qlik Cloud Data Integration’s native support for data types commonly found in modern data platforms. Users will be able to replicate a broader set of data "as-is" without needing to convert or approximate data types within pipelines.
Databricks Unity Catalog Integration
Additionally in November, Qlik Cloud Data Integration will integrate with Databricks Unity Catalog for centralized metadata management. Qlik users will be able to discover, understand, and gain insights into data objects and lineage created by Qlik Cloud pipelines for data in the Databricks Lakehouse Platform. This paves the way for expanded governance and collaboration on analytics projects as users implement Databricks as their data lakehouse.
With Qlik Cloud Data Integration’s roadmap centered on broader replication, incremental loading, and multi-cloud support, Qlik continues to be an enterprise leader in hybrid and multi-cloud data integration. By adding sophisticated data lineage, governance, and enhanced delivery functionality, QCDI will allow customers to confidently scale their analytics programs across complex cloud environments.
You will see these updates in your Qlik Cloud Data Integration tenant when they are available on November 7th, 2023. If you don't yet have access to Qlik Cloud, why not take a guided tour and experience the value it can bring by yourself here?
-
Feature Updates
New features are always being added to Qlik Sense. Today I will provide an update on three topics I have blogged about this year. The topics are: NL ... Show MoreNew features are always being added to Qlik Sense. Today I will provide an update on three topics I have blogged about this year. The topics are:
NL Insights
The NL Insights object, which use to be found in the Dashboard bundle, is now a standard chart object. It now “fully supports the Qlik Cloud UI in multiple languages, accessibility requirements, and reporting / exporting.” The functionality of the NL Insights object has also been updated so that it is easier to add insights for the visualizations in an app by allowing developers to simply select a chart they would like interpreted. Once a NL Insight object is added to a sheet, the developer can click on the Add chart button to see a list of objects that are on the current sheet. Natural language insights will be shown for the selected visualization. This is easier for the developer and removes the need to manually select dimensions and measures.
Filter Pane
At its basis, the filter pane provides a list box that the user can use to make selections. By default, when a user makes a selection in a filter pane, the selection toolbar pops up prompting the user to confirm the selection, as seen in the image below.
It is now possible to turn off the selection toolbar and immediately confirm the selection when it is made. This can be done in the properties window by unchecking the Show selection toolbar checkbox. This is useful if the filter pane is displayed as a grid, versus column, and the filter pane is being used as a button bar.
Note that when the selection toolbar is off, users can still access the select all, select alternative and select excluded options via the sheet toolbar.
Straight Table
The straight table can now be downloaded as an image or multi-page PDF up to 50 pages. Simply right-click on the straight table, select Download and click on Image or PDF.There are always new features being added to Qlik Cloud. Use Qlik Help to stay up to date or subscribe to the news feed.
Thanks,
Jennell
-
Self-Service Reporting Now Available in Qlik Sense SaaS (Updated)
As we continue to enhance our analytic experience in the cloud and deliver on our Active Intelligence vision, we’re excited to announce that we have n... Show MoreAs we continue to enhance our analytic experience in the cloud and deliver on our Active Intelligence vision, we’re excited to announce that we have now released our first scheduled reporting capability in Qlik Sense SaaS. This new capability allows users to schedule the delivery of a chart or sheet containing their data of interest (filtered), and have it emailed to themselves in a PDF format.
Click here for video transcript
This new capability provides a number of scheduling options: users can subscribe to a chart of sheet (with current selections applied), and schedule for distribution via email (monthly or weekly, with preferred day configuration and target time). That email contains a link back to the subscribed content in the app and includes a PDF attachment. Emails for charts also contain an embedded snapshot of the visualization. Users can manage subscriptions right in their Hub settings: view details of their subscriptions, go to the subscribed content in the app through view-in app option, send now, disable or delete.
Tenant administrators have the ability to enable or disable subscriptions at the tenant level, as well as view tenant subscriptions, disable or delete.
As part of this new release, users will benefit from an improved sheet export function that includes sheet title and header information, as well as support for Qlik Theme formatting delivering a polished PDF output.
This is the first of several enhancements for reporting in SaaS in 2021.
Update: Now also available, a new distributed reporting capability where a subscription to a chart or sheet can be shared with other Qlik users who have access to the application. It is a powerful extension of our schedule export capability, allowing users to distribute "flash style" exports, using the Qlik Sense sheet or Visualization to other Qlik users. See it in action in our "SaaS in 60" video update.
Subscribe to the RSS feed on our helpsite to stay informed on “What’s new”.
-
Autumn term is well under way in the UK!
Last Thursday we ran a session for students studying Digital Marketing at the University of Sheffield. We had around 80 students using Qlik Sense and ... Show MoreLast Thursday we ran a session for students studying Digital Marketing at the University of Sheffield. We had around 80 students using Qlik Sense and building their first application. The session was lead by Qlik Technical Trainer - Wolfgang Kellner with support from Curriculum Developer - Sara Del Pino. This is a session we run with the students every year and we had some great feedback and interesting follow up questions, both about software functionality and the future of analytics and AI.
On Friday I spoke to a class taught by one of our Educator Ambassadors, Nassir Ibrahim, at Birmingham City University. These students are Final Year BSc Business Information Technology students, and during their course they must complete an assignment within Qlik Sense to solve a real world business problem. Students on this course always excel at engaging with Qlik and building amazing applications, we have even had one of Nassirs's students present on an EMEA webinar earlier on this year.
This week we kicked off the first of two sessions for Birmingham City University's Grad+ programme. Graduate+ is an award framework designed to give students the opportunity to gain additional skills outside of their courses to help them secure employment after university. This is a partnership that launched in 2019 and is still going strong today. Students can earn 3 different award levels based on various courses they can take as part of the Qlik Academic Program. Every year we present Qlik and the Academic Program to students eager to learn how to differentiate themselves and upskill.
In the coming weeks we have even more sessions, if you're interested in having us speak to your students get in touch! and if you'd like more information about the Qlik Academic Programme, visit out website: Qlik.com/academicprogram
