Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
By reading the Product Innovation blog, you will learn about what's new across all of the products in our growing Qlik product portfolio.
The Support Updates blog delivers important and useful Qlik Support information about end-of-product support, new service releases, and general support topics.
This blog was created for professors and students using Qlik within academia.
Hear it from your Community Managers! The Community News blog provides updates about the Qlik Community Platform and other news and important announcements.
The Qlik Digest is your essential monthly low-down of the need-to-know product updates, events, and resources from Qlik.
The Qlik Learning blog offers information about the latest updates to our courses and programs, as well as insights from the Qlik Learning team.
The Qlik Application Automation HubSpot block Get Contact by Email has been updated to the latest API version, pointing it to HubSpot v3 API.
The new version changes how input parameters are handled. While the current (old) block returns all properties by default, the new block requires explicitly specifying the fields you need.
Input Parameters available in the old (current) block:
Input Parameters available in the new block:
By default, it will only fetch data as shown in the example below. If additional details are required, input parameters like Properties, Properties With History, and Associations must be added.
Default example:
{
"id": "1",
"properties": {
"createdate": "2021-07-27T13:13:25.669Z",
"email": "emailmaria@hubspot.com",
"firstname": "Marino",
"hs_object_id": "1",
"lastmodifieddate": "2023-07-27T23:18:09.664Z",
"lastname": "Johnson (Sample Contact)"
},
"createdAt": "2021-07-27T13:13:25.669Z",
"updatedAt": "2023-07-27T23:18:09.664Z",
"archived": false,
"key_values": {
"createdate": null,
"email": null,
"firstname": null,
"hs_object_id": null,
"lastmodifieddate": null,
"lastname": null
}
}
Top-Level Structure Differences:
Old Response:
New Response:
Properties Structure:
Old Response:
New Response:
Timestamp Format:
Data Organization:
See the attached .JSON files for comparison responses between the old (hubspot-old-get-contact-by-email.json) and the new (hubspot-new-get-contact-by-email.json) block.
If you currently use the HubSpot connector's Get Contact by Email block and do not upgrade it to the new version, the block will stop functioning on May 30th, 2025.
{
"response": {
"status": 400,
"body": {
"errors": [
{
"code": "HTTP-400",
"title": "Invalid Request.",
"detail": "Missing mandatory parameter \"id\"."
}
]
}
},
"external error": false
}
If you have any questions, we're happy to assist. Reply to this blog post or take similar queries to the Qlik Application Automation forum.
Thank you for choosing Qlik,
Qlik Support
We are introducing a breaking change to the behavior of file paths returned by the DataFiles connector to Qlik Sense.
This update is designed to align DataFiles with the web storage provider connectors. This will better align the DataFiles connector's behavior with other connectors, such as S3, which return folder names with a trailing slash for the DirList argument in loops.
Other web storage provider connectors are not affected.
When using the DirList function with the DataFiles connector, the returned folder path does not include a trailing slash.
With the upcoming update, the DirList function will now return folder paths with a trailing slash—matching the behavior of other storage connectors like S3.
This change is part of our ongoing efforts to support file hierarchy enhancements introduced in Q4 2024 and to ensure consistency across all connectors.
The change will primarily affect loops or code configurations that rely on the specific behavior of the output from a DirList argument when processing directory paths. Customers who have implemented custom filtering logic based on the absence of a trailing slash may need to adjust their scripts.
Example script:
// List out the response from DirList as Dir
For Each Dir in DirList('lib://DataFiles/')
ShowThePath:
LOAD
'$(Dir)' as Path
AutoGenerate 1;
Next;
Before the fix, this will return:
Post-fix, this will return:
Thank you for choosing Qlik,
Qlik Support
I recently had an interesting use case for bookmarks that I thought I would share. I have a Qlik Sense app that will be accessed from more than one external source and the view of the app will differ depending on the referral link. In one scenario, the user is directed to the app overview of the app. In this scenario, no charts are highlighted. In the second scenario, the user is directed to a specific sheet in the app and a specific chart is highlighted. A message should also be displayed above the chart in this scenario. In this blog post, I will share an example of how this can be accomplished.
Here is a look at the original sheet:
And below is an example of the sheet with the top left chart highlighted. Notice that the chart is outlined and there is text above the chart. This is how the sheet should look in the second scenario when the user accesses the app via the bookmark URL.
To create the highlight for the chart, I added a layout container to the sheet. In the layout container, I added a text box for the highlight, a text box for the message and the chart I want to highlight. I made the background color of the first text object the color I wanted the highlight to be and positioned it behind the chart and a little larger than the chart (so that it appears like a border). I did not simply add a border to the chart because I want to control the show and hide of the highlight via a field value. The second text box has the message text and the same background color as the sheet.
I decided to use a field, _Message1, to control the show and hide of the highlight and the message. I added a table like the one below for this field.
I also use HidePrefix in the script before loading the table so that selections in this field do not appear in the selection bar.
I used the _Message1 field in the Show condition for the two text boxes (highlight and message) so that they were only visible when _Message1 = 1.
I also used the _Message1 field to change the bubble for the sales rep that I mentioned in the message. This can be done by using an expression to color the scatterplot bubbles.
Now, the only thing left to do is to create a bookmark that can be used to direct users to the Sales Analysis sheet and highlight the scatterplot. Before creating the bookmark, I went to the Sales Analysis sheet and selected 1 in the _Message1 field. Since I am hiding the _Message1 field, I made the selection in the browser URL by adding /select/_Message1/1 to the end URL while in analysis mode.
Now create a new bookmark and be sure to check ‘Save sheet location’ and ‘Save layout.’ To test the bookmark, clear selections in the selection bar and then select the bookmark. Don’t forget to make the bookmark public before publishing the app. Once the app is published, you can copy the link to the bookmark by going to bookmarks and clicking on the three dots next to the bookmark name and selecting Copy link. This bookmark link is what I used in an external source to direct users to the Sales Analysis sheet with the scatterplot highlighted. When I want to direct users to the app overview, I provided the URL to the app. The bookmark can also be used within the app, if necessary. If you do not want users to be able to clear the _Message1 field/remove the highlight and message, lock the field before creating the bookmark. This will prevent the _Message1 field from being cleared when the user clears all selections. To do this, you may need to temporarily remove the hideprefix in the script to lock the field.
If you would like to highlight a chart from within an app (and not an external source), consider using a button and the Go to chart action as seen in the May 2024 – Button Go to Chart sheet in the What’s New app. This allows you to add an action on a button that will not only direct you to a specific sheet but also to a chart that is temporarily highlighted.
This example illustrates how an app can have various views based on the referral URL. When accessing the URL to the app, the app is displayed without any chart highlights. Be sure to set the _Message1 field to 0 prior to publishing the app to ensure this. By using a bookmark URL, a message and highlighted chart is visible in the same app providing a different view for the user. This is just one of the many ways this can be accomplished in Qlik Sense.
Thanks,
Jennell
データ活用において、 生成 AI の可能性が注目を集めています。Qlik は、「Qlik Answers」 を通じて非構造化データの活用を促進し、「Qlik AutoML」による予測分析でビジネスを加速しています。さらに、 構造化データも扱えるようになることで Qlik Sense との連携をさらに強化。これにより、AI エージェントの実現に向けた取り組みも加速しています。AI エージェントは、ビジネス課題に対応する自動化された知識アシスタントとして、より直感的で効率的なデータ活用を可能にします。また、データ統合の領域でも生成 AI が活躍しています。 プロンプトによる SQL 自動生成やデータ品質管理の AI 活用 により、よりスマートなデータ管理が実現します。加えて、ノーコードで AI 向けの高品質なデータを生成できる「RAG Pipeline」機能も登場予定です。
本 Web セミナーでは、以下を実現する Qlik の AI 機能と今後のロードマップ、生成 AI を活用してビジネスの未来を切り開くヒントをご紹介します。
The new Qlik Learning has made joining a Live Instructor Webinar easier than ever. As a part of your Qlik Learning subscription, you enjoy the benefit of access to our Live Instructor Webinars. These interactive sessions, held in the different time zone, are delivered by our expert instructors on a variety of advanced topics that go above and beyond the content offered in our self-paced learning. Each session offers live demonstrations of the tools used and the opportunity to ask questions. Don’t see a topic you’re interested in learning more about? We invite you to fill out the survey at the end of each Live instructor session where you can submit suggestions for upcoming sessions you would like to see scheduled!
Join us for upcoming topics such as Using the Styling Options in the Presentation Sections for Selected Charts, Working with QVD Files, Virtual Proxy Configuration for Load Balancing, and many more.
Registered for a webinar but can’t make it? No worries! You will still have access to the on-demand recording after the webinar has concluded through the registration link.
Here’s how you can locate and register for a Live Instructor Webinar:
Browse the list of topics to find the one you want or filter by location, instructor, and date.
Need to quickly see what webinars or courses you’re registered for? Click the My Events tab to view the list. Here you will also be able to view those webinars and courses you have completed by clicking the drop-down next to Status and choosing Completed.
Questions? Reach out to us at education@qlik.com. Happy Learning!
Within Qlik Cloud Analytics, the Data Alerts feature offers users the ability to be notified of exceptions in the data. When scheduling a data alert, users can define the data conditions of interest within an app and have the option to configure a schedule setting when data is refreshed by a reload of the app.
There will be an improvement to this specific Schedule configuration setting in an upcoming release scheduled for the second half of March 2025.
Read more in Monitoring data with alerts.
Currently, the schedule configuration When data is refreshed (fig 1) by a reload of the app is evaluated every time the app is reloaded regardless of whether the data set within the app has changed.
fig 1
This has led to users receiving repetitive alerts for the same data status and risks "alert fatigue". It is also not the intended behavior of the feature as no alert should be sent if the underlying data set has not actually changed.
With the upcoming change to the Data Alerts feature, the underlying evaluation behavior for this schedule configuration (When data is refreshed by a reload of the app) will be optimized to evaluate only when there is new data available in the app and the app is reloaded. The same alert status may still be sent for a given condition, but the condition will always have been evaluated from a new data state in the app.
The impact of this change will reduce the number of alerts delivered to users in the scenario that the underlying data has not changed (on a reload), making the alert delivery more impactful. Of course, users can still use the configuration Compare with: Last evaluation (fig 2) to further optimize their alert delivery.
fig 2
Users who prefer a reload-triggered and repetitive (same data state) data alert might consider:
Thank you for choosing Qlik,
Qlik Support
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 insights from Qlik experts.
The Techspert Talks session from March looked at Embedding Qlik Analytics in SharePoint.
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:
Click on this link to watch the recording.
As the job market rapidly evolves, professionals across industries are realizing the importance of upskilling to stay competitive. With technological advancements and economic changes reshaping the workforce, it's more important than ever to focus on acquiring in-demand skills like AI, data analytics, cloud computing, and cybersecurity. Among these, data analytics stands out due to its broad applications and ability to secure your career's future. A Forbes expert emphasizes that data analysis skills are becoming essential as companies increasingly rely on data to make strategic decisions and maintain a competitive edge. The rise of AI-powered analytics and sophisticated data visualization is transforming unstructured data into actionable insights.
For a deeper dive into “The Top 5 Skills to Learn in 2025,” check out the full article here.
The Qlik Academic Program offers the resources you need to thrive in the digital economy. With access to powerful analytics software and comprehensive training materials, Qlik equips students and educators with the practical skills needed to excel in the data-driven world. Whether you're a student aiming to boost your data expertise or an educator seeking to provide your students with the latest tools, the Qlik Academic Program is a valuable asset for preparing the next generation of data-savvy professionals.
Discover how to access free resources in data analytics as a student or educator by visiting the Qlik Academic Program.
In my previous articles I talked about Nebula.js and the use with the existing extensions on major frameworks like React, Svelte and Angular.
Since the last one, a new extension was added, sn-table. Here is how to use it.
First install it
npm install @nebula.js/sn-table
Then import it and add it into your configuration
import table from '@nebula.js/sn-table';
...
{
name: 'table',
load: () => Promise.resolve(table),
},
...
If you have issues, you can view the entire configuration at https://observablehq.com/@yianni-ververis/nebula-js
Then, start adding dimensions and measures.
n.render({
element: chartElement,
type: 'table',
properties: {
qHyperCubeDef: {
qDimensions: [
{ qDef: { qFieldDefs: ['Case Owner Group'] }, qNullSuppression: true, qLabel: 'Department' },
{ qDef: { qFieldDefs: ['Priority'] }, qNullSuppression: true },
],
qMeasures: [
{ qDef: { qDef: 'Avg([Case Duration Time])', autoSort: false }, qSortBy: { qSortByNumeric: -1 }, qLabel: 'Avg Duration' },
],
qInterColumnSortOrder: [2, 0, 1],
qInitialDataFetch: [{
qWidth: 3,
qHeight: 3000,
}],
},
showTitles: true,
title: 'Table',
subtitle: 'Sample supernova table',
footnote: '',
totals: {
show: true,
},
},
});
You should have something like this
View the entire example here
https://observablehq.com/@yianni-ververis/nebula-js
https://observablehq.com/@yianni-ververis/nebula-js-table
Happy coding!
/Yianni
企業のビジネス活動において、データはこれまで以上に必要不可欠な資産となっています。増え続けるデータを管理・統合・分析し、データでアクションを起こす必要性が増している現在、成功している企業はどのようなデータ戦略を実行しているのか?
本 Web セミナーシリーズでは、Qlik でデータからアクションを起こすデータ主導のビジネスで成功しているお客様より、課題から導入の経緯、デモンストレーション、活用例などをご紹介します。
ヒューマンアカデミー株式会社は、データ活用を軸にした教育 DX を推進し、学習体験の革新と教育機関の運営効率向上を実現しました。その中核を担うのが 統合データベース(DB) です。売上、反響、営業履歴、学習履歴や成績データを一元管理し、蓄積されたデータをもとに最適な教育サービスを提供する環境を構築しました。このデータ基盤を活用するために業務に BI を導入し、営業プロセスを可視化・最適化。人的リソースの最適配分や迅速な意思決定が可能になりました。また、サービスの BI により受講生の学習状況を把握でき、学習者ごとに適切なサポートを実施しています。
効率的な学務運営を可能にし、データドリブンなアプローチで次世代の教育サービスを実現した取り組みについて、デモを交えてご紹介します