Skip to main content

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 

Design

The Design blog is all about product and Qlik solutions, such as scripting, data modeling, visual design, extensions, best practices, and more!

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.

Subprocessors List

Qlik Subprocessors General Data Protection Regulation (GDPR).

Japan

Qlik Community blogs for our customers and partners in Japan.

Recent Blog Posts

  • Image Not found

    Design

    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. 
  • qlik-community-blogs.jpg

    Product Innovation

    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.
  • Image Not found

    Product Innovation

    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. 
  • qlik-community-blogs.jpg

    Product Innovation

    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.  
  • Image Not found

    Support Updates

    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.
  • Image Not found

    Product Innovation

    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.
  • Image Not found

    Support Updates

    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 More

    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! 

    Entitlement Analyzer.pngThe 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! 

     

    Analyzer.JPG

     

    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.

     

     

    Show Less
  • Image Not found

    Design

    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!
  • qlik-community-blogs.jpg

    Design

    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 More

    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.


    Adjacent Notes source 2.png

    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.

     

    Data model single table - BP.png

     

    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:

     

    Tables - BP.png

     

    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.)

     

    Data model full - BP.png

     

    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.

     

    HIC

     

    Further reading related to this topic:

    Authorization using a Hierarchy

    Bill of Materials

    Show Less
  • Image Not found

    Design

    Sankey Charts: Contribution and Distribution

    A explaination of Sankey charts and how you can best use them in Qlik.
  • Image Not found

    Qlik Gallery

    Snowflake Usage Analysis

    Download the latest and greatest version of the application from GitHub here:  https://github.com/Qlik-PE/Snowflake-Usage-Analysis-Dashboard 
  • Image Not found

    Qlik Education

    Calling All APAC Data Lovers!

    Register for Applied Data Analytics using Qlik Sense Course starting June 19  in APAC.
  • qlik-community-blogs.jpg

    Qlik Gallery

    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 More
    Show Less
  • Image Not found

    Design

    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.
  • Image Not found

    Japan

    【6/29(木)15:00 開催】QlikWorld 2023 ダイジェスト Web セミナー

    今年 4月、毎年恒例の最大級のデータイベント「QlikWorld 2023」が、米国ラスベガスで開催されました。特別ゲストおよび Qlik エグゼクティブによる基調講演をはじめ、100 以上のセッションや実践的なワークショップ、グローバルトランスフォーメーションアワード授与式など、データ愛好家が一堂に会した 4 日間は、連日盛況のうちに終了しました。本 Web セミナーでは、Qlik の日本の営業および技術者が、QlikWorld 2023 でご紹介した内容をわかりやすくまとめてお届けします。Qlik のビジョンや製品ポートフォリオ、最新のユーザー事例、Qlik で先進的なビジネス成果を挙げている企業に授与されるグローバルトランスフォーメーションアワードのほか、実際に参加した営業担当者が現地でのイベントの様子をご紹介します。ぜひ、データ活用のすべてを網羅した「QlikWorld 2023」をダイジェストでご視聴ください。 ※ 内容は予告なく変更になる可能性があります。予めご了承ください... Show More

    QW2023_Digest_Webinar_Blog.jpg

    今年 4月、毎年恒例の最大級のデータイベント「QlikWorld 2023」が、米国ラスベガスで開催されました。
    特別ゲストおよび Qlik エグゼクティブによる基調講演をはじめ、100 以上のセッションや実践的なワークショップ、グローバルトランスフォーメーションアワード授与式など、データ愛好家が一堂に会した 4 日間は、連日盛況のうちに終了しました。

    本 Web セミナーでは、Qlik の日本の営業および技術者が、QlikWorld 2023 でご紹介した内容をわかりやすくまとめてお届けします。Qlik のビジョンや製品ポートフォリオ、最新のユーザー事例、Qlik で先進的なビジネス成果を挙げている企業に授与されるグローバルトランスフォーメーションアワードのほか、実際に参加した営業担当者が現地でのイベントの様子をご紹介します。ぜひ、データ活用のすべてを網羅した「QlikWorld 2023」をダイジェストでご視聴ください。

    ※ 内容は予告なく変更になる可能性があります。予めご了承ください。
    ※ 参加費無料。パソコン・タブレット・スマートフォンで、どこからでもご参加いただけます。


    今すぐ申し込む

    Show Less
  • qlik-community-blogs.jpg

    Qlik Gallery

    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 More

    🔗 >> VIEW IT LIVE OR DOWNLOAD (.QVF) <<

    🔗 >> SEE MORE APPS <<

     

     

    Show Less
  • Image Not found

    Japan

    【6/7(水)14:00 - 15:00 開催】Web セミナー:Qlik と Dr.Sum で、散在するデータの再活用を促進!

    データドリブンな組織づくりを推進しようと、データ活用を推し進める企業が増えてきました。社内に散っている多種多様なデータの統合や、BI ツールを使った可視化・分析を進めているものの、まだ部分的、あるいは分断的に導入されているケースが多く見受けられます。本質的なデータ活用に向けては、これらが一気通貫で実現され、誰でもデータにアクセスし分析できること、そしてデータをもとに行動できる状態にあることが必要不可欠です。 本セミナーでは、基幹システムなどさまざまなデータソースからほぼリアルタイムでデータを取得できる Qlik のデータ統合製品「Qlik Replicate」と、プログラミングを必要とせずビジネスユーザーが直感的に使える BI ツール「Qlik Sense」と、データ分析基盤として国内シェア No.1* を誇るウイングアーク 1stの「Dr.Sum」の連携によって、データ活用の用途の幅をどのように広げていくのかをご紹介いたします。*出典:ITR「 DBMS/BI 市場 2021」データ分... Show More

    データドリブンな組織づくりを推進しようと、データ活用を推し進める企業が増えてきました。社内に散っている多種多様なデータの統合や、BI ツールを使った可視化・分析を進めているものの、まだ部分的、あるいは分断的に導入されているケースが多く見受けられます。本質的なデータ活用に向けては、これらが一気通貫で実現され、誰でもデータにアクセスし分析できること、そしてデータをもとに行動できる状態にあることが必要不可欠です。

    本セミナーでは、基幹システムなどさまざまなデータソースからほぼリアルタイムでデータを取得できる Qlik のデータ統合製品「Qlik Replicate」と、プログラミングを必要とせずビジネスユーザーが直感的に使える BI ツール「Qlik Sense」と、データ分析基盤として国内シェア No.1* を誇るウイングアーク 1stの「Dr.Sum」の連携によって、データ活用の用途の幅をどのように広げていくのかをご紹介いたします。

    *出典:ITR「 DBMS/BI 市場 2021」データ分析/レポーティング市場:ベンター別売上金額推移およびシェア

    詳細を見る

    【開催概要】
    日時:2023年 6月 7日(水)14:00 - 15:00
    会場:オンライン
    参加費:無料

    Qlik_JP_MKT2_0-1684902897003.png

    詳細を見る

    Show Less
  • Image Not found

    Japan

    【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
    参加費:無料

    Qlik_JP_MKT2_0-1684901883900.png

    詳細を見る

    Show Less
  • Image Not found

    Support Updates

    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 More

    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.

    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 Community

     

    Update May 30th: Qlik NPrinting May 2023 was released today.

    Show Less
  • Image Not found

    Design

    Rugby World Cup Japan 2019: stats and analytics

    The Rugby World Cup has officially started today with the host country Japan beating Russia.