Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
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.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
What's New in Qlik Cloud:
Stay in the Know: To stay up to date on what’s new, bookmark qlik.com/roadmap for access to all product innovation resources, including our Product Innovation Blog. You can also subscribe to the RSS feed for our SaaS Change log.
Subscribe to our Support Updates blog to receive important updates and new service releases.
Discover how to empower your organization to be more data-driven in Qlik’s new analytics webinar series, Moving Beyond the Dashboard.
Qlik Insider Webinar – Join us on August 24 to hear what’s new and upcoming across our data integration and analytics portfolio, and get your questions answered by Qlik experts.
What does it mean to be data brilliant? Listen to Qlik's Chief Learning Officer Kevin Hanegan as he discusses how soft skills and cognitive diversity can power a data literate organization.
Enabling communities to combat human trafficking with data
See how Engage Together created an application to shine a light on the strategies needed to expose human trafficking, using the power of data.
Enjoyed this month’s edition? Subscribe for more news every month.
Connect with us on LinkedIn, Facebook, and Twitter. If you have any comments or feedback we would love to hear from you. Please contact lucy.bannister@qlik.com.
Custom Templates
The introduction of templates in December 2021 increased developer productivity and enabled more significant knowledge transfer because you could start your project from a sample automation rather than from scratch. However, from the outset, many of you have requested the ability to create and distribute your own custom templates. Well, I'm happy to announce that now you can.
To create a template from your automation, right-click on the canvas and choose "Save as template" from the pop-up menu.
Then give your template a name, an optional thumbnail and description, and choose the appropriate sharing options from the visibility dropdown.
Your custom templates will then appear in the "Shared" or "Personal" template category.
We think sharing custom templates will vastly improve your collaboration in your development teams and enable you to establish your own best practices.
New Connectors
Your feedback has always heavily influenced our connectivity development roadmap and the crop of connectors we delivered this month is no exception. The new connectors are as follows:
The Twitter connector and blocks enable programmatic access to the Twitter 2.0 API to help you tap into core elements of the Twitter-sphere. The blocks mainly focus on search and read access, although two blocks provide the ability to make raw Twitter API requests.
When combined with other connectors, many new automation use cases and possibilities emerge. For example, by combining Twitter with Expert.ai you can create a flow that automatically performs sentiment analysis on a Twitter stream query to guide your downstream decisions.
Note, the Twitter connector requires you to provide your API Key and Secret from your Twitter Developer account via the Twitter Developer Portal. Also, the connector conforms to the API limits defined by your Twitter access level. Please refer to the knowledge base article How to: Getting started with the Twitter connector in Qlik Application Automation for more details on how to use the Twitter connector.
Oracle Eloqua
Another customer request was for Oracle Eloqua. The Oracle Eloqua connector joins other best-in-class marketing automation platforms like Hubspot and Adobe Marketo Engage, already supported by Qlik Application Automation. The new connector allows you to automate your campaign and lead management tasks via Custom Object records. For example, you can make an automation to automatically assign accounts to different campaigns based on sales threshold values identified by a Qlik analytics app.
Read this knowledge base article for more information on how to get started with Oracle Eloqua and Qlik Application Automation.
Zenput
Several customers requested the new connector, and we're happy to roll it out this month. Zenput (a CrunchTime! company) provides a "back of house" solution to help restaurants, convenience stores, grocers, and other retail chains manage food safety and improve staff productivity.
The Zenput connector exposes four blocks that enable you to build and run data-driven staff management workflows. You can list tasks, get a task, create tasks, and update tasks. For example, a restaurant chain uses a Qlik analytics application to manage operational KPIs such as fire saftey training completion for each restaurant in the group. The KPI app can highlight which restaurants are not in compliance and can automatically launch a fire saftey check workflow to the managers of thiose specific restaurants.
Read the following article to learn more about Qlick Application Automation and Zenput to get started.
Inphinity
Last but by no means least is the Inphinty connector. Inphinity has been a long-time Qlik partner and provides a product called Inphinity Forms. Inphinity Forms help you efficiently enter, edit and update data from within Qlik Cloud analytics applications in a process known as "write-back." The new Inphinity Connector further extends this capability because you can now create automations that read and write form data as part of a downstream process, e.g. approval workflows.
To discover more information about working with Qlik Application and Inphinity Forms, read this knowledge base article here. And watch this webinar here for ideas about combining Inphinity and Qlik to drive data collaboration throughout your business.
Final word
This month's final phrase is "thank you" to all our customers who contributed ideas and feedback. You know who you are; we couldn't improve our solution without you. Remember, if you want to request a new connector, connector enhancement, general improvement, or new feature, please submit an ideation request here.
Qlik was recently named a Leader in the IDC MarketScape: U.S. Business Intelligence and Analytics Platforms 2022 Vendor Assessment . What is MarketScape? IDC MarketScape is the IT industry’s premier vendor assessment tool, providing in-depth quantitative and qualitative technology market assessments.
The report shares “Business intelligence and analytics software is one of the most visible pieces of the technology stack that enables data-driven or data-informed decision making and greater enterprise intelligence. While data warehouses, data lakes, lake houses, and various data integration and data intelligence software form the foundation of an organization's data and analytics technology architecture, it is BIA software that data analysts, business analysts, and others in the organization interact with daily.”
Several of the reasons Qlik received its ranking are based on its end-to end platform, automation, data governance and sovereignty, and its extended Platform Value. For the full article visit
As someone who has been working with students and educators learning Qlik for more than 10 years, this report comes as no shock to me. For years we have seen interest from academia to learn Qlik because its such an important factor in the business world. It's amazing to hear their feedback. Don't take my word. Listen to what our members have to say. Paul De La Fuenta from Texas A&M was asked to describe his experience he answered " I love it! It was so great to use!" Or Educator Gabriel Olivares from Universidad Andrés Bello who explained that Qlik was "Very useful for the development of management control system classes, so students can learn by creating control panels and discovering the cause-effect relationships that exist between the data".
University educators and students can learn more and apply today, https://www.qlik.com/us/company/academic-program
The Korea Agro-Fisheries & Food Trade Corporation (aT) is a government organization that promotes the global trade, export, and marketing of Korean foods and beverages. Previously, aT’s users could only access fixed and standardized reports developed using complex processes such as step-by-step data processing and database design. Insights were often out of date, difficult to access, and lacked accuracy.
Utilizing Qlik’s data analysis and visualization features, aT has been able to develop a big data analysis platform driven by customer perspectives such as annual trading volumes and monthly price trends for specific agricultural products. aT can now quickly analyze data relating to products, prices, trading volumes and locations, and access insights in one place.
Key benefits for aT include increased consistency and accuracy of analysis, and significant savings in both costs and time, as data is updated quickly and easily. aT has recorded large increases in usage by both internal staff and general users following the deployment of Qlik, including a 36% rise in the number of users over the previous year.
Full Success Story https://rv.roinnovation.com/Qlik/x/Default.aspx?4159c073b1ad48bcbbda69036b4aff51
When we released this tool (https://community.qlik.com/t5/Qlik-Design-Blog/Qlik-Partner-Engineering-Team-releases-Qlik-AWS-Cost-Explorer/ba-p/1946393) some weeks ago, some partners and customers came up with another request.
"Is this possible to have the same for Azure?"
That was a challenge that was accepted. I´ve spent some time learning from Microsoft documentation how to extract data from Azure (https://docs.microsoft.com/en-us/rest/api/billing/) and after some time was possible to connect Qlik Sense to the API and extract data using our REST connector.
The app is published in Partner Engineering Github (https://github.com/Qlik-PE/qlik-azure-cost-explorer) with instructions to download and configure.
This app is 100% pure Qlik Sense script, you have everything you need in your SaaS Tenant or Client Managed instance. No special drivers or connectors are required.
Please feel free to contribute and suggest any improvements
The new Simplified Authoring will be available and enabled globally on August 9th in the Qlik Cloud Platform for Qlik Sense. This experience makes quickly creating layouts and visualizations even easier with a new all-in one interface.
It will provide the following benefits to new and existing Qlik Sense SaaS users:
As previously mentioned, on July 5th we gave tenant admins the ability to “turn on” the Simplified Authoring for all their users, after admins have become familiar with the new capability. This will be followed by the Global activation of Simplified Authoring for all Qlik Sense SaaS tenants on August 9th.
Simplified Authoring Video Resources:
Welcome back to our tour of the Qlik Management Console. As stated in my previous installment, we will begin going through the different sections of the Qlik Management Console with an in-depth view of the different options to help you get the most of your experience with Qlik SaaS. Today we will be looking at the Governance section.
First up in Governance is Users. This section will display information regarding, well, Users. Here you can see the names of everyone that has access to your Qlik account, the email addresses, user IDs, their status, roles and, if you have sent them an invite, when it will expire. In this section you can also send invites to accounts to join your tenant and edit their roles within the tenant. In the Permissions subsection, you can assign roles for those in your tenant.
User allocation is second in this section. User allocation displays information tied to your tenant’s users. You’ll find breakdowns of each role on your tenant. User Allocation also displays how many users can be in a specific role and how many users that role has.
Spaces allows you to view the different spaces attached to your tenant. You can view the name of the space, the type of it, who owns the space, the description of the space, when it was created and if that space is tied to a Fort.
Alerts is a great feature within Qlik SaaS that allows a user to set up notifications for when a specified event is triggered. In the Qlik Management Console, you can view the different Alerts attached to your tenant. This section gives you all the information you could need about your Alerts; the name, the owner, when it was evaluated, triggered, which it’s going to be evaluated again, when the alert was created and if the Alert is enabled or not. Here you can also disable or delete Alerts and transfer the ownership of them to another user on the tenant.
With Subscriptions, subscribers receive charts and sheets through email according to a schedule set by the user. The Subscriptions option in the Qlik Management Console allows you to control the subscriptions on your tenant. In this section you can delete, disable, or enable a subscription.
In the Schedules selection, you’ll find the scheduled tasks connected to your tenant. These tasks are when apps would be reloaded. You’ll also find the name of the app, when the reload was last performed, and when it will occur next. You can delete a schedule here as well so that it no longer reloads an app.
Events displays a log of the events which have transpired on your tenant. You’ll find when the event happened, where it came from, what type of event it was, and which user was responsible for the event.
Thank you for taking the time to learn more about the Qlik Management Portal. Be sure to look for my next installment where we’ll be looking at the Content section. If you'd like further information on administering in QMC you can click here!
Hello Qlik Community.
This is Dipankar from Qlik R&D and today I am going to introduce the latest version of Nebula - version 2.0. Since the initial release of Nebula, the R&D team has been working on improving various capabilities within the library to help developers achieve more agility and robustness in terms of developing/embedding Qlik's visualization using Nebula. With the new version, we take this a step further.
What is Nebula 2.0?
Nebula 2.0 is a collection of the following items:
Let's talk about each of these items in some details.
Updated chart packages:
While nebula.js provides capabilities and APIs to build mashups and custom visualizations, it's primary purpose is often to display Qlik developed charts. These charts are available through npm under the @nebula.js scope. With the latest release, the focus is on streamlining the charts. Now, you can find an inventory of all the supported Nebula charts under the 'visualizations' library in qlik.dev -
An interesting addition to the charts is the 'Package and core build' part. With Nebula 2.0, when you have multiple charts, using the "core" build can significantly reduce the overall size of your bundle, thus reducing the amount of code that needs to be downloaded every time and executed. Here is an example link that shows how to achieve this - https://github.com/qlik-oss/nebula.js-examples/tree/main/examples/simple-setup . We believe this can be very beneficial from a performance perspective.
Nebula CLI:
Nebula 2.0 updates the robust Nebula CLI which is the main entry point for getting started with a nebula visualization, enabling a local development server, and building extensions and mashups. This version also streamlines the commands for usage. The four commands are listed below:
Nebula API:
The Nebula API has some new functionality -
You can also alter property definition for field-listbox now. See an example below that shows how to change sorting.
nebbie.field('[My Field]').then((s) =>
s.mount(document.querySelector('.listbox'), {
properties: {
qListObjectDef: {
qDef: {
qSortCriterias: [
{
qSortByState: 0,
qSortByAscii: 1,
qSortByNumeric: 1,
qSortByLoadOrder: 1,
},
],
},
},
},
})
);
Apart from these, Nebula 2.0 also exposes class names for embedded charts that allows for basic theming capabilities.
div.njs-cell {
background: maroon;
}
p.njs-cell-footer, h6.njs-cell-title, p.njs-cell-sub-title {
color: white;
}
button.njs-cell-action {
color: white;
}
Improved Documentation:
Overall, Nebula 2.0 solidifies the official documentation throughout the Qlik Developer site. I particularly like the Specifics section for each of the chart that serves as a guide in getting started with understanding & developing the Nebula-based visualizations. Be sure to check it out.
Hope this post helps you leverage all the amazing capabilities of Nebula 2.0!!
We will curate and share a Nebula 2.0 playlist in Glitch soon for our developer community, so keep an eye out.
~Dipankar
大手文具メーカーのぺんてる株式会社は、2022年に Qlik Sense を導入。Qlik で独自のアプリを作成し、IoT デバイスからリアルタイムのデータを取得して、社内設備の利用状況を可視化しています。また、Qlik Sense の社内勉強会を実施するなど、全社におけるデータ活用を推進しています。本講演では、Qlik Sense アプリコンテスト「第 2 回 Qlik データソン」でリアルタイム分析賞を受賞したアプリをご紹介いただくほか、Qlik 営業担当者および技術担当者との対談にて、アプリ制作の裏側や今後の展望などを詳しくお話しいただきます。
Last week, I had the opportunity to visit the city of pearls, Hyderabad in the State of Telangana, India. The occasion was to visit two Qlik Academic Partner institutions, Anurag University and Vidya Jyothi Institute of Technology ( VJIT).
But first, why is Hyderabad called the city of pearls? Reason is that this city had once flourished as a global center for trade of rare diamonds, emeralds as well as natural pearls. Hyderabad has been supplying the finest pearl jewelry to India and the rest of the world for nearly 400 years! Today, besides its glorious history, Hyderabad is also a hub for many global IT companies.
Anurag Group of Institutions organised a student interaction with their Engineering students and along with that an interaction with the educators including the Head of Department of Computer Science Engineering, Dr. Rawat. An audience of about 60 students and 10 educators listened with great attention on the Qlik Academic Program and Career in Data Analytics.
VJIT is another strong partner of the Qlik Academic Program with many firsts to its credit. The first Centre of Excellence powered by Qlik was set up here and they have been regularly engaging with us, with students showing interest in the academic program and getting qualified learning from the pathways of Business Analyst and Data Architect. During my interaction with students at VJIT, the track winners of the Datathon Challenge organised by us we were joined in by Sri Teja Makam and Vinay Kumar Kandula who are pursuing their MS in the US. They spoke about how the academic program has helped them in their career and their experience participating in the Datathon. Students were quite encouraged to hear their alma mater speak and how they are advancing in their careers. The MOU between VJIT and the Qlik Academic Program was renewed to extend this relationship for the next few years, formally.
Direct Queryは、SQLプッシュダウンにより、ユーザーの操作に応じて直接クラウドデータベースからデータを参照する機能です。
Direct Queryは、業界をリードするQlikの分析エンジンとは異なり、ソースに対してSQLクエリをオンザフライで生成し、データベースレベルでクエリと計算を実行します。インメモリにデータを格納しないので、ビッグデータや、リアルタイムのユースケースに適用することができます。Qlikの強力な分析エンジンを補完し、データ分析の幅を拡張することができます。まずはSnowflakeに限定した機能ですが、ロードマップにはDatabricksなどその他のコネクタが予定されています。
Direct Queryの使用手順は次の通りです。
ユーザーがシート上で選択やフィルタリングを行う都度、データベースにクエリが発行されデータベース上で計算が行われます。
TECH TALKで詳しくご紹介しています。
動画:最新データにライブ接続!Qlik Cloud Direct Queryのご紹介
資料:TECHTALK_20220802 Direct Query.pdf
その他の情報(英語)
Direct Query now available in Qlik Sense SaaS!
Part 1: Overview and Operation
Part 2: Building Hybrid Analytics Solutions with On Demand App Generation (ODAG)
この 8月に Qlik の日本オフィスが移転となるため、見納めと企業視察(?)を兼ねて Qlik アドボケイトミートアップを六本木一丁目オフィスにて開催しました。当初はリアル開催のみの予定でしたが、コロナ感染の状況を踏まえ、急遽オンラインとのハイブリッド開催となり、それぞれ10名前後の方が参加されました。
オフィスではビールと軽食を用意し、オンラインの方にも飲み物をご用意いただいて(自社オフィスからご参加の方、申し訳ありませんでした!)カジュアルな雰囲気でスタート。冒頭に、今回から会を進行いただく Qlik Luminary の SEGA 萬さまから、あらためてユーザーが主導するユーザーのための会であるとの位置づけや、一緒に会をリードいただけるメンバーを募集中とのお話をいただきました。
アドボケイトメンバーも増えつつあり、今回はお互いを知るために、自己紹介や各社の取り組み、Qlik に関して一言などをお1人ずつお聞きしましたが、Qlik の話となると盛り上がり、時間内では全員の紹介が終わらず(想定通り?)、若干の延長となりました。いったん、中締めとした後もオフィス組は他のメンバーや Qlik 社員との Qlik 談義が尽きないようでした。
QlikView 時代からのユーザーと新しいユーザー、技術部門と財務部門、アプリを作る方と使う方など様々な立場の方が「Qlik をどう活用していくか」という共通のテーマで議論し広めていく Qlik アドボケイト。ここでの議論や知見を、多くのユーザーの方にもお届けしたいと思います。是非ご期待ください。
While working on a project last month, I was introduced to the Qlik Management Console and was amazed at the number of settings contained within the console. Being new to the Qlik Community, my eyes were opened to just how much control this menu can give to a user. With this discovery, I sought to learn more about the Qlik Management Console to further educate myself and assist others in learning just how much control you have over your Qlik account so you can make sure that everything is running just how you would like it.
The Qlik management Console is quite expansive, and far too much to go over in just one blog entry. For now, let’s begin with the basics in this entry with a quick overview of the Console. Don’t worry, we’ll be going further in depth in future entries.
The Console is divided into four categories:
Governance- This is where permission and account-wide preferences can be chosen. Here you can view and allocate your users, view and edit subscriptions, see what has been scheduled, explore upcoming events alerts, and manage spaces.
Content- As the title suggests, this is where you’d find the settings for your content contained within your account. You can view every App throughout the account, the data that has been uploaded, automations that have been set up, the extensions that have been integrated into the account as well as the themes that have been created or uploaded.
Integration- This section handles security for anything outside of Qlik that you are bringing into the environment of Qlik Cloud. This section is for making sure authorizations are on the up and up. Here you can monitor your API keys to check for any suspicious activity. This section would be used frequently if you are developing apps that connect to your Qlik tenant.
Configuration- In this section you’ll find your settings for your Qlik account with a wealth of options, too many to number in a quick overview. You can also manage your identity providers for logging into the Qlik tenant. Additionally, this is where you would set up a Fort if you would rather bring Qlik Cloud to your data.
Please note that this is only a quick preview of the Qlik Management Console. In upcoming blog posts, we’ll go through each category, looking at each option and how you can use them to get the most out of Qlik Cloud.
The Global Transformation Awards recognize customers using Qlik technologies to drive remarkable business outcomes through data. Below are extensions of the short videos played during QlikWorld 2022. These videos genuinely capture each story in more detail:
Estatus de las empreas en México
Definir el sector que requiere mayor atención en el país
Empresarios, emprendedores, gobierno
5 millones de datos de empresas
What is Data Literacy? It's not just a buzz word, its the future of our work force success! Listen in as Kevin Hanegan and Joe DeSantos explore the definition of data literacy and why it means different things to different people during this latest episode of Data Brilliant. Listen now, https://linktr.ee/DataBrilliant
Hey Guys
This is a webinar / presentation extract from the Do More with Qlik Webinar series. "A Day in the life of a Qlik Cloud User" covers many features and capabilities of the Qlik Cloud Platform that can be used to explore your data, take action on your findings and make informed business decisions.
Can't see the video? YouTube blocked by your region or organization? Check out our company video hosting site here to view this video:
Sign up for the next Do More with Qlik:
https://pages.qlik.com/DoMorewithQlikWebinarJulySession.html?utm_content=mtoYTDITL&utm_medium=social&utm_source=YouTube&utm_team=PDT&utm_term=mtoYTDITL&utm_mpt_id=CGHNVX
Do More with Qlik Archive:
https://pages.qlik.com/21Q3_QDEV_DA_GBL_DoMorewithQlikTargetpage_Registration-LP.html
The video covers many different capabilities of the Qlik Cloud Platform.
00:00 - Introduction
00:32 - Topics to be covered
02:34 - Alerts, Notifications & Qlik Sense Mobile - Scenario Setup
Let's prevent cancellation of unfulfilled orders! (starting your day )
08:39 - Qlik Sense SaaS Hub
09:40 - Launch a Qlik Sense app - App Overview, Sheets
10:00 - Order Fulfillment Dashboard - Identify the issue, Alert the Staff! (setting variables, kicking off real-time app automation workflows to process notifications, operational report distribution)
16:23 - Data Storytelling - Collect what we learned to present to our management team
18:50 - Let's see how our sales are doing - Current Month Analysis - Explore and Discover
19:50 - Time to take action - Collaborative Notes - Let's tell that Sales Rep "Stop with the discounts!"
22:50 - Ways at presenting the data / information -
25:00 - selections - green, white, gray
28:00 - Insight Advisor - natural language queries - auto chart suggestions
29:45 - link to external applications
30:40 - Global Smart Search
31:24 - share, export charts, pdf, images, excel, iframe, links, email
33:50 - Insight Advisor Analysis Types
37:00 - Explore - creating alerts
38:50 - Insight Advisor - natural language questions - sales guy is taking advantage of discounts (switch back and forth)
39:52 - linking to external applications - KPI drill to another sheet
41:36 - saving selection states - bookmarks
43:00 - changing variables, goal and performance tracking
Qlik で予測不能な時代のサプライチェーン管理を変革
老舗食品メーカーの Qlik Cloud® 成功事例
世界各国でサプライチェーンに大規模な障害が起きている中、製造小売業界の最優先事項は、俊敏性です。英国の大手食品メーカー Whitworths 社は、リアルタイムのデータと分析で、この障害に迅速に対応することができました。
本 Web セミナーでは、同社のご担当者より、その取り組みと成功例をご紹介します。サプライチェーン管理への最新のアプローチで、サプライヤー・パートナー・顧客のニーズを継続的にサポートしながら競争優位性を獲得した方法をご確認ください。
In our last video we looked at how to implement complex SDLC environments in Qlik Sense Enterprise SaaS. However we only looked at this from the point of view of a single path from Development to Production. Some organizations also separate their SDLC tiers horizontally. For example a customer may have Finance, HR and Sales in separate work-streams due to governance, information barriers or simply by preference. How to achieve this is not immediately obvious in Qlik Sense Enterprise SaaS.
In this video we will show how we can build context-aware applications so, your applications will know not just whether they are in Development, Test or production, but also whether they are a Sales, Finance or HR app. We will do this using built-in functionality of Qlik Cloud. We will also look at using these techniques to manage external script libraries so we can ensure we use the correct version of libraries based on where our apps reside.
Análisis what if para el descubrimiento de datos
Impacta desde la parte estratégica de la compañía
Gerentes y coordinadores
What if