Hear directly from Qlik employees in our ten unique blogs.
Product Innovation
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.
Support Updates
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.
Qlik Academic Program
This blog was created for professors and students using Qlik within academia.
Community News
Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.
Qlik Digest
The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.
Qlik Education
The Qlik Education blog provides information about the latest updates of our courses and programs with the Qlik Education team.
Recent Blog Posts
-
Using Direct Query with MS Azure SQL - New Connectors for MS SQL, Azure SQL, Pos...
We just added the ability to use Direct Query with PostgreSQL, Azure Synapse Analytics, Azure SQL and MS SQL.
-
Natural Language API Now Available for Developers in Qlik Sense
Conversational analytics is the new form of self-service where technical ninja-skills are no longer required to derive insights from complex data sets. Now with the emergence of conversational analytics and Natural Language processing engines like Qlik’s Insight Advisor Chat, users of all levels can interact with data naturally by asking questions in their own words and receiving answers and chart suggestions instantly. -
Connector Factory – May 2023 releases
Connector Factory is Qlik’s strategy to continually expand access to and delivery of data from hundreds of SaaS applications and data sources to fuel ever-evolving enterprise cloud analytics and data integration needs. In the past few weeks, Connector Factory has released the following Qlik Cloud Analytics and Qlik Application Automation connectors. -
Visualization Innovations Extend Self-service Exploration and Analysis
Qlik continues to invest in enhancements to Qlik Sense visualization capabilities, and the recent Qlik Sense SaaS and Client-Managed releases are no exception. -
Chat with us; Say Goodbye to Support Tickets and Hello to Instant Assistance!
Are you tired of waiting for support tickets to be addressed and resolved? Look no further! Our Support Chat is here to revolutionize your customer support experience, providing instant assistance, saving you time and effort. -
Qlik Sense May 2023 (Client-Managed) now available!
Coming off Qlik World, we are happy to announce the next version of Qlik Sense May 2023 - our Client-Managed analytics offering. This version is primarily focused on visualization improvements including a new filter pane object, a variety of new styling options, and enhancements to navigation and design. We also have included a new Google Analytics 4 connector and improved authentication for several other connectors. -
Latest Version of Entitlement Analyzer for Qlik Sense Enterprise SaaS customers ...
Hello Qlik Users! 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? These are a couple of the questions we frequently hear. To enable you to find better answers for those, we are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! The Entitlement Analyzer will help an... Show MoreHello Qlik Users!
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?
These are a couple of the questions we frequently hear. To enable you to find better answers for those, we are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS!
The Entitlement Analyzer will help answer those questions and more! The app provides insights on:
- Entitlement usage overview across the Tenant
- Analyzer Capacity – Detailed usage data and a predication if you have enough
- Understand how users are using the system and if they have the right Entitlement assigned to them
- Understand 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 can be found at the bottom of this post. This app was created internally and will be supported by the developers of the app. They will be following this thread so be sure to post any questions or issues here so they can be addressed.
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 Digital Support Team
Change log:
Oct. 7, 2021: Updated and attached latest QVF file for Entitlement Analyzer. The new version contains details about open events and therefore allows customers to better understand their consumption of the tenant.
Oct. 20, 2022: Updates to legacy version and new app with OEM features available.
Version
Description
Customer Type
Ongoing Development
Entitlement Analyzer – Current.qvf
If this is the first time installing this application, use this application. This version addresses bug fixes and introduces support for multitenancy. If “upgrading” to this version from an older version of the Entitlement Analyzer, historical data will be lost.
Direct, OEM
Yes – all new bug fixes and features will be addressed in this version and forward.
Entitlement Analyzer – Legacy.qvf
This version addresses bug fixes and is intended to be used by existing Direct customers to upgrade from the old version while keeping their existing history.
Direct
No – this version of the app will be the last version for Direct customers only.
-
Tips and Tricks: Creating a Multi-layer Drilldown Map with different layer types
Customer asked how to create a drill-able map, BUT wanted to display different layers when drilling down. It's very easy by simply using a Drilldown dimension and controlling the layer visibility in the map layer options - check it out!
-
Unbalanced, n-level hierarchies
Hierarchies are very common in all database and business intelligence solutions. Usually they are balanced and with a fix number of levels, and then they do not pose any problems. Just load the data, add a drill-down group, and you’re done. But there is one type of hierarchy that is somewhat tricky to get right – an unbalanced, n-level hierarchy. Typical for this type of hierarchy is that the levels are not named, and you really don’t know on wh... Show MoreHierarchies are very common in all database and business intelligence solutions. Usually they are balanced and with a fix number of levels, and then they do not pose any problems. Just load the data, add a drill-down group, and you’re done.
But there is one type of hierarchy that is somewhat tricky to get right – an unbalanced, n-level hierarchy. Typical for this type of hierarchy is that the levels are not named, and you really don’t know on which level you need to search for a specific node.
Usually such a hierarchy is stored in an Adjacent Nodes table, i.e. a table that has one record per node and each node has a reference to its parent.
Such a table can be loaded into QlikView directly using the Hierarchy prefix. This prefix will transform the Adjacent Nodes table into an Expanded Nodes table that has additional fields that you can use in your app.
With the fields in this table, you can easily create a pivot table and a tree-view list box. Below you can see some wine districts displayed in both these object types:
One challenge with hierarchies is that you can refer to a node in two different ways: Either to the node including the entire sub-tree, or to the node only, excluding all sub-nodes. In the example with the wine districts, it would mean any wine from Bordeaux, and unspecified Bordeaux, respectively. In the pivot table above, the difference is obvious: Any wine from Bordeaux sums up to 150 units, and the unspecified Bordeaux sums up to 18 units.
A user usually wants to make selections referring to the entire sub-tree, but the above solution does not have any field for this. To create such a field, you need the second hierarchy-resolving prefix – the HierarchyBelongsTo.
This prefix will also transform the hierarchy table. The result will be a table containing one record per descendant-ancestor pair. In other words, the ancestor (tree ID) will link to all its descendants (node ID), and can thus be used to make selections of entire sub-trees. (The “TreeBridge” table in the picture below.)
But it doesn’t stop here… The above solution creates one field in which tree searches can be made, but in order to create a drill-down for trees, you need an additional table – an expanded nodes table for the trees. This can be created with a second Hierarchy statement, but now one that links to the tree ID instead of the node ID. (The “Trees” table in the picture below.)
The data model with the three hierarchy tables is the one I recommend: It generates all fields you need.
A more elaborate explanation with script examples can be found in the technical brief about Hierarchies.
Further reading related to this topic:
-
Sankey Charts: Contribution and Distribution
A explaination of Sankey charts and how you can best use them in Qlik. -
Snowflake Usage Analysis
Download the latest and greatest version of the application from GitHub here: https://github.com/Qlik-PE/Snowflake-Usage-Analysis-Dashboard -
Calling All APAC Data Lovers!
Register for Applied Data Analytics using Qlik Sense Course starting June 19 in APAC.
-
WhatsApp Automation Integration for Qlik Application Automation
WhatsApp Automation Integration for Qlik Application AutomationDataGlow ITWhatsApp is missing as a native delivery target from Qlik Application Automation. DataGlow IT have engineered a process to allow output WhatsApp as an alternative to delivery via Teams, Slack or Email. Utilising WhatsApp as a delivery target opens up multiple use cases for Customer and Consumer data delivery. Furthermore, there also exists the ability to have a configura... Show MoreWhatsApp Automation Integration for Qlik Application AutomationDataGlow IT
WhatsApp is missing as a native delivery target from Qlik Application Automation. DataGlow IT have engineered a process to allow output WhatsApp as an alternative to delivery via Teams, Slack or Email. Utilising WhatsApp as a delivery target opens up multiple use cases for Customer and Consumer data delivery. Furthermore, there also exists the ability to have a configurable conversation via WhatsApp, optionally utilising further 2 way interactions with Qlik Application Automation.
Discoveries
Share data from Qlik outside of the standard business delivery systems such as Teams, Slack and Email. Have conversations with your
Impact
Governed conversations, data and updates can now be shared to both Customers and Colleagues via WhatsApp, enabling them delivery and key data points from Qlik without needing Qlik licensing, or corporate comms infrastructure such as Teams or SharePoint.
Audience
Ideal for rolling out updates for Customers to WhatsApp directly from Qlik. Examples include delivering order status updates, surveys and regular KPI delivery.
Data and advanced analytics
Gather ultra-responsive feedback from clients and colleagues via a native and frequently used platform in WhatsApp.
-
FROM_FIELD() - Is very powerful! It helped me parse JSON data stored in a field!
See how powerful FROM_FIELD() is. It helped me extract a simple JSON data structure from a filed into it's own dimension table.
-
【6/29（木）15:00 開催】QlikWorld 2023 ダイジェスト Web セミナー
今年 4月､毎年恒例の最大級のデータイベント「QlikWorld 2023｣が、米国ラスベガスで開催されました。特別ゲストおよび Qlik エグゼクティブによる基調講演をはじめ、100 以上のセッションや実践的なワークショップ、グローバルトランスフォーメーションアワード授与式など、データ愛好家が一堂に会した 4 日間は、連日盛況のうちに終了しました。本 Web セミナーでは、Qlik の日本の営業および技術者が、QlikWorld 2023 でご紹介した内容をわかりやすくまとめてお届けします。Qlik のビジョンや製品ポートフォリオ、最新のユーザー事例、Qlik で先進的なビジネス成果を挙げている企業に授与されるグローバルトランスフォーメーションアワードのほか、実際に参加した営業担当者が現地でのイベントの様子をご紹介します。ぜひ、データ活用のすべてを網羅した「QlikWorld 2023」をダイジェストでご視聴ください。 ※ 内容は予告なく変更になる可能性があります。予めご了承ください... Show More今年 4月､毎年恒例の最大級のデータイベント「QlikWorld 2023｣が、米国ラスベガスで開催されました。
特別ゲストおよび Qlik エグゼクティブによる基調講演をはじめ、100 以上のセッションや実践的なワークショップ、グローバルトランスフォーメーションアワード授与式など、データ愛好家が一堂に会した 4 日間は、連日盛況のうちに終了しました。
本 Web セミナーでは、Qlik の日本の営業および技術者が、QlikWorld 2023 でご紹介した内容をわかりやすくまとめてお届けします。Qlik のビジョンや製品ポートフォリオ、最新のユーザー事例、Qlik で先進的なビジネス成果を挙げている企業に授与されるグローバルトランスフォーメーションアワードのほか、実際に参加した営業担当者が現地でのイベントの様子をご紹介します。ぜひ、データ活用のすべてを網羅した「QlikWorld 2023」をダイジェストでご視聴ください。※ 内容は予告なく変更になる可能性があります。予めご了承ください。
※ 参加費無料。パソコン・タブレット・スマートフォンで、どこからでもご参加いただけます。 -
2022 FIFA World Cup Teams
2022 FIFA World Cup Teams AnyChart — QS Extensions Explore Qatar 2022 teams by league and club with remarkable Decomposition Trees. Discoveries Investigate how the national football/soccer teams of all 32 participating countries in the 2022 Qatar World Cup are made up of players from various leagues and clubs, using remarkable Decomposition Tree visualizations in Qlik Sense. (Re)arrange the order of the represented dimensions dependin... Show More2022 FIFA World Cup TeamsAnyChart — QS ExtensionsExplore Qatar 2022 teams by league and club with remarkable Decomposition Trees.Discoveries
Investigate how the national football/soccer teams of all 32 participating countries in the 2022 Qatar World Cup are made up of players from various leagues and clubs, using remarkable Decomposition Tree visualizations in Qlik Sense. (Re)arrange the order of the represented dimensions depending on how you want to disaggregate the totals. Analyze goals and caps for national teams similarly using intuitive decomposition trees.
Impact
Check out how AnyChart's Decomposition Tree works and how it can help you explore data across multiple dimensions.
Audience
Anyone who wants to analyze the 2022 Qatar World Cup's teams and see an example of a decomposition tree in Qlik Sense in action.
Data and advanced analytics
This application features decomposition trees built with AnyChart's Decomposition Tree extension for Qlik Sense.
🔗 >> VIEW IT LIVE OR DOWNLOAD (.QVF) <<
-
【6/7（水）14:00 - 15:00 開催】Web セミナー：Qlik と Dr.Sum で、散在するデータの再活用を促進！
データドリブンな組織づくりを推進しようと、データ活用を推し進める企業が増えてきました。社内に散っている多種多様なデータの統合や、BI ツールを使った可視化・分析を進めているものの、まだ部分的、あるいは分断的に導入されているケースが多く見受けられます。本質的なデータ活用に向けては、これらが一気通貫で実現され、誰でもデータにアクセスし分析できること、そしてデータをもとに行動できる状態にあることが必要不可欠です。 本セミナーでは、基幹システムなどさまざまなデータソースからほぼリアルタイムでデータを取得できる Qlik のデータ統合製品「Qlik Replicate」と、プログラミングを必要とせずビジネスユーザーが直感的に使える BI ツール「Qlik Sense」と、データ分析基盤として国内シェア No.1* を誇るウイングアーク １ｓｔの「Dr.Sum」の連携によって、データ活用の用途の幅をどのように広げていくのかをご紹介いたします。*出典：ITR「 DBMS/BI 市場 2021」データ分... Show Moreデータドリブンな組織づくりを推進しようと、データ活用を推し進める企業が増えてきました。社内に散っている多種多様なデータの統合や、BI ツールを使った可視化・分析を進めているものの、まだ部分的、あるいは分断的に導入されているケースが多く見受けられます。本質的なデータ活用に向けては、これらが一気通貫で実現され、誰でもデータにアクセスし分析できること、そしてデータをもとに行動できる状態にあることが必要不可欠です。
本セミナーでは、基幹システムなどさまざまなデータソースからほぼリアルタイムでデータを取得できる Qlik のデータ統合製品「Qlik Replicate」と、プログラミングを必要とせずビジネスユーザーが直感的に使える BI ツール「Qlik Sense」と、データ分析基盤として国内シェア No.1* を誇るウイングアーク １ｓｔの「Dr.Sum」の連携によって、データ活用の用途の幅をどのように広げていくのかをご紹介いたします。
*出典：ITR「 DBMS/BI 市場 2021」データ分析/レポーティング市場:ベンター別売上金額推移およびシェア詳細を見る
【開催概要】
日時：2023年 6月 7日（水）14:00 - 15:00
会場：オンライン
参加費：無料 -
【6/2（金）14:00 - 17:00 開催】共催セミナー：データ分析の新時代を切り拓く
本イベントは、データ分析と AI 技術に関心のあるビジネスリーダーや分析担当者を対象とし、最先端のテクノロジーを活用して、データドリブンなビジネスの成功を実現する方法や、ビジネスにおけるデータ分析と AI 技術が果たす役割について学ぶことができます。 Snowflake、Qlik、DataRobot の 3 社から、それぞれの企業が提供するソリューションの概要や、それらを組み合わせてどのようにデータドリブンなビジネスの成功を支援するかについてご説明します。Snowflake は、クラウドベースのデータウェアハウスであり、高速で柔軟なデータ処理を提供します。Qlik は、分析のためのデータ基盤を構築するデータ統合と、データ可視化・分析のためのユーザーフレンドリーなインターフェースを備えたビジネスインテリジェンスを提供します。DataRobot は、自動化された機械学習プラットフォームであり、モデルの構築、トレーニング、評価を簡単かつ迅速に行うことができます。 アシストは、参加者の方が自社の... Show More本イベントは、データ分析と AI 技術に関心のあるビジネスリーダーや分析担当者を対象とし、最先端のテクノロジーを活用して、データドリブンなビジネスの成功を実現する方法や、ビジネスにおけるデータ分析と AI 技術が果たす役割について学ぶことができます。
Snowflake、Qlik、DataRobot の 3 社から、それぞれの企業が提供するソリューションの概要や、それらを組み合わせてどのようにデータドリブンなビジネスの成功を支援するかについてご説明します。Snowflake は、クラウドベースのデータウェアハウスであり、高速で柔軟なデータ処理を提供します。Qlik は、分析のためのデータ基盤を構築するデータ統合と、データ可視化・分析のためのユーザーフレンドリーなインターフェースを備えたビジネスインテリジェンスを提供します。DataRobot は、自動化された機械学習プラットフォームであり、モデルの構築、トレーニング、評価を簡単かつ迅速に行うことができます。
アシストは、参加者の方が自社のビジネスに適した戦略やツールを見つけ、競争優位性を獲得するためにデータドリブンなアプローチを採用することを支援いたします。
詳細を見る
【開催概要】
日時：2023年 6月 2日（金）14:00 – 17:00
会場：株式会社アシスト 西日本支社会議室
大阪市北区大深町4-20 グランフロント大阪タワー A 13F
参加費：無料 -
QlikView May 2023 release and Qlik NPrinting: Do not upgrade QlikView if you use...
QlikView's May 2023 release, version 12.80, is available today on our Downloads page. Note: For Qlik NPrinting customers using QlikView, please hold off upgrading QlikView to today's May 2023 (12.80) release. An upgrade to Qlik NPrinting to the May 2023 release is required in parallel. Any other combinations of QlikView and Qlik NPrinting versions are not compatible. The May 2023 version of Qlik NPrinting has been released as of the 30th of May.... Show MoreQlikView's May 2023 release, version 12.80, is available today on our Downloads page.
Note: For Qlik NPrinting customers using QlikView, please hold off upgrading QlikView to today's May 2023 (12.80) release.
An upgrade to Qlik NPrinting to the May 2023 release is required in parallel. Any other combinations of QlikView and Qlik NPrinting versions are not compatible.
The May 2023 version of Qlik NPrinting has been released as of the 30th of May.
Please subscribe to this post for any eventual updates.
Looking for general upgrade advise? The below links will take you to the most recent release available on our help site.
QlikView Upgrades and Updates | QlikView Help
System Requirements for QlikView Server | QlikView Help
Planning your deployment | Qlik NPrinting Help
Planning your upgrade | Qlik NPrinting Help
Qlik NPrinting May 2023 Release Notes | Qlik CommunityUpdate May 30th: Qlik NPrinting May 2023 was released today.
-
Rugby World Cup Japan 2019: stats and analytics
The Rugby World Cup has officially started today with the host country Japan beating Russia.
