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
-
Qlik Introduces a New Era of Visualization
Our ability to tell stories is an art form as old as language itself. From ancient cave paintings to oral traditions passed through generations, the e... Show MoreOur ability to tell stories is an art form as old as language itself. From ancient cave paintings to oral traditions passed through generations, the essence of stories has evolved alongside our communication methods. It began with visual tales etched on cave walls, transitioned into spoken narratives, and eventually found its way into written, printed, and typed forms.
Ultimately, modern analytics and visualizations serve the same purpose as sharing and retelling stories: guiding business users to make important and informed decisions. These decisions, however, are not made alone, and require stories to persuade and engage others, often in boardrooms or video calls. But the goal of the story remains unchanged: to inspire action, instill confidence, and ensure safety.
So, what happens in the next chapter?
Today, Qlik is proud to announce a new era in data visualization and dashboard design. With the latest advancements in Qlik, you can bid farewell to the days of grappling with custom style sheets and juggling third-party add-ons. It's time to explore your creativity and take control of your narrative like never before!
Chapters:
1. The layout container adventure
Picture this: designing beautiful dashboards that are not only interactive but also fun and easy. Say hello to the Layout container, your new-found playground for creativity. Stack objects, craft custom and composite KPIs, and toggle individual object visibility with ease. With multi-selection, grouping, and a plethora of styling tools at your fingertips, designing experiences just got a whole lot faster and more intuitive. Need inspiration? Dive into this vibrant dashboard crafted by Luis Felipe Tensini, Qlik Partner Ambassador, and prepare to be amazed.
2. Charting new narratives & filter pane styling
It's not just about data; it's about presentation. You now have the power to improve the way you tell your story. Control borders, shadows, fonts, and more to add depth and personality to your visualizations while maintaining your company's branding. Explore data effortlessly with customizable filter panes. From grid mode to compact views, from checkboxes to radio buttons, tailor your data display for a truly immersive user experience.3. Cyclic group dimensions delivered
Cyclic groups for Master Item Dimensions—another QlikView legendary feature delivered. Allowing users to dynamically cycle through dimensions in every chart, maximizing the potential to tell stories while conserving screen space. With this innovation, charts become versatile tools, accommodating multiple use cases effortlessly. Crafting compelling narratives is simplified: select the Cyclic option in the master items library, choose desired fields, and effortlessly switch between them in your chart.4. A tale of dashboard themes…enhanced
Plot twist! We've introduced enhancements, including new straight tables, pivot tables, line objects, and rich text objects. Take command of your space with the ability to control the visibility of the main selection toolbar and sheet header, freeing up valuable real estate for content and custom navigation bars.Cliff notes: Visualizations have undergone a remarkable makeover. You now have permission to evoke the freedom of creativity, captivate your audience, and transform data into insights like never before. The future with Qlik Cloud is bright!
From ancient cave tales to today's dynamic dashboards, the evolution of storytelling parallels human communication methods. Innovation ushering in a future where every data point tells a tale waiting to be explored.
Your adventure into the world of Visualizations & Dashboards does not stop here… continue your journey and check out the ‘What’s New: Qlik Showcase App’ or these new and improved stylish apps below and see for yourself!
In the grand scheme of things, Qlik’s evolution promises freedom, creativity, and limitless possibilities in data visualizations. The only limit is your imagination.
Highlights:
- Filter pane styling: styling options for the filter pane
- Chart Border and Shadow: More control for app developer. Use it to create depth effect, enhance or hide the border. Perfect for layout container. Overrides the theme setting.
- Layout Container: Freeform layout for grouping and stacking. New way to create content and design dashboards
- Pivot Table: New pivot table and will replace native pivot in the future
- Styling improvements: Grid, Funnel and Sankey chart is getting styling
- Copy and paste style: Transfer styling settings from one chart to another
- Cyclic master dimensions
Helpful Links:- What’s New in Qlik Cloud
- Technical preview
- Visualization Update | Qlik YouTube
- How to Create Visual Button Selection States | Do More with Qlik
- How to Create Collapsible Filter Panel | Do More with Qlik
- Cyclic Group Dimensions | SaaS in 60
Inspiration from Qlik Community: -
Switch Control Statement
The switch control statement is one of many controls statement that can used to determine the flow of the script. In Qlik Sense help, it is defined a... Show MoreThe switch control statement is one of many controls statement that can used to determine the flow of the script. In Qlik Sense help, it is defined as:
The switch control statement is a script selection construct forcing the script execution to follow different paths, depending on the value of an expression.
Syntax:
Switch expression {case valuelist [ statements ]} [default statements] end switch
The switch control statement can be used in the script to identify a specific execution path. With the switch control statement, several paths can be defined and a default path can be defined as well when no match is found in the case clause. The various script paths cannot cross – they should be individual paths that do not overlap. In the script below, the expression x will be compared to each case. When there is a match, the script for that case will be executed.
In the example below, Case 1 will be executed – the variable y will be set to Sunday and one record will be generated in the table.
Below is a look at the record generated.
It is also possible to have more than one value for a case, for instance, you can use the script below to run the same script if x matches 1, 2 or 3.
When faced with various script execution paths, try using the switch control statement. While I rarely have a need to use it, I like how neat and straight-forward the syntax is. I have attached an example Qlik Sense app with the full script for you to test out for yourself.
Thanks,
Jennell
-
Qlik Sense May 2024 (Client-Managed) now available!
Visualizations and dashboards Add the Styling option to add Background Color Opacity The color picker gets an opacity control! By adding this feature,... Show MoreVisualizations and dashboards
Add the Styling option to add Background Color Opacity
The color picker gets an opacity control! By adding this feature, we are making it easier to adjust the transparency of the color with the new addition and option to utilize slider functionality. Here are some use cases that you may find this feature very useful:
- Allow the sheet background to shine and make a statement along with the data you’re showing!
- Add more elegance to stacked charts
For those of you who will stick to hex codes, don’t worry – we made that easier too! Moving forward, you’ll be able to paste your codes with or without the “#” symbol.
Cyclic Dimensions
Cyclic master dimensions introduce a novel dimension type, empowering users to select dimensions from a group and seamlessly switch them across the entire application. Unlike drill-down groups, cyclic dimensions lack a hierarchical structure, yet they resemble alternative dimensions, extending their influence app-wide. By employing cyclic dimensions, valuable app and screen space is conserved, allowing a series of charts to offer multifaceted analyses. For instance, transitioning from temporal to geographical or product category-based measures is effortless. Toggling the dimension is facilitated either through a button action or axis label. Additionally, with cyclic dimensions, naming the levels within cyclic and drill-down groups becomes possible. Engine functions exist to query the group's state, aiding in the creation of dimension-dependent measures or indicating the state through labels.
Table ImprovementsWe continue to improve on the new Straight table and Pivot table because they are not only classics, but they’re also favorites!
- Straight Table
- Smaller columns
- URL links
- Pivot Table
- Dimension limits
- Measure formatting
- Text alignment, dimension and measures values and titles
- Null value styling measures
- URL links
Button Enhancement
The following navigation enhancement has been added to the Button: “Go to Sheet: specify chart”. Check out some of the bulleted use cases below where this will come in handy:
- Navigating to a specific chart
- Single page design
- Jump to Section
- Back to top
Hyperlinks for new tables
Finally, you now have the options to display values as clickable links within dimension columns, for both the straight and pivot tables!
*Part of the visualizations bundle
Move quick sheet navigation arrows from sheet header!
When hiding the sheet title, the sheet navigation buttons will be available in the selection bar instead of being hidden.
Connectivity
SAP ODP Connector for Qlik Windows
Like our Qlik Cloud Data Integration provides multiple methods of capturing data from your SAP system. This release enhances existing capture methods with support for SAP ODP. The ODP connector provides connectivity to the SAP ODP framework, enabling data capture from multiple types of data artifacts such as Extractors, CDS views, BW objects, and SAP HANA Information views.
Hub & Engine
Preload Apps Functionality
Available now in Qlik Sense is the ability for customers to configure and schedule the preloading of apps! This has been a highly requested feature and rightfully so, customers can improve their end-users experience by making datasets nearly immediately available within an application (especially useful for larger apps) upon utilizing the preload functionality.
To make the management of these tasks intuitive and seamless, within the Qlik Management Console you will now find new Support options for the following: Preload Tasks: Create, Edit & Delete
Qlik Connect 2024
Get the skills needed to be a data and analytics wizard. Workshops are filling up. Now’s the time. Join us for 2+ days of learning, networking, and the biggest party Qlik has ever thrown with exclusive access to Universal Islands of Adventure this June 3-5 in Orlando, FL at Qlik Connect. Register Today -
Join Us Live! Q&A with Qlik: Qlik Cloud Data Integration
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. REGISTE... 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.
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
-
Qlik Sense Migration: Migrating your Entire Qlik Sense Environment
Hi everyone, For various and valid reasons, you might need to migrate your entire Qlik Sense environment, or part of it, somewhere else. In this post... Show MoreHi everyone,
For various and valid reasons, you might need to migrate your entire Qlik Sense environment, or part of it, somewhere else.
In this post, I’ll cover the most common scenario: a complete migration of a single or multi-node Qlik Sense system, with the bundled PostgreSQL database (Qlik Sense Repository Database service) in a new environment.
So, how do we do that?
- Introduction and preparation
- Backup your old environment
- Deploy and restore the new central environment
- What about my rim nodes?
- Finalizing your migration
- Data Connection
- Licensing
- Best practices
Introduction and preparation
Let’s start with a little bit of context: Say that we are running a 3 nodes Qlik Sense environment (Central node / Proxy-Engine node / Scheduler node).
On the central node, I also have the Qlik shared folder and the bundled Qlik Sense Repository Database installed.
This environment has been running well for years but I now need to move it to a brand new hardware ensuring better performance. It’s not possible to reinstall everything from scratch because the system has been heavily used and customized already. Redoing all of that to replicate the environment is too difficult and time-consuming.
I start off with going through a checklist to verify if the new system I’m migrating to is up to it:
- Do I meet the system requirements? Qlik Sense System Requirements
- What about the hardware? List of Favorable Server Hardware from Qlik Scalability Center
- Am I following virtualization best practices? Virtualization Best Practices In QlikView And Qlik Sense
And then I move right over to…
Backup your old environment
The first step to migrate your environment in this scenario is to back it up.
To do that, I would recommend following the steps documented on help.qlik.com (make sure to select your Qlik Sense version top left of the screen).
Once the backup is done you should have:
- A backup of the database in .tar format
- A backup of the content of the file share which includes your applications, application content, archived logs, extensions,…
- Backups of any data source files that need to be migrated and are not stored in the shared folder like QVDs
Then we can go ahead and…
Deploy and restore the new central environment
The next steps are to deploy and restore your central node. In this scenario, we will also assume that the new central node will have a different name than the original one (just to make things a bit more complicated 😊).
Let’s start by installing Qlik Sense on the central node. That’s as straightforward as any other fresh install.
You can follow our documentation. Before clicking on Install simply uncheck the box “Start the Qlik Sense services when the setup is complete.”
The version of Qlik Sense you are going to install MUST be the same as the one the backup is taken on.
Now that Qlik Sense is deployed you can restore the backup you have taken earlier into your new Qlik Sense central node following Restoring a Qlik Sense site.
Since the central node server name has also changed, you need to run a Bootstrap command to update Qlik Sense with the new server name. Instruction provided in Restoring a Qlik Sense site to a machine with a different hostname.
The central node is now almost ready to start.
If you have changed the Qlik Share location, then the UNC path has also changed and needs to be updated.
To do that:
- Go to C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil
- Run QlikSenseUtil.exe as Administrator
- Click on Connect to the database and enter the credential to connect to the new PostgreSQL database
- Click on Service Cluster and press OK. This should display the previously configured UNC Path
- You simply need to update each path, save and start/restart all the Qlik sense services.
At this point make sure you can access the Qlik Sense QMC and Hub on the central node. Eventually, check that you can load applications (using the central node engine of course). You can also check in the QMC > Service Cluster that the changes you previously made have been correctly applied.
Troubleshooting tips: If after starting the Qlik Sense services, you cannot access the QMC and/or Hub please check the following knowledge article How to troubleshoot issue to access QMC and HUB
What about my rim nodes?
You’ve made it here?! Then congratulation you have passed the most difficult part.
If you had already running and configured rim nodes in your environment that you now need to migrate as well, you might not want to remove them from Qlik Sense to add the new ones since you will lose pretty much all the configuration you have done so far on these rim nodes.
By applying the following few steps I will show you how to connect to your “new” rim node(s) and keep the configuration of the “old” one(s).
Let’s start by installing Qlik Sense on each rim node like it was a new one.
The process is pretty much the same as installing a central node except that instead of choosing “Create Cluster”, you need to select “Join Cluster”
Detailed instruction can be found on help.qlik.com: Installing Qlik Sense in a multi-node site
Once Qlik Sense is installed on your future rim node(s) and the services are started, we will need to connect to the “new” Qlik Sense Repository Database and change the hostname of the “old” rim node(s) to the “new” one so that the central node can communicate with it.
To do that install PGAdmin4 and connect to the Qlik Sense Repository Database. Detailed instruction in Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinting knowledge article.
Once connected navigate to Databases > QSR > Schemas > public > Tables
You need to edit the LocalConfigs and ServerNodeConfigurations table and change the Hostname of your rim node(s) from the old one to the new corresponding one (Don’t forget to Save the change)
LocalConfigs table
ServerNodeConfigurations table
Once this is done, you will need to restart all the services on the central node.
When you have access back, login to the QMC and go to Nodes. Your rim node(s) should display the following status, “The certificate has not been installed”
From this point, you can simply select the node, click on Redistribute and follow the instruction to deploy the certificates on your rim node. After a moment the status should change and you should see the services being up and running.
Do the same thing on the remaining rim node(s).
Troubleshooting tips: If the rim node status is not showing “The certificate has not been installed” it means that either the central node cannot reach the rim node or the rim node is not ready to receive new certificates.
Check that the port 4444 is opened between the central and rim node and make sure the rim node is listening on port 4444 (netstat -aon in command prompt).
Still no luck? You can completely uninstall Qlik Sense on the rim node and reinstall it.Finalizing your migration
At this point, your environment is completely migrated and most of the stuff should work.
Data Connection
There is one thing to consider in this scenario. Since the Qlik Sense certificates between the old environment and the new one are not the same, it is likely that data connections with passwords will fail. This is because passwords are saved in the repository database with encryption. That encryption is based on a hash from the certs. When the Qlik Sense self-signed cert is rebuilt, this hash is no longer valid, and so the saved data connection passwords will fail. You will need to re-enter the passwords in each data connection and save. This can be done in the QMC -> Data Connections.
See knowledge article: Repository System Log Shows Error "Not possible to decrypt encrypted string in database"
Licensing
Do not forget to turn off your old Qlik Sense Environment. As per your license agreement, you can only use one license per active Qlik Sense environment. Reach out to your account manager for more details.
Best practices
Finally, don’t forget to apply best practices in your new environment:
- Qlik Sense Folder And Files To Exclude From AntiVirus Scanning
- Recommended practice on configuration for Qlik Sense
-
Qlik Cloud ４月の新機能
分析の新機能 サイクリック軸 マスターアイテムでサイクリック軸を作成できるようになりました。アイコンをクリックして軸を切り替えることができます。 QVS ファイルによる再利用可能なロードスクリプト ロードスクリプトを QVS ファイルとして保存できるようになりました。QVS ファイルをQlik... Show More分析の新機能
サイクリック軸
マスターアイテムでサイクリック軸を作成できるようになりました。アイコンをクリックして軸を切り替えることができます。
QVS ファイルによる再利用可能なロードスクリプト
ロードスクリプトを QVS ファイルとして保存できるようになりました。QVS ファイルをQlik Cloud にアップロードしたり Web ストレージに格納しておき、ロードスクリプトに挿入することができます。QVS は QVS ビューアで参照することができます。よく使用される処理をQVSファイルにし、再利用することで開発効率を上げることができます。
Help: QVSファイルを使用した再利用可能なロード スクリプトの作成
ボタンアクションの実行時評価オプション
ボタンに複数のアクションを設定する場合のオプションが追加されました。アクションは上から順次実行されますが、実行時間の評価オプションをオフにすると、アクションに設定された数式はそれぞれ独立して評価されます。オンにすると、アクションが実行されるタイミングで数式が評価されます。
Visualization bundle テーブルの改善
- ストレート テーブルの列をより狭くできるようになりました。
- ピボット テーブルには、メジャーの書式設定、テキストの配置、軸の制限が追加されました。
- ストレート テーブル、ピボットテーブルの双方にリンクを表示できるようになりました。
チャートの背景色の不透明度の指定
チャートの背景色の透明度を指定できるようになりました。背景色に「単色」を設定して色を選択し、スライダーで透明度を指定することができます。シートの画像を透かして見せたり、オブジェクトを重ね表示する際に使用することができます。また、16進数のカラーコードは＃の有無にかかわらず貼り付けることができるようになっています。
データ統合の新機能
変換フローデザイナー
変換タスクで、フローデザイナーによって変換処理を定義することができるようになりました。SQLを書かずにドラッグアンドドロップの操作で変換処理を作成できます。フローは SQL ステートメントに変換され、実行時に選択したデータ プラットフォームにプッシュされます。
SAP ODP コネクタ
SAP ODP コネクタがリリースされました。SAP ODP フレームワークへ接続し、Extractors、CDS ビュー、BW オブジェクト、SAP HANA Information View などの複数のタイプのデータアーティファクトからのデータキャプチャができます。
前提条件：
- Data Movement ゲートウェイ サーバーに、必要なSAP Java Connectorをインストールする
- データソースに必要な権限を付与する
- データソースのコネクタを構成する
選択したテーブルのリロード
変換タスクやデータマートタスクなどのほとんどのデータタスクで、選択したテーブルを手動でリロードできるようになりました。エラー発生時の回復や、個別のテーブルの更新に便利です。タスクの監視画面の下部で、テーブルを選択して「テーブルをリロード」をクリックします。
その他
- Anthropic (Amazon Bedrock) 分析コネクタに Claude 3 Sonnet と Haiku のサポートが追加されました。
- PostgreSQL または Microsoft SQL Server (MS-CDC を使用) をデータ ソースとして使用する場合にDDL 変更をキャプチャできるようになりました。
- SAP アプリケーション コネクタのバックエンド データベースとして SAP HANA が追加されました。
管理者向けの新機能
カスタムセキュリティロール
- 特定の権限を持つカスタマイズされたロールを作成し、個人またはグループに対して権限を付与することができます。
- 初期リリースではExcelへのデータエクスポートについての権限のみですが、今後拡張予定です。
- User Default（既定のロール）で許可された権限を、カスタムルールで制限することはできません。
- スペースでの権限よりカスタムロールが優先して適用されます。
Capacity model の Basic User に Excel エクスポートの権限を与えることはできますが、スペース毎にエクスポートの許可・不許可をコントロールすることはできません。
ゲートウェイー直接アクセス
Direct Access gateway 1.6.5 がリリースされました。
新機能
- SAP ODP コネクタのサポート
- Qlik のサポートがトラブルシューティングするための新しいログの導入
- 日本リージョンのサポート
- 暗号化セッションのメモリ割り当ての改善によるパフォーマンスの向上
解決された問題
- セキュリティの脆弱性
- プロセス分離のパフォーマンス
- 誤ったインストール パス
テナント全体のホームのカスタマイズ
テナント管理者と分析管理者は、全てのユーザーのログイン時に表示されるホーム画面を作成することができます。管理者でない各ユーザーは自分の個人ページをカスタマイズできます。
Help: Qlik Cloud 分析 ハブのテナント全体のホーム ページのカスタマイズ
その他
- パフォーマンス評価が完了または失敗したときに、通知を受け取るように選択できます。
- ODBC ベースの Qlik DynamoDB コネクタが追加されました。以前の JDBC ベースの Qlik DynamoDB コネクタ(英語のみ)は、2024 年 7 月末まで引き続きサポートされます。
- Microsoft 365 のメールプロバイダにOauth 2.0 接続が行えるようになりました。
-
クラウドの上で
本ブログは On Top of the Cloud （著者：James Fisher）の翻訳です。 Qlik では、お客様のクラウド分析の採用を支援するジャーニーにおいて、私たち自身の”山頂”に到達しました。2022年に到達したモーメンタムは、それ自体が信じられないほど充実した経験でした。Qlik ... Show More本ブログは On Top of the Cloud （著者：James Fisher）の翻訳です。
Qlik では、お客様のクラウド分析の採用を支援するジャーニーにおいて、私たち自身の”山頂”に到達しました。2022年に到達したモーメンタムは、それ自体が信じられないほど充実した経験でした。Qlik Cloud のアクティブユーザーが 400% 近く増加し、1日で作成されたアプリの数は 1,500以上に達しました。
グローバルホームセンター小売業者の Leroy Merlin 社は、Qlik Cloud のフルパワーを活用して、店舗の従業員を含む何千人ものユーザーに実用的な分析を提供している、このクラウドジャーニーの最前線にいるお客様の 1社です。分析をオンプレミスからクラウドに移行することで、サーバーとハードウェアのコストを 70% 削減することができました。グローバル小売業者の Urban Outfitters 社は、Qlik Cloud を積極的に採用しています。これにより、すべての店舗従業員が個々の店舗の KPI のあらゆる側面に関する最新のデータを取得し、それらの洞察に基づいてすぐに行動することができます。
Qlik Cloud は、クラウドが提供する規模とコスト効率だけでなく、新しい機能を活用し、データ管理方法を革新し、最終的にビジネスのためにより良い、より迅速な決定を下すことができるため、世界中の組織における大きな価値の獲得を支援しています。今日、トップ 10 の顧客のうち 8社が Qlik Application Automation でデータと分析のワークフローを自動化し、Salesforce、Slack、Microsoft Teams などの一般的な SaaS アプリケーションに接続できる分析用のデータパイプラインを作成しています。分析用のデータパイプラインを流れるデータを完全に理解するのに役立つカタログとデータ系統機能のユーザー数は増え続けています。そして、Qlik Cloud に導入された強力な予測分析ソリューションである Qlik AutoML の導入も進んでいます。
Leroy Merlin 社を含む多くのお客様は、Qlik Cloud に移行する前に、クライアント管理の Qlik Sense または QlikView を使用していました。Qilk では顧客をサポートし、自社のペースで Qlik Cloud を採用できるように、リソース、ツール、ベストプラクティスの豊富なライブラリを提供するマイグレーションセンターを用意しています。
太陽はゆっくりと沈み始めていますが、私たちはこの山頂から降りるつもりはありません。Qlik Cloud で新しいデータ統合機能を開始しているからです。Qlik Cloud データ統合 は、自動化され、効率的で管理されたデータパイプラインを介して、分析およびデータエンジニアが企業品質のデータを統一、変換、配信するのに役立つように設計されています。当社のソリューションは、データの発信元やフォーマットに関係なく、共通のクラウドサービスを活用して、データの検索、操作、管理を容易にしながら、ほぼリアルタイムで、適切な送信先、適切なフォーマットで安全な配信を保証します。
また、より多くの組織が Qlik Cloud を採用できるように、セキュリティとコンプライアンスを強化しています。
-
米国公共部門の顧客向けに、Qlik Cloud Government では FedRAMP 認証を取得しています。Qlik は、このFedRAMP 認証を達成する唯一の包括的な Software-as-a-Service（SaaS）データ分析プラットフォームです。
-
私たちは、ヨーロッパの自動車産業に情報セキュリティシステムに対する一貫した標準化されたアプローチを提供する標準である Trust Information Security Assessment Exchange（TISAX） 評価を完了しています。
-
厳格な暗号化とガバナンス要件を持つ組織の場合、Customer Managed Keys を使用すると、Qlik Cloud でデータを保護するために独自の暗号化キーを持参できます。
-
HIPAA/HITRUST コンプライアンスにより、米国の HIPAA 規制要件の対象となる米国のヘルスケアおよびライフサイエンス組織は、プラットフォーム内で個人健康情報（PHI）データを使用する機能を含む Qlik Cloud の可能性を最大限に活用できるようになります。
- Qlik Cloud では日本リージョンを開設しています。これにより日本国内のお客様にデータレジデンシーによる経済的安全保障をご提供します。
また、Qlik Cloud にさらなる機能強化を導入しています。当社のレポート機能はパワーポイント出力をサポートし、ビジネスユーザーは目的の分析でプレゼンテーション対応機能を作成できます。また、OEM ISV パートナーとエンタープライズ顧客の両方に Qlik Cloud でマルチテナントプロビジョニングを提供しています。これにより、テナントの作成、構成、継続的なコンテンツハイドレーションなど、柔軟なクラウド API キーのオンボーディングとメンテナンスタスクを自動化する機能が提供されます。
Qlik Cloudは、組織が新しい機能を活用し、データの管理方法を革新し、最終的により良い迅速な意思決定を行うのを支援しています。
-
-
Silent Auth using qlik-embed and OAuth
On a previous blog post, we took a look at qlik-embed, Qlik’s newest embedding framework and saw how easy it is to get started using it to integrate c... Show MoreOn a previous blog post, we took a look at qlik-embed, Qlik’s newest embedding framework and saw how easy it is to get started using it to integrate content from Qlik directly in your web applications.
Today, we will see how to integrate qlik-embed UIs in your web applications that are connected to an OIDC-compliant IDP silently, without prompting users for authorization.
Before we get started, consider the following pre-requisites:
1- IDP:
- We need an IDP, in this blog post, I will use Auth0 which offers a Free starter plan that you can use to test out this functionality.
2- Qlik Cloud Tenant:
- We will configure the Qlik Cloud tenant with both the IDP provider and an OAuth Client.
3- Web App
- Our Web App will be served using Node.js, so make sure to have the latest node.js version installed
Step 1- Auth0 IDP Configuration
After creating an account on Auth0, create an Application and select “Single Page Web Application” as the application type.
Next,, navigate to Settings and take node of the following:
- Domain
- Client ID
- Client Secret
- OpenID Configuration URL (you will find this after you expand Advanced Settings under Endpoints)
We will need these values later on in the post.
In the allowed Callback URLs field, add the following URL:
https://{YOUR TENANT DOMAIN}.us.qlikcloud.com/login/callback
In Allowed Web Origins, add the following URL:
Step 2- Qlik Cloud Tenant Configuration
In this step, we will do 2 things, first, we will create and configure an identity provider. Second, we will configure an OAuth client.
2.1- Identity Provider:
- Navigate to your Management Console > Identity Provider > Create New
- Choose OIDC as the type
- Choose Auth0 as the Provider
- Enter the OpenID Configuration URL from Step 1
- Enter the Client ID and Client Secret from Step 1
- Expand Advanced Options and turn ON Email Verified Override
- You can now Save and then Validate the IDP configuration, this will prompt you to authenticate to Auth0 (make sure you have an active user).
2.1- Configure the OAuth Client:
-
Navigate to the Management Console > OAuth > Click on Create new
-
Select Single-page app as the Client type
-
Select user_default for scope
-
Add the following as your Redirect URL
-
Add the following in the allowed origins:
- Once your Save, Copy the Client ID
We will need it in the next step.
Step 3- Creating the Web Application
3.1- Server: We will use Express to spin up a small server and use the “express-openid-connect” as a middleware to configure Auth0 and require authentication when a user tried to access resources without being authenticated.
It will redirect the user to log in and then back to the site once successfully authenticated.
- the .env file should contain your Environment variables with the following:
- HOST → localhost:3000
- clientId → the client ID from Auth0 from step1
- clientSecret → the client secret from Auth0 from step1
- idpUri → the Domain from Auth0 from step1
- sessionSecret → A random string
- tenantUri → Qlik Cloud tenant
- redirectPage → oauth-callback.html
3.2- Frontend
- index.html: In the public folder, the index.html contains the setup for qlik-embed. In the script tag, the following values need to be entered:
- data-host: Qlik Cloud tenant
- data-client-id: The OAuth client Id from Step 2.2
- data-auto-redirect: set to True, this will remove the Authorize button that appears on qlik-embed UIs. It will silently redirect to Qlik Cloud if the user is authenticated.
- oauth-callback.html
This file contains a script tag with a qlik-embed callback. Make sure to set up data-host to your Qlik Cloud tenant url.
The entire source code can be found in the following Github Repo:
https://github.com/ouadie-limouni/silent-auth-qlik-embedRun the project:
First, you will need to generate a self signed certificate to put in the certs folder so we can be able to open localhost as https.
You can do this using openssl by following the directions below:
1- run the following command:
openssl genrsa -out cert.key 20482- then run and hit enter on all the prompts:
openssl req -new -key cert.key -out cert.csr3- then run:
openssl x509 -req -days 3650 -in cert.csr -signkey cert.key -out cert.crtyou will generate a cert.crt and cert.key files that you should put in the certs folder.
To compile and run the project:
- run: npm install
- then run: node index.js
Once you open https://localhost:3000, you will be automatically redirected to the Auth0 page.
After successfully authenticating in Auth0, you will be redirected to the web app and the qlik-embed UI will render the Qlik Sense app.
I hope you found this post helpful, for a more in depth tutorial and more, visit https://qlik.dev/embed/qlik-embed/
-
Football_app
Football_appHapag-LloydI did this app not for work obviously. It shows some football stats, but with focus on how the fact if game was played on home ... Show MoreFootball_appHapag-Lloyd
I did this app not for work obviously. It shows some football stats, but with focus on how the fact if game was played on home stadium or away impacted the statistics(like goals, shots, ball possession etc)
Discoveries
If team plays game at home, they score more, and win the games more often
Impact
It didn't, I did it just for myself 🙂
Audience
I showed it just to my Professor at my Business Informatics studies and my colleagues from the group. They liked it.
Data and advanced analytics
I used alternate states for it, to enable on one side of the dashboard to select games played at home, and on the second side games played away.
-
QlikView - New Security Patches Available Now
Update 21st of March 16:00 CET: published CVE numberUpdate 27th of March 10:45 CET: added FAQ Hello Qlik Users, A security issue in QlikView has been ... Show MoreUpdate 21st of March 16:00 CET: published CVE number
Update 27th of March 10:45 CET: added FAQHello Qlik Users,
A security issue in QlikView has been identified and patches have been made available. Details can be found in the Security Bulletin High Severity Security fix for QlikView (CVE-2024-29863).
Today, 20th of March 2024, we have released two service releases across the latest versions of QlikView to patch the reported issue. All versions of QlikView prior to and including the releases below are impacted:
- QlikView May 2023 SR1 (12.80.20100)
- QlikView May 2022 SR2 (12.70.20200)
Call to Action
As no workarounds can be provided, Customers should upgrade QlikView to one of the following versions that contain the fix:
- QlikView May 2023 SR2 (12.80.20200)
- QlikView May 2022 SR3 (12.70.20300)
This issue only impacts QlikView. Other Qlik data analytics products including Qlik Cloud and Qlik Sense Enterprise on Windows are not impacted.
Additional Details
- All Qlik software can be downloaded from our official Qlik Download page (customer login required). Follow best practices when upgrading QlikView.
- Qlik provides patches for major releases until the next Initial or Service Release is generally available. See Release Management Policy for Qlik Software.
- Notwithstanding, additional patches for earlier releases may be made available at Qlik’s discretion.
- The information in this post and Security Bulletin High Severity Security fix for QlikView (CVE-2024-29863) is disclosed in accordance with our published Security and Vulnerability Policy.
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.Frequently Asked Questions
Q: Is the vulnerability present in the QlikView Plugin or other QlikView products?
A: The vulnerability is related to the MSI files on disk.Q: Will deleting the MSI files mitigate the issue?
A: Qlik does not consider removing the MSI files a complete workaround. A server user can restore them. -
Checkout the New Pivot Table!
The New Pivot Table can quickly transform rows and columns into actionable insights with just a few clicks. You can organize, analyze, and visualize y... Show MoreThe New Pivot Table can quickly transform rows and columns into actionable insights with just a few clicks. You can organize, analyze, and visualize your data and even style various elements such as headers, borders, fonts, grid lines and more. Say goodbye to manual calculations and hello to dynamic summaries. Pivot Tables,. simplify complexity, reveal patterns, and take control of your information.
Try it now and elevate your data game to new heights.
Qlik Help: Pivot ObjectCan't See the video? - Check it out on Qlik's video site
-
The As-Of Table
Last week I wrote about how the Above() function can be used for calculating rolling averages and other accumulations. There is however also an altern... Show MoreLast week I wrote about how the Above() function can be used for calculating rolling averages and other accumulations. There is however also an alternative method for doing the same thing:
The As-Of table.
When you use the Above() function, you fetch a number from other rows in a chart or Aggr() table. The As-Of table is slightly different in this respect: It is not a transient table created by an object or an expression – instead it is a real table in the data model.
The idea is to create a secondary month field – the AsOfMonth - that links to multiple real months.
In the example above, you can see that ‘2015 Oct’ links to several preceding months, and each Month in turn links to several rows in a fact table. This means that a specific transaction will be linked to several AsOfMonths.
In the data model, the As-Of table should appear as a separate calendar table that links to the existing primary calendar table:
One way to create this table is the following:
First, make sure that you in your master calendar have a field “Month” that is defined as the first date of the month, e.g.
Date(MonthStart(Date),'YYYY MMM') as Month,
Then add the following lines at the end of the script:
// ======== Create a list of distinct Months ========
tmpAsOfCalendar:
Load distinct Month
Resident [Master Calendar] ;// ======== Cartesian product with itself ========
Join (tmpAsOfCalendar)
Load Month as AsOfMonth
Resident tmpAsOfCalendar ;// ======== Reload, filter and calculate additional fields ========
[As-Of Calendar]:
Load Month,
AsOfMonth,
Round((AsOfMonth-Month)*12/365.2425) as MonthDiff,
Year(AsOfMonth)-Year(Month) as YearDiff
Resident tmpAsOfCalendar
Where AsOfMonth >= Month;Drop Table tmpAsOfCalendar;
Once this table has been created, you can use the AsOfMonth as dimension in charts where you want rolling averages and accumulations.
If you as measure use
Sum({$<YearDiff={0}>} Sales)
you will get a yearly accumulation – year-to-date up until the day of the script run.
If you instead use
Sum({$<MonthDiff={"<6"}>} Sales) / Count(distinct {$<MonthDiff={"<6"}>} Month)
you will get a 6-month rolling average:
And finally, if you use
Sum({$<MonthDiff={0}>} Sales)
You will get the real, non-accumulated numbers.
I have made the Set Analysis expressions based on two fields: YearDiff and MonthDiff. However, for clarity it could be a good idea to add flags in the As-Of table, so that the Set Analysis expressions become even simpler, e.g.
If(MonthDiff=0,1,0) as IsSameMonth,
If(YearDiff=0,1,0) as IsSameYear,
If(MonthDiff<6,1,0) as IsRolling6,Summary: The As-Of table is a good way to calculate rolling averages and accumulations.
Further reading related to this topic:
Calculating rolling n-period totals, averages or other aggregations
-
Techspert Talks - Exploring Qlik Cloud Data Integration
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.Next Thursday, May 16th Qlik will host another Techspert Talks session and this time we are looking at Exploring Qlik Cloud Data Integration.
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:
- What it can do
- How it can be used
- Cloud Data Architecture
Click on this link to choose the webinar time that's best for you
The webinar is hosted using ON24 in English and will last 30 minutes plus time for Q&A.
Hope to see you there!!
-
Anglia Ruskin University students boost employability skills with Qlik Academic ...
In 2021 Anglia Ruskin were looking to create an optional module for students that could be included in their Certificate for Professional Development ... Show MoreIn 2021 Anglia Ruskin were looking to create an optional module for students that could be included in their Certificate for Professional Development and give students robust training in data analytics. In our success story we hear from Lecturer Practitioner, Tina Jia and ARUCPD Program Lead, Kate Summally, about the demand for more analytics skills and how the Qlik Academic Program formed the basis of the module.
They are now in their second year of delivering this module having received 100% student satisfaction after the first year of implementation, with two students having secured employment thanks to their knowledge of data analytics. Read the full success story to learn more:
-
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. Discov... 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) <<
-
Complete your Qlik Nation challenges in Qlik Community
Transformational. Innovative. Powerful. These are just a few of the inspiring terms customers use to describe Qlik and our product suite. Customer fee... Show MoreTransformational. Innovative. Powerful. These are just a few of the inspiring terms customers use to describe Qlik and our product suite. Customer feedback and input are critical to Qlik’s success, and we regularly hear directly from our most active users through Qlik Nation, our gamified customer engagement hub.
Through interactive challenges and activities, Qlik Nation members connect, learn, and engage with Qlik and with each other. By completing challenges in the platform, members can receive early notification of new product features, boost knowledge through quality educational content, and have opportunities to influence the product roadmap. Qlik Nation also allows customers to demonstrate skills, network with peers, and amplify their personal brand. All while having fun and being rewarded!
And now, Qlik Nation members will be able to complete challenges while visiting Qlik Community. Current members will see a new carousel on the Qlik Community homepage inviting them to complete challenges, making it even easier for you to engage and earn points.
Customers are at the heart of everything we do, and Qlik Nation offers an exclusive experience for our most dedicated and passionate fans (Qlik Nation is a complementary platform to Qlik Community, which has open membership). What do our members say about their experience in Qlik Nation?
- “It’s a fantastic opportunity to link up with technologists and data enthusiasts across a wide array of industries to learn and promote the best use of the Qlik product suite.” – Howard Teall, Enterprise Architect, HSBC & Qlik Luminary
- “Qlik Nation brings together all the news and knowledge in one place, keeping me up to date with Qlik and the world of data & analytics” – Mark Little, Senior Business Intelligence Specialist, Mayborn Group
- “Qlik Nation has provided me with a platform to keep me motivated and try and do better with our analytics platform and capabilities. The community joins you with like-minded individuals to share and promote everything Qlik.” - Willem Jacobs, Head of Analytics, OneLogix
If you’re a Qlik end-user and want to learn more about how to join Qlik Nation, please email QlikNation@qlik.com. We’d love to hear from you!
-
Will we see you at Qlik Connect? (+ May enhancements)
Hello Qlik Community! Less than a month until we see you all at Qlik Connect - we are SO excited to see everyone! Nicole and I will be working the reg... Show MoreHello Qlik Community!
Less than a month until we see you all at Qlik Connect - we are SO excited to see everyone! Nicole and I will be working the registration desk while Sue and Melissa will be at the Qlik Community booth. Make sure you stop by and say “Hi!”.
Here are your May enhancements for the Qlik Community:
Updated Social Icons
The Social icons in the footer have been updated.
Qlik Community Link in Footer
The Qlik Community link in the footer now points to the Water Cooler (previously went to the homepage). If you have any questions, meet us at the Water Cooler!
Events on Right Rail
The incorrect date was appearing on the right rail events. The logic has been fixed to display the correct date.
Reply Button Displays When Posting
When clicking ‘Reply’, the button to post also said ‘Reply’. This was confusing when replying to a comment where multiple ‘Reply’ buttons could display. The button now says ‘Post’. This was a member suggestion.
New Qlik Community Survey
There’s a new Qlik Community survey! We’ve disabled the old one where many people were receiving the pop up more frequently than they should have. The new one should appear once every 90 days (starting today), but let us know if you receive it more than that. The survey should take less than a minute to fill out! We genuinely love to hear your feedback and collect ideas on how to improve the Qlik Community from the survey.
Let us know what you think of the changes and if we will be seeing you at Qlik Connect in the comments below. There is so much happening and great content at Qlik Connect - amazing speakers, great sessions, certifications and announcements. Mike Capone also just announced the appreciation event - an evening at Universal Islands of Adventure! It will be an amazing few days! We hope you can join!
Your Qlik Community Admins,
Melissa, Sue, Jamie, Nicole and Caleb
@Melissa_Potvin @Sue_Macaluso @Jamie_Gregory
-
Qlik Cloud: Introducing OAuth2 authentication for the Microsoft 365 email provid...
As of May 7, 2024, Qlik has released an often-requested feature: the ability to set up your Microsoft Office 365 email provider with OAuth 2.0 authent... Show MoreAs of May 7, 2024, Qlik has released an often-requested feature: the ability to set up your Microsoft Office 365 email provider with OAuth 2.0 authentication, ensuring secure communication between Qlik Cloud and Microsoft Office 365.
How to get started
The setup is simple. If your IT wishes to use Microsoft Office 365 as your email provider for Qlik Cloud, see Configuring a Microsoft 365 email provider using OAuth2.
What to be aware of
Before using the Microsoft 365 service connection, please familiarize yourself with Microsoft’s terms of use for a single mailbox as per Limits per app ID and mailbox combination and Storage limits across standalone plans (learn.microsoft.com).
Keep Microsoft's API limits in mind before choosing your email provider. This includes requests per minute, concurrent requests, and size restrictions. Example: a capability such as Tabular Reporting can create large files as part of its reporting job creation, which may exceed Microsoft's service limits.
See Qlik Cloud: Sending email with Microsoft 365 fails for details.
Don't hesitate to reach out if you have any questions. We always look forward to your feedback.
Thank you for choosing Qlik,
Qlik Support -
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
-
生成AI どう使う？ChatGPTの機能と限界と活用事例～ChatGPTは歯科医師国家試験に合格するのか？～
５月２１日の無料Webセミナーのご案内です。今回は、いつもの TechTalk と違って、Qlik の長年のユーザーである九州歯科大学の守下准教授をお招きします。守下先生は、電子カルテシステムの運営・管理を手掛け、電子カルテ・医事会計システムなどの医療情報データを Qlik Senseで分析し、病院... Show More５月２１日の無料Webセミナーのご案内です。
今回は、いつもの TechTalk と違って、Qlik の長年のユーザーである九州歯科大学の守下准教授をお招きします。守下先生は、電子カルテシステムの運営・管理を手掛け、電子カルテ・医事会計システムなどの医療情報データを Qlik Senseで分析し、病院経営に貢献されています。また学生の成績データをQlik Senseを通じて分析し、Institutional Research 活動も展開されています。当日はインタビュー形式で、生成AIの進化と機能、実用例についてお話をお伺いする予定です。Qlik と組み合わせた使用方法についてもお伺いしたいと思っています。
守下先生は、これまでに大学経営、教育、病院運営にデータを活用する試みを多く取り組まれてきましたが、特に最近の注目すべき点として、ChatGPTがどのようにして歯科医師国家試験に回答したか、その結果と教育現場への応用可能性に焦点を当て、実践的な課題と洞察も共有いたします。
是非みなさまご参加ください。
お申し込みはこちら
