Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
About 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
-
Find Support on Qlik's New Customer Portal!
On Monday, July 15, Customers can find their new home for Qlik Support on Qlik's Customer Portal (more details here). All case inquiries will be redir... Show MoreOn Monday, July 15, Customers can find their new home for Qlik Support on Qlik's Customer Portal (more details here). All case inquiries will be redirected to this platform for streamlined self-service support needs.
To prepare for launch, our current Case Portals and Support Chat will be unavailable from Saturday, July 13 at 2:00 a.m. EST to Monday July 15, at 8:00 a.m. EST. If you are experiencing a high severity issue at this time, please reach out to us via support@qlik.com or through our phone numbers.
We look forward to bringing you easier ways to do business!
Qlik Global Support
-
Qlik Cloud ６月の新機能
プラットフォームナビゲーションの変更 画面左上の新しいナビゲーションメニューをクリックすると、どこからでもアクティビティセンターにアクセスでき、スムーズに画面移動ができるようになりました。 あらかじめ管理コンソール＞設定＞機能コントロールの「新しいプラットフォームナビゲーション」をオンにする必要があ... Show Moreプラットフォームナビゲーションの変更
画面左上の新しいナビゲーションメニューをクリックすると、どこからでもアクティビティセンターにアクセスでき、スムーズに画面移動ができるようになりました。
あらかじめ管理コンソール＞設定＞機能コントロールの「新しいプラットフォームナビゲーション」をオンにする必要があります。
画面左上のナビゲーションメニューをクリックするとアクティビティセンターが開き、移動先を選択できます。アプリを開いている時も同様です。
分析の新機能
新しいアプリケーションバー
アプリケーションバーが新しくなり、アプリに関する各種操作とシートに関する各種操作の指定が変わりました。バーにあったブックマークはアセットパネルに移動しました。
チャートのメニューの非表示
チャートを右クリックして表示されるメニューを、非表示とすることができるようになりました。
オンデマンド表形式レポート
アプリの分析画面で、Web ブラウザから直接レポートをダウンロードすることができるようになりました。アプリの現在の選択状態と、ユーザーのアクセスレベルを引き継いだデータでレポートが作成されます。レポートフィルターは適用されません。
- あらかじめレポートのテンプレートをオンデマンド用にアクティブにしておく必要があります。共有スペースの編集可能、管理スペースでの所有者、管理可能、操作可能の権限が必要です。
- レポートの生成には、共有スペースで閲覧可能以上、管理スペースでビューの制限以上の権限が必要です。
- レポートサービスのサブスクリプションを消費します。
その他
- Visualization bundle のピボットテーブルでセルの値をコピーできるようになりました。
- アプリの自動化に Amazon DynamoDB コネクタが追加されました。
- Marketo コネクタ（ODBCベース）が追加されました。
データ統合の新機能
Qlik データゲートウェイーデータ移動 新バージョン（2023.11.23)
Snowflake にメタデータスキーマがない場合、作成されます。
その他、いくつかの問題が解決されています。
プロジェクト レベルのデータ ビュー
プロジェクトパイプラインの画面から、各タスクのメタデータとデータサンプルを表示できるようになりました。複雑なデータ パイプラインのトラブルシューティングが効率化することができます。
この機能を使用するユーザーには、データ接続が存在するスペースで [データ表示可能] 、データ プロジェクトが存在するスペースで [表示可能] の役割が割り当てられている必要があります。
レプリケーションプロジェクトの新しいターゲット
データレプリケーションタスクを作成する際に、Snowflake、Databricks、Microsoft Fabric、Google BigQuery、Amazon Redshift、Azuzre Synapse Analytics のクラウドデータウェアハウスターゲットを選択できるようになりました。
AI によるSQL アシスタント
SQL アシスタントが Qlik Cloud Data Integration のデータ変換機能の一部として利用可能になりました。SQL アシスタントは、SQLクエリをより簡単に記述できるco-pilot機能です。実施したい変換を事前言語で記述すると、AI SQLアシスタントがSQLクエリを作成します。
初期リリースはアメリカ、アイルランド、フランクフルト、シドニーで利用可能です。
-
Join Us Live! Q&A with Qlik: New to Qlik Cloud
Don't miss our next Q&A with Qlik! Pull up a chair and chat with our panel of experts to help you get the most out of your Qlik experience. If yo... Show MoreDon't miss our next Q&A with Qlik! Pull up a chair and chat with our panel of experts to help you get the most out of your Qlik experience.
If you’re new to Qlik Cloud, let our Qlik experts help you navigate and better understand how to get started finding data insights with Qlik Cloud.
Not able to make it live? Don't worry! All registrants will get a copy of the recording the following week.
See you there!
Qlik Global Support
-
Navigating Qlik Cloud's newest user experience. Better findability, smoother nav...
Today, users will navigate a smoother journey across our entire Qlik Cloud platform, unifying both Qlik Cloud Analytics and Qlik Talend Cloud. We have... Show MoreToday, users will navigate a smoother journey across our entire Qlik Cloud platform, unifying both Qlik Cloud Analytics and Qlik Talend Cloud. We have balanced aesthetics with functionality to create an experience that is both visually appealing and highly usable. Let's take a look…
The waffle menu is your navigation anchor
Meet the new top-left "waffle" menu, your consistent navigation anchor throughout Qlik Cloud. This feature enhances findability by offering easy access to your "recent" assets, ensuring you always know where you are and where you can go next. Whether you're diving into automations or exploring AutoML, the waffle menu is always within reach.
An Activity Center tailored for your tasks
Our new Activity Centers are now more activity and goal-driven, providing creators with upgraded tools and a comprehensive capabilities page. This streamlined space is designed to help you understand and optimize your efficiency without the clutter of unnecessary buttons.
***Please note that these Activity Center navigation updates can be toggled on or off for two months, until the beginning of September, giving your organization the necessary time to become familiar with and aware of the new design.
📹 See how to toggle on and off hereCustomizable sheet navigation
Navigating through numerous sheets in an app can be daunting. Our improved sheet navigation allows you to organize sheets into groups, making it easier to manage and publish them. You can now create, rename, delete, and publish groups and individual sheets, addressing one of our most requested features.
Insight Advisor chat now helps without disruption
We've redesigned the Insight Advisor chat to improve usability, allowing you to get help without leaving your current context. This update makes it easier to author analyses and boosts awareness and usage of chat and search features as we roll out even more NLP capabilities.
Improved search functionality
Finding content has never been easier with our significantly upgraded search functionality. This enhancement streamlines the process of navigating and locating the assets you need, saving you time and effort.
Expanded Catalog and public collections
Our Catalog now supports a wider range of asset types, catering to both analytics and insight-seeking users. You can add these assets to public collections or a custom tenant-wide home page in the Insights Activity Center, with options like public monitored charts (coming soon) and links to sheets.
New panel design and sheet grouping
The side panel design consolidates sheets, bookmarks, and more into one place, offering various size options and better content organization. Additionally, the new sheet grouping feature simplifies navigation for apps with many sheets and allows for bulk publishing, enhancing both private and public sheet management.
The redesigned Data Integration ‘Home’
***Coming soon
Soon, we'll début a new Data Integration 'Home'. We've taken the best of both worlds, combining the previous 'Getting Started' and 'Home' pages into a single, cohesive destination. It's like having your favorite coffee shop and office rolled into one - everything you need, right where you want it. As you grow from novice to expert, you can customize your view, hiding the 'Getting Started' section when you're ready. But don't worry, this page will always remain your launchpad for all things Data Integration.
With quick access to your recent work and important notifications front and center, this is one 'Home' improvement you won't want to miss!
To learn more about these updates check out the links below:
- Qlik Cloud's New Look | Support Blog
- ‘What’s New in Qlik Cloud’ | Help Page
Videos: -
Check Out Qlik Cloud's New Look!
The revamped Qlik Cloud experience includes an enhanced left side navigation menu, new activity center, sheet grouping, and custom navigation. This ne... Show MoreThe revamped Qlik Cloud experience includes an enhanced left side navigation menu, new activity center, sheet grouping, and custom navigation.
This new platform navigation is available to those with Qlik Cloud; however, system administrators will need to turn on the feature in their Management Console Settings:
- Under Management Console, select Settings
- Scroll Down to the Feature Control Setting
- Select the Toggle for New Platform Navigation
- A message will appear prompting Admins to reload for the updated experience.
Note: These navigation updates can be toggled on or off for the remainder of the summer to give your organization time and practice with the new design. Come September, this will become Qlik’s default setting.
With the toggle on, you can now leverage the left side waffle menu as your guide, so key product features are always easily accessible.
Additionally, users can see improved sheet navigation capabilities in their analytics apps alongside other assets like bookmarks and notes.
Check out more highlights from this launch here:
Happy exploring!
Qlik Global Support
-
Data Load Editor Improvements
There have been some data load editor improvements that I think are worth mentioning so in this blog post I will cover some of the new features in the... Show MoreThere have been some data load editor improvements that I think are worth mentioning so in this blog post I will cover some of the new features in the data load editor that I have found useful. The first, and my favorite new feature, is the table preview. The second is the ability to do a limited load and load a specified number of rows in each table. The third feature I will cover is the ability to view the script history, as well as the option to save, download and restore previous versions. Let’s look at each of these in more detail.
When building an app, my preference is to use the load data editor to load my data. With table preview, I can view loaded data tables at the bottom of the data load editor after data has been loaded or previewed in an app.
This is my favorite new feature because nine times out of ten, I want to view the data I loaded to ensure it loaded as expected and to check that my logic is correct. Having the preview table right there in the data load editor, saves me from having to go somewhere else, like the data model viewer or a sheet, to view the loaded data. I can use the preview table to check that they have the desired results. The ability to do this quick check saves me time.
As a developer, I can select the table to preview, and the data can be viewed as a table, as seen above, or as a list or grid as seen in the images below. When previewing the data as a table, the preview table can be expanded to show more rows, columns in the table can be widened and there is pagination that allows me to move around in the table. There is also an option to view the output of the load. This will show the same info you see in the load data window when the app is reloading.
List View
Grid View
The second feature in the data load editor I find useful is the preview data option. This provides an easy way for me to load some, but not all, of the data when reloading. In the screenshot below, the default of 100 rows is entered. This will load a max of 100 rows in each table. This value can be edited if desired. By default, the use store command is toggled off. When this is off, store commands in the script are ignored preventing potentially incomplete data from being exported. This feature is helpful when I want to just profile the data and see what the data looks like. It can also be helpful when there is a lot of data to be loaded and I do not need to load it all to check that the script is working as expected. Again, this is another time saver because I can limit the load thus the time it takes for the app to reload in a single step. I find this helpful when I want to quickly test a change in the script but do not want to wait for the entire app to reload.
The last data load feature I am going to cover is history for scripts. This new capability allows me to create versions of the script, name and rename scripts, restore the script from a previous version, download the load script or delete a version of the script.
I have not used the history feature much, but I can see it being helpful when I want to name various versions of the script. Every time the script is edited, it is saved to the current version. At any time, I can save that current version giving it a meaningful name. Maybe I want to make some changes to the script but want to have a backup in case it does not work. This can be done now right in the data load editor. I also have an easy way to restore a previous version, if necessary. Once a version is named, it can be renamed, restored, or deleted. All script versions can be downloaded as a QVS file. One thing to note is that the history only saves scripts created in the data loaded editor.
Hopefully, you find these new data load editor features helpful. They are available now in your tenant. Just check out the data load editor in your app.
Thanks,
Jennell
-
Bookmarks
Bookmarks allow users or developers to save a selection state in an app. They are useful when a user would like to save their selections in an app to ... Show MoreBookmarks allow users or developers to save a selection state in an app. They are useful when a user would like to save their selections in an app to view later or to share with others. For developers, bookmarks are useful if you would like to redirect a user to a specific sheet, with selections, when they open an app.
Let's begin by looking at how to create a bookmark. First, go to the sheet that you would like to bookmark and make sure your selections are already made. Then click on Bookmarks in the toolbar.
The Bookmarks window will open showing any bookmarks that have already been created. There is also a Create new bookmark button that can be clicked to create a new bookmark. After clicking the Create new bookmark button, the Create bookmark dialog window opens.
Here is where you can give the bookmark a name, add a description, and set some optional settings. By default, the Save sheet location is checked. This will save the sheet you are on when you created the bookmark and will navigate the user to this sheet when the bookmark is applied. The Save layout option will save the layout of the sheet and will apply that layout when the bookmark is applied. This is useful if you have made any layout changes on the sheet, such as expanding a pivot table or sorting a chart and want the bookmark to maintain the layout. The last option is to Save variable state in bookmarks. This option will save the current state of any variables when this bookmark is created. Once the bookmark is created, the user can use it at any time to return to the bookmarked state.
Let’s look at some other options that are available when you right click on the name of a bookmark.
- Apply bookmark – will apply bookmark selections and layout and clear any previous selections.
- Apply selections only - will just apply the selections of the bookmark to the app, clearing any previous selections. It will not apply any layout settings if they were saved with the bookmark.
- View details – will show the details of the bookmark.
- Copy link - will copy the URL for the bookmark so that it can be shared with others. Note, the bookmark will need to be made public before it can be shared. If you make a bookmark public, anyone can see and use it and you are no longer the owner, unless it is made private again.
- Set as default bookmark - will redirect users to the sheet, layout and selections that are saved in the bookmark when the app is opened (instead of the app overview).
- Delete – will delete the bookmark.
There are also many ways to apply a bookmark. A bookmark can be applied from the app overview by clicking Bookmarks or the toolbar of a sheet. A bookmark can be indirectly applied by using a button, for instance, and setting the action to apply the bookmark.
Bookmarks can also be used in set analysis expressions and applied to a visualization. In the expression editor, the bookmark can be inserted as seen below or can be used by name.
Example expressions using the bookmark name:
These expressions will apply the bookmark to the chart, much like when you use set analysis.
A bookmark can be edited if the name, description, or selections in the bookmark need to change. There is no longer the need to delete and create a bookmark if a change needs to be made to the selections. To edit a bookmark, click on the Bookmarks button in the toolbar and then click the Details icon next to the bookmark you would like to edit or right click on the bookmark and select View details.
From the details view, you can select the edit icon to make changes to the name or description of the bookmark. Once done, you can click the check mark to stop editing or the update icon to also update the bookmark with the current selections.
Also note that possible alternate states are visible when editing a bookmark. If there were selections made in these states when the bookmark was created, they will be visible here as well. Users have the option to copy the set expression for the bookmark if they would like to use it elsewhere in the app.
Bookmarks are a great tool for your own personal use but also for collaboration. They are easy to create and edit and take the legwork out of remembering what selections were applied when you want to return to a previous viewed state or share an insight with a colleague. Check out Qlik Help to learn more.
Thanks,
Jennell
-
Techspert Talks - Upgrading PostgreSQL Repository Troubleshooting
Hi everyone, Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand ins... Show MoreHi everyone,
Want to stay a step ahead of important Qlik support issues? Then sign up for our monthly webinar series where you can get first-hand insights from Qlik experts.The Techspert Talks session from July looked at Upgrading PostgreSQL Repository Troubleshooting.
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:
- Using the Qlik Sense QPI tool
- Upgrading a Stand-Alone Database
- How to resolve common issues
Click on this link to see the presentation.
-
Qlik Sense Enterprise for Windows - New Security Patches Available Now
Edited 20th of May 2024: Added recently assigned CVE number.Edited 22nd of May 2024: Added to the Frequently Asked Questions. Hello Qlik Users, A se... Show MoreEdited 20th of May 2024: Added recently assigned CVE number.
Edited 22nd of May 2024: Added to the Frequently Asked Questions.Hello Qlik Users,
A security issue in Qlik Sense Enterprise for Windows has been identified, and patches have been made available. Details can be found in Security Bulletin High Severity Security fixes for Qlik Sense Enterprise for Windows (CVE-2024-36077).
Today, we have released eight service releases across the latest versions of Qlik Sense to patch the reported issue. All versions of Qlik Sense Enterprise for Windows prior to and including these releases are impacted:
- February 2024 Patch 3
- November 2023 Patch 8
- August 2023 Patch 13
- May 2023 Patch 15
- February 2023 Patch 13
- November 2022 Patch 13
- August 2022 Patch 16
- May 2022 Patch 17
No workarounds can be provided. Customers should upgrade Qlik Sense Enterprise for Windows to a version containing fixes for these issues. May 2024 IR, released on the 14th of May, contains the fix as well.
- May 2024 Initial Release
- February 2024 Patch 4
- November 2023 Patch 9
- August 2023 Patch 14
- May 2023 Patch 16
- February 2023 Patch 14
- November 2022 Patch 14
- August 2022 Patch 17
- May 2022 Patch 18
This issue only impacts Qlik Sense Enterprise for Windows. Other Qlik products including Qlik Cloud and QlikView are NOT impacted.
All Qlik software can be downloaded from our official Qlik Download page (customer login required). Follow best practices when upgrading Qlik Sense.
The information in this post and Security Bulletin High Severity Security fixes for Qlik Sense Enterprise for Windows (CVE-2024-36077) are disclosed in accordance with our published Security and Vulnerability Policy.
Frequently Asked Questions
Q: What steps can be used to reproduce the vulnerability?
A: Qlik will not be providing steps on how to reproduce this test case.Q: What authentication method is affected?
A: Qlik strongly recommends moving to a patched version as per the bulletin, regardless of the authentication method used.Q: Will Qlik Sense February 2022 or earlier be patched?
A: See the Qlik Sense Enterprise on Windows Product Lifecycle (link) for information on what versions of Qlik Sense have reached End of Service (EOS). Versions which have reached EOS will not receive patches and Qlik strongly recommends moving to an up to date release.The Security Notice label is used to notify customers about security patches and upgrades that require a customer’s action. Please subscribe to the ‘Security Notice’ label to be notified of future updates.
Thank you for choosing Qlik,
Qlik Global Support
-
Entitlement Analyzer for Qlik Sense Enterprise SaaS (Cloud only)
We are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! This application will enable you to answer questions like:... Show MoreWe are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! This application will enable you to answer questions like:
- How can I track the usage of my Tenant over time? How are my entitled users using the Tenant?
- How can I better understand the usage of Analyzer Capacity vs. Analyzer & Professional Entitlements?
The Entitlement Analyzer is only available for Qlik Cloud subscription types. Refer to the compatibility matrix within the Qlik Cloud Monitoring Apps repository for an overview of which monitoring app is compatible with which subscription type.
The Entitlement Analyzer app provides insights on:
- Entitlement usage overview across the Tenant
- Analyzer Capacity – Detailed usage data and a predication if you have enough
- How users are using the system and if they have the right Entitlement assigned to them
- Which Apps are used the most by using the NEW "App consumption overview" sheet
- And much more!
The Entitlement Analyzer uses a new API Endpoint to fetch all the required data and will store the history in QVD files to enable even better Analytics over time.
A few things to note:
- This app is provided as-is and is not supported by Qlik Support.
- It is recommended to always use the latest app.
- Information is not collected by Qlik when using this app.
The app as well as the configuration guide are available via GitHub, linked below.
- QVF: https://github.com/qlik-oss/qlik-cloud-entitlement-analyzer/releases/latest/download/entitlement-analyzer.qvf
- Release Notes: https://github.com/qlik-oss/qlik-cloud-entitlement-analyzer/releases/latest
- Installation Guide: https://github.com/qlik-oss/qlik-cloud-monitoring-apps/releases/latest/download/qlik-cloud-monitorin...
Any issues, questions, and enhancement requests should be opened on the Issues page within the app’s GitHub repository.
Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up to date with the latest Qlik Support announcements. Please give this post a like if you found it helpful!
Kind regards,
Qlik Platform Architects
Additional Resources:
Our other monitoring apps for Qlik Cloud can be found below.
- App Analyzer
- Reload Analyzer
- Access Evaluator
- OEM Dashboard (for OEM Partners and multi-cloud tenants)
-
Summer fun means Qlik Community enhancements!
Hello Qlik Community! Summer has officially kicked off here in the States! Does anyone have any exciting summer plans? My plan is to enjoy the local p... Show MoreHello Qlik Community!
Summer has officially kicked off here in the States! Does anyone have any exciting summer plans? My plan is to enjoy the local pool, travel on vacay to another pool, then come back to enjoy the local pool some more. 😄 Oh, and during that time, we will still be pushing out updates and enhancements!
Here are the enhancements for June:
Product Labels added to Release Notes page
Find all the posts related to Products on the Release Notes page!
Receive Notifications to Release Note Updates
A new setting has been implemented that allows users to be notified of updates to Release Notes.
Simplified breadcrumbs under Support
Now only shows the page your own and the Qlik Community homepage to lessen any confusion. Look for more cleanup in other areas throughout the year.
More updates to Email Notifications
We’ve been working on making the email notifications more organized and follow Qlik branding. We’ve removed the banner at the top of the email as it was having trouble with resizing and updated the @mention template.
Check back in a few weeks for our July enhancements as well as our contest winners!
Your Qlik Community Admins,
Melissa, Sue, Jamie, Nicole and Caleb
@Melissa_Potvin @Sue_Macaluso @nicole_ulloa @calebjlee
-
映えるダッシュボードを作っていますか？
Qlik のビジュアライゼーションはここ最近大きな進化を遂げました。Qlik Senseの最新機能を使えばユーザーをぐぐっとひきつける魅力的なダッシュボードを作り出すことができます。もちろん、エクステンション開発やHTML/CSS/JavaScripptの記述は不要！すべてQlik Senseの標準... Show MoreQlik のビジュアライゼーションはここ最近大きな進化を遂げました。Qlik Senseの最新機能を使えばユーザーをぐぐっとひきつける魅力的なダッシュボードを作り出すことができます。もちろん、エクステンション開発やHTML/CSS/JavaScripptの記述は不要！すべてQlik Senseの標準機能だけで実現できます。
下記のアプリケーションは標準機能100%で開発しています。
エクステンションなど使用しなくても、ご覧の機能で、自由なデザインのダッシュボードを作ることができます。今回のWebセミナーではこのようなアプリを作成するための映える機能とテクニックを一気にご紹介しました。
特にレイアウトコンテナーを使用すると自由でおしゃれなシートデザインが可能となります。
- グリッドにかかわらず、オブジェクトを自由形式で配置できます。
- オブジェクトは、重ねたり、積み上げたりできます。
- オブジェクトは条件によって、表示・非表示を切り替えることができます。
Webセミナーではさまざまなデザインのアプリケーションの例もご紹介しています。
セミナーの動画・資料はこちらからご覧いただけます。
【緊急企画】映えるダッシュボードを作ってますか？～ Qlik で作成する驚くほど美しいデータ分析～
冒頭の動画でご紹介しているアプリのメニューによる画面切り替え部分のみ含んだサンプルアプリを添付します。ご参考にしてください。
-
Summer is the best time to... LEARN!
Discount inside Catching up and learning what you need to improve your Qlik Sense skills is always easier in the summer. Our course catalog is evolvin... Show MoreDiscount inside
Catching up and learning what you need to improve your Qlik Sense skills is always easier in the summer.
Our course catalog is evolving, and we will stop offering some of our courses that will only be available for private training. If you are interested in any of these courses, I recommend you book your spot today because you won’t see them again:
- QlikView Designer
- QlikView Developer
- Qlik Sense for QlikView Developers
- Big Data Solutions with Qlik Sense
- Qlik Geoanalytics
- Embed Analytics with Qlik Sense APIs
- Foundations of Qlik Data Integration
Plus, if you join any of our public courses during July and/or August, this year comes with a reward! You can enjoy a 30% discount by booking your spot on our website and using the code CLASSROOM30 at checkout.
Don't miss this chance to learn and save!
-
Release Cadence Update: Qlik Sense Enterprise Client-Managed
Beginning with the May 2024 release, Qlik Sense Enterprise Client-Managed will release two major releases a year (May and November). This adjustment ... Show MoreBeginning with the May 2024 release, Qlik Sense Enterprise Client-Managed will release two major releases a year (May and November).
This adjustment aligns our release cycle with the preferred cadence of our customers, enhancing communication around our major releases. Qlik continues to add new functionality to Qlik Sense Client-Managed versions following their initial release to the cloud. As always, we will continue to deliver patches as needed under our Release Management Policy.
We look forward to helping you optimize your release experience. Be sure to follow the release notes area in Qlik Community and review our updated policy.
-
Goodbye Qlik Continuous Classroom, hello Qlik Learning!
Discount inside Not everything good has to end—it can transform! We’re saying farewell to Qlik Continuous Classroom and welcoming Qlik Learning, the n... Show MoreDiscount inside
Not everything good has to end—it can transform! We’re saying farewell to Qlik Continuous Classroom and welcoming Qlik Learning, the new self-paced learning platform from Qlik that combines content from Qlik and Talend to give you the best learning experience possible.
But Qlik Continuous Classroom isn’t leaving without a special farewell offer: get a fabulous 20% discount on your subscription if you purchase it before August 30th. Search your subscription and use the coupon discount code SELFPACED20 at checkout.
The best part? When it’s time to say goodbye to Qlik Continuous Classroom, your subscription will automatically transfer to the new platform, letting you enjoy all its benefits without interruption.
Decide now and save.
Don’t miss out on this opportunity!
-
June Qlik Digest
Welcome to the June Qlik Digest, where you can find all Qlik’s lates updates. Qlik Connect took place this month, we announced two exciting new solut... Show MoreWelcome to the June Qlik Digest, where you can find all Qlik’s lates updates. Qlik Connect took place this month, we announced two exciting new solutions, and much more!
Qlik Announces Qlik Talend Cloud and Qlik Answers!
We recently announced two new groundbreaking solutions at Qlik Connect!
- Qlik Talend Cloud delivers AI-ready data seamlessly. It is our new flagship offering, combining the best functionality of Qlik Cloud Data Integration, Talend Cloud, and Stitch Data.
- Qlik Answers is a plug-and-play, Generative AI-powered Knowledge Assistant that provides business users with personalized, contextually relevant answers to questions sourced from carefully curated unstructured content.
Check out what Tech leaders have to say about these new releases: Read The Press Release
Trusted Data: The Foundation of AI
On June 26h, join Qlik and Tim Zhou, Managing Director of AI at Accenture for a no-nonsense discussion about how to ensure you have the proper data foundation to put AI into practice. Alongside our host, renowned AI expert Ronald van Loon, we will discuss:
- The critical role of trusted data in AI success
- Practical strategies to build and maintain a solid data foundation
- Real-world examples of organizations driving AI with trusted data
Don't miss this opportunity to accelerate your AI journey by building the data foundations for success.
View The Qlik Connect Live Stream
Qlik Connect has officially come to an end, but you and your colleagues still have the chance to watch the livestream on-demand.
Curious what to expect while watching? First, you’ll get the inside scoop on Qlik’s vision, product roadmap, and outlook. Then, Qlik Executives, partners, customers, and industry insiders will dive into the best practices and applications for data, analytics, and AI that will make you a data dynamo. Finally, you’ll explore out-of-this-world insights with the former director of the James Webb Space Telescope.
The opportunities for excitement are endless, you won’t want to miss this!
Have you heard the news?
Qlik Learning has launched a super exciting deal for you:
30% discount on public training courses (discount coupon: CLASSROOM30)
20% off on Qlik Continuous Classroom subscriptions (discount coupon: SELFPACED20)
We've made it super easy for you to grab these amazing deals - just use the discount coupons on our website
-
Talend Data Fabric - Upgrade Notification, Java 17 compatibility for Talend 8 R2...
To our Talend 8 Customers, To enhance both your security and Talend experience, Java 17 will be the only supported Java version for future updates to ... Show MoreTo our Talend 8 Customers,
To enhance both your security and Talend experience, Java 17 will be the only supported Java version for future updates to Talend Studio and the following supported applications.
- Talend Studio
- Talend Administration Center
- Talend Data Preparation - (client managed installation)
- Talend Data Stewardship - (client managed installation)
- Talend SAP RFC Server
- Talend Semantic Dictionary
- Talend Identity and Access Management
Note: this upgrade does not impact execution of your artifacts that continue to support Java 8 or 11.
Previous versions of Java will no longer be supported by the above application when electing to upgrade to R2024-05. We are giving you this advanced notice to ensure you can plan this upgrade and take time to review your current Java environment. Java 17 support was first introduced with the R2023-10 release.
By giving this advanced notification, we are delighted to be able to reach a point of maturity where we can fully support best practices with dependencies and third-party libraries and be proactive in addressing CVEs to deliver constant improvement to the Talend Studio platform.
Compatibility Documentation:
For further questions please contact Qlik Talend Support and subscribe to the Support Blog for future updates.
Thank you for choosing Qlik,
Qlik Talend Customer Success
-
Get ready for the Simplified Authoring Experience in Qlik Sense SaaS
BackgroundAt Qlik, we continuously conduct user studies and interviews in order to improve our products. As a result, we took the initiative to build ... Show MoreBackground
At Qlik, we continuously conduct user studies and interviews in order to improve our products. As a result, we took the initiative to build out a fresh new authoring experience. As a Qlik Sense SaaS user, this may be no surprise, as you’ve likely seen announcements on the new features and improvements.
With Simplified Authoring, we set out to improve the first-time user experience, but as you’ll see, it also offers tremendous value for more experienced users. Enhancements are specifically targeted around creation of charts, exploring data, defining properties, and filtering.
You may recognize some of the concepts within Simplified Authoring from Knarr Analytics, which was acquired by Qlik in 2020, with mastermind Speros Kokenes leading R&D efforts. Knarr technology was also utilized to deliver Collaborative Notes, released in Qlik Sense SaaS last year.
The Simplified Authoring experience provides fast access of the most common creation elements, including properties, so all components will not be visible by default. However, the Advanced Authoring experience is just a click away for those who prefer the classic look and feel or need the full set of properties.
Fields and selection
Through the field panel, it’s now possible to expand and see the individual field values. Along with the values, you’ll also see a frequency count and a nice histogram. The fields include a symbol indicating whether it consists of strings, numbers, dates, or geographic values.
Based on customer feedback , we’ve changed the behavior of values, so you can now make selections while editing. You no longer have to switch back and forth to view mode to set the selection. The selection is indicated in the fields panel (note the indicator showing the selection when the field is collapsed) as well as the selection bar.
Data Properties
We’ve moved the data panel to the left, making it closer to the fields and charts. There are also multiple drop zones for dimensions and measures. You can decide whether to use the field as dimension, as a measure, or let Qlik Sense suggest on best use.
Visualization Properties
For your convenience, an auto chart is created by default upon entering the Simplified Authoring experience. The Autochart changes as you drop measures and dimensions as it chooses the most suitable visualization. If preferred, you can use the visualization properties to override and pick another chart. The panel holds a subset of all the most commonly used charts.
Note: Charts have different characteristics, so when switching between charts, different property options will be available.
Filters
The filter section is completely new. It provides chart-level filtering, which is practical, for instance, when you want to exclude a single dimension value. Chart filtering can also be done with set analysis, which very is powerful but may be too complicated for the casual user.
When a filter is applied, the footnote automatically shows a description of the filter. There are five types of filtering, which can be used to include or exclude field values:
- Pick dimension values
- String search for values
- Numeric comparison of values
- Numeric comparison based on an expression on another field
- Clear selection, where the chart ignores the current selection
The filters are only visible in Simplified Authoring and not Advanced Authoring. Under the hood the filtering is applied directly on the hypercube. We recommend you use either chart filtering or set analysis, but not both at same time.
Presentation Properties
The final panel, presentation properties, provides fast access to the most common settings for sorting, coloring, labeling, tooltips, and axis. It’s worth mentioning that the label styling now includes font size, color, style, and also font family, which has been requested by users like you. Moving forward, we will expand labeling capabilities.
Data Table
When we studied Qlik Sense SaaS usage data, we noticed that most users created a table with many fields, then after some time, removed that table. We understand the table was most likely used to inspect data. Therefore, when developing Simplified Authoring, we incorporated a data table with all fields to the bottom of the interface. Because it is not part of the canvas, the data table can be used as an aid in data discovery and as a reference when building out the dashboard. The table can be sorted, and yes, you can make selections on field values.
Smart Grid
We have also upgraded the grid. You’ll notice the “+” buttons to right and bottom, which allow users to create new objects with a single click. You can drag the borders to resize two charts simultaneously. On the top left, you can use the handle to drag objects into new positions, maintaining the size when possible.
Feedback
We had customers and partners trying out the new authoring experience during development and the response has been great so far. Here are some comments from participants in our early access program:
- Finance customer: “It's easy to understand and I really like the filter chart part. Toggling between charts to quickly test visualizations. The data preview is awesome!”
- Large retail customer: “The experience is very good, it will really help less experienced users a lot.”
- Partner: “Love the new layout, especially removing the complexity of set analysis. Nice job R&D”
What's next
As of July 5th, you can ask your tenant admin to turn on Simplified Authoring in the management console. In mid-August, the new authoring will go-live as the default experience for everyone using Qlik Sense SaaS. Simplified Authoring will be enhanced over time with additional improvements. We will continue to measure success and perform user studies to guide the development.
Available resources:
-
Analyzing customer churn using Qlik Sense & Amazon SageMaker.
In any subscription-based business model, one of the primary goals is to retain its customers. Also, with the increase in market competition, it is cr... Show MoreIn any subscription-based business model, one of the primary goals is to retain its customers. Also, with the increase in market competition, it is crucial to identify ‘unhappy’ customers at an early stage so as to provide additional benefits and retain them. Churn prediction refers to determining which consumers are most likely to abandon a service or terminate their membership. To be able to predict churn gives businesses the necessary edge since getting new customers is sometimes more expensive than keeping old ones.
Ref: https://www.opexengine.com/keep-customer-churn-rate-under-control-or-labor-like-sisyphus/
The application of Machine learning techniques to understand & predict customer churn isn’t something new. Several ML algorithms have been used in the field of telecom, banking, insurance, etc. to detect early churn signals. However, just relying on an ML algorithm’s output to understand whether a customer will churn or not isn’t really an optimal approach anymore. To have a thorough understanding of the churn analysis process, the need to amalgamate historical data(what happened in the past?) with the predicted outcome(what will happen in the future?) is paramount.
This is where Qlik Sense’s visual analytics platform serves as an effective solution. Now, using advanced analytics connectors within Qlik Sense SaaS, users can build a Machine Learning model in an AutoML platform, consume the predictions in Qlik Sense and use them along with the Qlik’s data model to take advantage of things such as:
- associative benefits
- faster calculations
- out-of-the-box visualizations
- perform what-if analysis
If you want to understand the entire workflow to integrate 3rd-party ML endpoints within Qlik Sense, I highly recommend going through this first part that I wrote a few days back. The generic workflow is depicted below.
In this specific tutorial, we are going to analyze customer churn behavior for a telecom company by building an end-to-end Qlik Sense app and leveraging both historical as well as predicted data. For building the Machine Learning model and hosting the endpoint, we will use the Amazon SageMaker platform. We will keep our focus on building the Qlik Sense app and not on developing the ML model.
Pre-requisite: To be able to use Analytics Endpoints the "Enable machine learning endpoints" parameter should be enabled in the Management Console.
Step 1: Load source data
First, let us load the source data into Qlik Sense using the Data load editor.
We will analyze our dataset in detail when we build our ‘descriptive’ dashboard but for now we know that we have 15 attributes and 3333 records that describe the profile of each customer of the telecom operator.
The last attribute, Churn, is known as the target attribute–the attribute that we want our ML model to predict to know if a customer will churn or not.
Step 2: Train a churn-prediction model & deploy the inference API
Our next step is to build the churn prediction model. The target is to classify each customer into either of the two categories — churn or not churn. Therefore, this is a binary classification problem. We will be leveraging SageMaker Autopilot that allows us to automatically build, train, and tune the best machine learning model based on our data without having to write much code.
Credit: Amazon Web Services YouTube
If you are just getting started with SageMaker Autopilot, here is a great video from AWS to help you understand the basics. I use the describe_auto_ml_job API to look up the best algorithm selected by the SageMaker Autopilot job.
Finally, we will create our model based on the best candidate (automl-churn-28–18–16–29r2UGiyXI-011–5e61e1c5) & deploy it to a hosted endpoint. When the endpoint is ready, the endpoint status will change to ‘InService’ like below.
To make it easier for you to learn about how I trained & deployed my model in SageMaker, I will attach my Python notebook along with this blog.
Step 3: Send data from QS to the ML endpoint for prediction
Now that we have the model endpoint ready for inference, we will send all the fields required by the model from QS to predict if a customer would churn or not. Please note that we will only send 14 attributes and exclude the last one(churn) since we want that prediction to be made by the model.
To do so, we go to the Data load editor and create a new SageMaker connection like below. You can read more about creating a new connection here.
You should now see the SageMaker_Autopilot_churn name in your list of connections. Now, click on ‘select data’ to start sending your data from QS data model to SageMaker.
Click on ‘Insert script’ to get the script in the editor.
Please note how I have changed the raw script that we got from our connection to include all the 14 fields to be sent to our endpoint. Like our previous use case, we use RowNo( ) here as a field to associate the source data & the returned prediction table.
Here’s a peek at our data model after the data is loaded.
Let’s quickly check what is returned by the ML model based on the data we sent from Qlik Sense.
So, for every customer row, we have a predicted_label field that shows whether the customer will stay or leave. We also have the individual class probabilities for deeper analysis.
Step 4: Building the QS analytics app
Our final step is to build a Qlik Sense app so we can perform our analysis and present it to the stakeholders.
We will segregate the app into 3 sheets as shown below each serving its purpose:
Descriptive Analysis sheet:
Goal: This sheet will help us understand the historical source data & allow for detailed analysis.
First, I want to understand the distribution of a couple of features and since we have 15 of them, I won’t visualize all of them but highlight the ones that my stakeholders are interested in. In terms of visualization, I will use a container object and add the distributions as histograms like below.
We can see that most of the fields (Day mins, Eve mins, etc.) have a normal distribution while Cust Serv Calls appear to be positively skewed.
I also wanted to highlight how the target attribute(Churn) was distributed since it is important to know the reality of how many customers can actually churn. Looks like 14.49 % of the customers did churn.
Next, since our data is high-dimensional (10+ features) and I want to enable detailed analysis of individual customers, choosing a visualization that works well with multidimensional data was crucial. I decided to go with a Parallel coordinate plot extension that I built sometime back.
Finally, putting everything together here’s our Descriptive dashboard.
Let’s do a simple analysis. I want to compare a customer who wants to churn with one that does not. So, I randomly select two such rows.
This view allows us to easily compare all the 11 numerical attributes. So, looks like both of these customers are new customers(observe acc_length=1). The orange line represents Churn=‘True’ and the cyan represents Churn=‘False’. For most of the features, we see the lines in a criss-cross form which helps us understand how these 2 customers differ. One thing that stands out is how the customer who churns makes 5 customer service calls in just a day and the other one makes 1. This gives us an indication that the orange customer might have faced some issues with the operator.
Predictive Analysis sheet:
Goal: This sheet will help us understand the churn predictions that we made using SageMaker & our model’s performance.
Let’s see how our overall predictions looks like.
The predictions are almost similar to the ground truth.
Next, I want to visualize the churn predictions by each state so the telecom operator can keep their focus on those ‘risky’ states.
This is a great example of how using Qlik’s associative property, we were able to integrate both historical and predicted data.
It is also important to understand what mistakes the ML model makes. False negatives are the most problematic because the model incorrectly predicts that a churning customer will stay. The best way to evaluate our model would be to draw a confusion matrix like below.
We have 17 such cases. We can select this ‘17 block’ from our matrix and perform detailed analysis of the special cases by analyzing both descriptive & predictive sheets.
Predictive dashboard:
What-If Analysis sheet:
Our final piece is the ‘What-if’ scenario builder. Personally, I love this native capability of Qlik Sense as it allows us to look beyond traditional analysis. Also, note how easy & quick it is to build this. I have used a custom object called ‘variable input’ that allows me to include sliders, dropdown & text fields.
The ‘Will the customer churn?’ is a KPI object and uses a Server side extension function ScriptAggrStr()as a chart expression which allows us to get predictions in real-time by passing the values dynamically from the input boxes. Here’s the expression -
endpoints.ScriptAggrStr('{"RequestType":"endpoint", "endpoint":{"connectionname":"Amazon_SageMaker_Telco"}}',vState,vActLen,vIntPln,vVmailPln,vVmailMsg,vDayMins,vDayCalls,vEveMins,vEveCalls,vNightMins,vNightCalls,vIntMins,vIntCalls,vCustServCalls)Let us do quick & simple what-if analysis. From our Descriptive sheet, we noted that the field Cust Serv calls might be an important one. After all, a happy customer doesn’t need to call customer service. To really prove that correlation, let’s play around.
And looks like the hypothesis makes sense! However, please note that this is just one factor. I tried increasing the Int’l Mins to 15 instead of 12 and even though I had a lot of customer service calls, the prediction was False.
So, maybe providing more Int’l Mins to the customer would be a great idea to retain them. This kind of insight can help businesses dealing with churn to really understand the pitfalls and improvise on them even at a granular level.
That brings us to the end of this exciting blog. The tutorial is a detailed one as the whole idea was to allow Qlik users to quickly adapt to these capabilities and understand the process end-to-end. Let me know what you think!
~Dipankar, Qlik R&D
