Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Edited August 30th, 15:55 CET: Added clarification on older Qlik Sense Enterprise on Windows versions
Edited August 31st, 13:10 CET: Added clarification on possible workarounds (none exist) as well as information regarding what authentication methods (all) are affected and that HTTP and HTTPS are impacted
Edited November 21st, 8:40 CET: Added clarification to apply the latest patches
Hello Qlik Users,
Two security issues in Qlik Sense Enterprise for Windows have been identified and patches made available. Details can be found in Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-41266, CVE-2023-41265).
This announcement from August 2023 and the mentioned releases only cover CVE-2023-41266 and CVE-2023-41265. Apply the most recent patches as documented in Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-48365) (September 2023), which resolve CVE-2023-48365 as well.
Today, we have released five service releases across the latest versions of Qlik Sense to patch the reported issues. All versions of Qlik Sense Enterprise for Windows prior to and including these releases are impacted:
All prior versions of Qlik Sense Enterprise on Windows are affected, including releases such as May 2022, February 2022, and earlier. While no patches are currently listed for these versions, Qlik is actively investigating the possibility of patching older releases.
No workarounds can be provided. Customers should upgrade Qlik Sense Enterprise for Windows to a version containing fixes for these issues. August 2023 IR released today already contains the fix.
This issue only impacts Qlik Sense Enterprise for Windows. Other Qlik products including Qlik Cloud and QlikView are NOT impacted.
All Qlik software can be downloaded from our official Qlik Download page (customer login required). Follow best practices when upgrading Qlik Sense.
The information in this post and Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-2023-41266, CVE-2023-41265) are disclosed in accordance with our published Security and Vulnerability Policy.
What can be done to mitigate the issue?
No mitigation can be provided. An upgrade should be performed at the earliest. As per Qlik's best practices, the proxy should not be exposed to the public internet, which reduces the attack surface significantly.
What authentication methods are affected?
All authentication methods are affected.
Are environments with HTTP disabled impacted?
Environments will be affected regardless if HTTP or HTTPS are in use. These vulnerabilities affect the HTTP protocol overall, meaning even if HTTP is disabled, the environment remains vulnerable.
These attacks don’t rely on intercepting any communication, and therefore, are indifferent whether the HTTP communication is encrypted or not.
Kind regards, and thank you for choosing Qlik,
Qlik Global Support
Today’s corporate environment is global. QlikView application developers are required to support many regions and many languages. So how does a QlikView application developer handle multiple languages? Well, that depends on how the data is captured and the overall goal of the application developer. Let’s look at two scenarios.
Scenario 1: The developer only needs to translate the labels and textboxes within the application and not the actual data.
=Only({<Index={12}>} [$(=vDataLanguage)])
for all textbox and object captions that need to be translated.
Scenario 2: The data from which the QlikView application developer is developing is recorded in English but he/she needs to have some of the actual data translated into other languages.
=$(vIndustry).
That’s it! Easy, right? Well, it is a bit time consuming if you are trying to translate data in fields but translating text and labels is really not that difficult. I created a technical overview that walks you through the two scenarios mentioned in this blog as well as a third scenario which can be found here. This resource includes a How-To, sample data files and 2 QVWs.
Good luck with the translations! Lycka till med översättningarna! 翻訳で頑張ってください!
As part of this special edition, we’ve added an extra live session with Arthur Fantaci, one of our top experts. He will share a fascinating success story in which he used Qlik AutoML to solve a big challenge in the healthcare industry.
What’s the story?
Arthur worked with a healthcare media company that needed to sort its anonymous website visitors into medical specialty groups. At first, they used 12 different machine learning models to do this, but the process was slow, manual, and full of errors. With Qlik AutoML, Arthur created an automated solution that reduced the 12 models to just one, making everything faster and more accurate!
Why is this bonus so awesome?
Getting to see how an expert tackles a real-world problem is something you don’t find in just any course. Plus, you’ll be able to ask questions live, clear up any doubts, and take away practical lessons that you can start using right away!
Arthur Fantaci is usually busy helping our clients, so having him in this course is a huge privilege. His experience in predictive analytics is something that won’t be available again for a long time.
Don’t miss this amazing chance:
Don’t wait—sign up now and grab this amazing opportunity!
The 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 Object
Can't See the video? - Check it out on Qlik's video site
Qlik Customer Support now available on Stitch!
For our Stitch customers, Qlik Support is now seamlessly integrated within your product connecting you with expert assistance. Select the green chat bubble at the bottom right of your Stitch environment to start chatting with support.
With the introduction of our generative support chat, you can now receive immediate and reliable responses validated through Qlik’s expert-led documentation. If you need more in-depth help, our team of Support Engineers are available 24/5 to chat live and troubleshoot any issues you may encounter. This comprehensive support ensures you receive timely solutions, keeping your Qlik experience smooth and productive.
In addition to quick AI-generated answers, you’ll gain access to Qlik’s Customer Portal, to manage your support needs and explore a wealth of resources, including our library of knowledge articles. Stitch has the power of Qlik Global Support behind it, and we’re here to help you through your data journey.
Note: Now that Stitch support is fully integrated within Qlik Global support, stitchsupport@talend.com is no longer in use. Please leverage your in-product Support chat or contact us through the Customer Portal For Assistance.
Additional Qlik Talend Cloud application connectors
We’re continuing to expand the connectivity of Qlik Talend Cloud with the addition of more insurance and security-related applications that can now be used as a data source. By eliminating the need to develop custom connectors to access these sources, these connectors will help companies streamline their insurance workflows and accelerate their ability to fully assess security risks & compliance. The new connectors are for:
Support for key pair authentication with Snowflake
Qlik Talend Cloud now provides support for key pair authentication when connecting with Snowflake. Using key pair authentication provides enhanced security versus basic authentication, such as username and password. This key pair approach is recommended for workloads such as data loading (replication or landing tasks) and transformations.
New version of Direct Access gateway
The Qlik Data Gateway - Direct Access allows Qlik Sense SaaS applications to securely access behind-the-firewall data, over a strictly outbound, encrypted, and mutually authenticated connection. We just released Direct Access gateway 1.6.8 which, in addition to several bug fixes, introduced the following enhancements:
Updated Connectors
You can analyze visits to your web, views to you instagram profile
You can review impact on your posts.
Marketing people
You can check most visited pages on your web
It’s been an exciting year for Qlik Cloud Reporting. Back in December 2023, we took a big step by adding tabular reporting to our dashboard-style capabilities, something many of you have been asking for. This update comes packed with features like report task management, easy imports of recipient lists from connected data sources, powerful filtering using bookmarks, and simple uploads for tabular report templates. Now, report developers can easily handle centralized tabular reporting tasks right inside Qlik Sense apps. Thanks to our incredible Qlik Cloud customers, we’re gearing up to roll out even more cool features!
We’re putting the finishing touches on our cloud reporting capabilities for Q4:
As BI leaders get ready for Qlik Answers, Qlik AutoML, and Qlik Talend Cloud, we know that having flexibility in report types and control over operations is key for keeping everyone in the loop.
As we launch these new features, we’ll also be focusing on enhancing operational task controls, including email reporting solutions.
Sign up for this webinar on October 17th to explore Qlik Cloud’s Reporting Evolution and get a sneak peek at everything it has to offer!
In recent times, there have been hackathons being organised by colleges on various topics and technologies. Clearly, there is a big interest from students and professors to organize such events. One of the key reason is that the academic community feels that this is a great way to learn and engage the student community.
According to digit.in, there are several benefits of a hackathon and they are as follows:
1. Learning a new technical skill
2. Creating a sense of accomplishment
3. Enhancing your soft skills
4. Beefing up your resume
5. Networking
6. Paving the path for a start up
7. Getting inspired
8. Giving back to the community
9. Winning a prize
10. Having fun
One of Qlik's academic partners, ICT Academy's CEO, Mr V Srikanth, mentioned in a recent article in The Times of India, that Learning based on Hackathon is the way forward.
The Qlik Academic Program has collaborated for three hackathons ( datathons) this year with Anurag Engineering College, Hyderabad, Kristu Jayanti College, Bangalore and the third one coming up with VJIT Hyderabad. There has been a good amount of participation in all these events. Students are more engaged, they are able to present their outcomes and get feedback on their creations from experts.
Overall, this is a win win for everyone and in some cases, prospective employers are able to gauge the skills of students from an event and offer opportunities. This way, hackathons have many benefits and are clearly a great way to engage students and make them industry ready.
For information on the Qlik Academic Program and to find out the resources including training and certifications for students and professors, please visit: qlik.com/academicprogram
お客様の要望に基づき、コンボチャートが改善されました。
選択バーの選択された項目の表示名に、マスターアイテムで指定したラベル名が表示されるようになりました。オートカレンダーの項目などについてもすっきりした項目名で選択バーに表示することができます。
ML展開内のモデルの承認として、アクティブ化・非アクティブ化する機能が追加されました。ML展開を開くと、モデル承認のステータスが表示され、権限があればステータスを変更することができます。管理者は契約による使用可能なモデル数と使用数をみながら承認するモデルの数をコントロールすることができます。
学習データをcsv、qvd、parquet ファイルにエクスポートできるようになりました。ML実験の比較または分析タブから出力できます。
組み込み分析で、ユーザーが選択したUI言語にローカライズされるようになりました。
Direct Access gateway 1.6.8 がリリースされ、下記の機能が導入されました。
データチャンクの復旧メカニズム
欠損または破損したデータチャンクの送信がサポートされました。再読み込みデータチャンクのメモリ使用量を制御するため、設定ファイル(configuration.properties)に新しいプロパティ「RELOAD_CACHE_MEMORY_MB」が追加されています。
.NET 6.0.x が不要に
Direct Access Gateway の実行には .NET 6.0.x が不要になりました。新規導入には、.NET 4.8(インストールに必要)と、.NET 8.0 および ASP.NET Core ランタイム(Direct Access Gateway の使用に必要)をインストールしてください。
依存プロセスのバッチ処理の改善
このバージョンでは、依存プロセスが順次ではなく並行して確認されるようになり、実行時にプロセスリストが変更されることによる例外処理が回避されます。
トラブルシューティングの改善
ログのリソース使用警告に「プロセスID」や「コミットサイズ」など、より多くの情報が追加されました。
プラットフォーム ナビゲーションの変更
新しいプラットフォーム ナビゲーションがすべてのテナントの規定になりました。
シートボタンの削除
[シート] ボタンは表示されなくなりました。代わりに、左側の [アセット] ボタンを使用してください。
新しいピボットテーブルの改善(Visualization bundle)
画像やPDFのダウンロード、ストーリーテリングのスナップショット、レポートのサブスクライブ、ハブのチャート監視に対応しました。
レイアウトコンテナの改善
チャートがプロパティ・パネルのリストで選択されると、コンテナ内でハイライトされるようになりました。
変換タスクのビューで、系列が可視化されるようになりました。
ターゲットを選択して、ソース データセットと、このターゲット データセットを作成した変換を確認します。
変換およびデータ マート タスク用の新しいデータセット モデルであるターゲット ベース モデルを導入します。変換とデータ マート タスクがより自己完結的になり、ソース メタデータの変更の影響を制御できます。
ターゲットベースデータモデルでは、データセット メタデータはソース メタデータの変更から分離され、ターゲット データセットは、ソース データセットから明示的にマッピングされます。
ソースに対して列が追加または削除されても、次のダウンストリーム タスクに自動的に伝達されず、必要に応じてマッピングを調整できるようになります。また、列の順序を変更することや、データ ソースを置換することができます。
既存のプロジェクトは条件に該当する場合は、プロジェクトをはじめて開くときに新しいデータセットモデルに更新されます。
Databricks プラットフォームを利用した変換フローに下記のAIプロセッサーが追加されました。
データ製品とは、同じドメインに関連する信頼できるデータセット、またはビジネスに適した任意のグループを収集してパッケージ化できるエンティティのことです。データ製品を使用するには、Qlik Talend Cloud Enterprise サブスクリプションが必要です。
テーブル再作成の強化
データパイプラインの画面からテーブルの再作成をできるようになりました。テーブルを再作成すると、ダウンストリーム タスクは、ソース データセットで切り捨てとリロードのアクションが実行されたかのように動作します。これまでは、タスクを開いてテーブルを再作成する必要がありました。
複数のテーブルからメタデータを並行して取得するサポート
メタデータを複数のテーブルから問題なく並行して取得できるようになりました。以前はエラーが発生することがありました。
Snowflake のキーペア認証をサポート
キーペア認証は、ユーザー/パスワードよりも堅牢です。この方法は、データロード(レプリケーションまたはランディングタスク)や変換などのワークロードに推奨されます。
Hi Guys - I'd like to introduce you to some use cases, samples and examples of Qlik Sense Chart level scripting courtesy of Qlik Solution Architect, Venkat Subharaman. You can learn more about Venkat at then end of this blog.
Recently we released a new capability in Qlik Sense, that allows you to provide and manipulate data directly within a chart object using script. It allows users to modify the data set behind a chart using a subset of the Qlik scripting language, using techniques such as variables and loops. Rows and columns can be added or modified that were not in the original data set enabling calculations that have previously not been possible in chart expressions or with variables. Offering a new way to analyze your data such as simulations and goal seeking.
Venkat was so excited when he developed a few use cases for Qlik Sense Chart level scripting and worked out a few examples he wanted to share with everyone that might need them. (attached to this post)
Note that official documentation is available on the Qlik Help site and additional examples will be made available so stay tuned.
I'd like to thank Venkat for his valuable contribution. Take it away Venkat!
With Chart level scripting I can create simple data models and write complex logics on a subset of data on the fly. Here are some of the benefits:
I have found it especially useful where working with financial reports when performing the following:
Traditionally I can use out-of-the-box functions like RangeSum and achieve the desired result. BUT, depending on the business use case and the requirements, formulas can get complex very quickly. Even though our we achieved the desired result, it is always at the back of my mind how will it be maintained going forward if something changes.
Chart Level Scripting gives you a simple way of doing complex calculation with the added ease of working with just a small subset of data that is utilized in the chart or table.
Let's take a look at 3 simple examples that will highlight only a small percentage of the power of Chart level scripting.
First I want to just set the stage and familiarize you with some terminology and functions.
Example 1: Running total and percentage calculated at aggregate level
Steps:
Add the division filter and select the required division, you will see that the totals and % will be re calculated and will adapt as per the selections. In the above example we just created running totals and percentage at the total level. Let us look at example 2 where we will do the calculation at the aggregate level as well as at the divisional level.
Example 2: Running total and percentage calculations at the aggregate level and at the divisional level
Steps:
Now the totals will be calculated at the aggregate level and at the Divisional Level.
Please note that I have just written the script in a simple fashion to showcase the functionalities like
Example 3: Aggregated measures and dimensions in a bar graph
Steps:
The above 3 samples are simple uses cases to showcase the power of chart level scripting. Share with me your use cases where you can apply Chart level scripting .
In summary Chart level scripting provides a simpler and compact way of solving specific business problems.
Happy Qliking!!!!!!!!!
Useful References
About Venkat
Venkat is a Solution Architect, currently working with the presales team at Melbourne (Australia), having a broad experience in leading and systematizing BI Initiatives. With 25+ years of experience. Venkat has participated in various development projects & has played a key development role in the Enterprise Level Data warehouse & Business Intelligence Applications. Venkat has a deep interest in research and data analysis, drawing actionable insights from the raw data to help further the business’ goal.
www.linkedin.com/in/venkitasubharaman
Announcing a significant enhancement to Qlik Application Automation with the introduction of the Get Chart Image block in the Qlik Reporting connector. This new feature allows users to generate chart images directly within their automation workflows, streamlining the process of sharing visual insights.
Key Features
Generate Chart Images: Easily create images from your charts without the need for manual screenshots or additional tools.
Distribute Effortlessly: Utilize various connectors within Qlik Application Automation to share these images across multiple platforms, including popular chat tools like Slack and Microsoft Teams.
Embed in Emails: Seamlessly embed chart images into HTML emails, ensuring that your recipients receive immediate visual insights.
Store in Cloud Services: Safeguard your generated images by storing them on cloud storage solutions such as Microsoft SharePoint, Amazon S3 or Dropbox.
This update significantly enhances the reporting process by enabling:
More information on using the block and example automations are available on Qlik Community.
The 2022 Qlik Sense product certifications are now open for registration with the first exam date of December 14, 2022. Register now for the best choice of appointment times!
All 2022 Qlik Sense Beta results, including digital badges for those who have earned a certification, will be released on December 14, 2022.
Go further with Qlik Sense SaaS Endorsements!
Once you earn your 2022 Qlik Sense product certification, you are eligible to sit for associated Qlik Sense SaaS endorsements. These endorsements validate your skills on capabilities specific to the Qlik Sense Cloud/SaaS environment.
Qlik Sense SaaS endorsement registration opens soon
Those who earn a 2022 Qlik Sense product certification are eligible to sit for the associated Qlik Sense SaaS endorsement. The table below outlines the required pre-requisites:
Qlik Sense SaaS Endorsement | Required Pre-requisite Certification |
Qlik Sense SaaS Business Analyst Endorsement- 2022 | Qlik Sense Business Analyst Certification - 2022 |
Qlik Sense SaaS Data Architect Endorsement- 2022 | 2022 Qlik Sense Data Architect Certification - 2022 |
Qlik Sense SaaS Administrator Endorsement- 2022 | 2022 Qlik Sense Business Analyst Certification - 2022 |
Visit our certifications page to register for Qlik Sense certification exams today! Questions? Reach out to certification@qlik.com.
I am always learning new things. When it comes to learning about Qlik Sense, or any software for that matter I am a big proponent of using "something" (scenarios, data and examples) that has interest to me so I can relate to it better. My data and example choice is using video game data, but I digress.
As you may know, I have been working with Qlik Solution Architect @TomiKomo - Tomi Komolafe - to share his stories and examples of “things” he encounters in the field when visiting customers and prospects. (You can see some of his solutions and experiences here.)
Well this time, Tomi wanted to share something fun. Similar to how you have seen me present many aspects of the product using video game or star wars related data, I paused and asked Tomi – “What speaks to you? What are one of your passions?” – he said: “Music, my friends and I love listening to music.” After further discussion – the idea of using Spotify data arose as Tomi and friends had Spotify accounts. BUT this has been done a few times already I am sure, and this time around we didn’t just want to present the data we wanted to show how Qlik Sense analysis in conjunction with the features of the Associative Difference can help solve a particular problem Tomi was having – “What songs or other artists out there am I missing?” 😁 Is it possible that by using Qlik Sense Tomi can correlate data from his own and friend’s Spotify listening habits and find out what songs and artists he may not be listening to? – Watch this awesome video of what he discovered!
Take it away Tomi!
Tomi's Outline
Let's Begin
Have you ever thought to yourself, how come there’s isn’t a Qlik Spotify app that just tells me what songs I should listen to? Well, now, you are at least thinking about it and there is such an app.
I should set up the scene so I don’t come across as some Qlik nut who turns every moment into a “lets see if Qlik can solve it” scenario. Some of my closest friends live in New Jersey (I’m in DC, 4 hrs away) and during the pandemic, I was only able to visit them sparingly. Every so often, we would be grilling in the backyard or working out in our make-shift gym, playing music in the communal ANKER Bluetooth speaker. Some of the songs I heard, I really liked and I would’ve never heard them in my sphere of Spotify influence. Other songs were from artists I love but I hadn’t heard that particular song.
I cornered these 5 friends to get access to their Spotify song history (No friends were hurt in the development of this app). What you will discover are the myriad of ways we can analyze this data to bubble up interesting insights and trends. Fortunately, there’s a rich amount of data in the Spotify API anyone can access.
Here are some of the cool questions I will be answering using this data in this and subsequent videos:
Many more questions also keep bubbling up. What’s pretty cool is how some of the techniques used here can be applied to everyday business decisions. For example, which product should be paired with another product to improve margins based on supplier activity?
You should wait till the end of the video to see another cool surprise. It involves an extension that @joe_warbington , previously at Qlik, created.
Maybe I am a Qlik nut who turns everything into a Let’s see if Qlik can solve this… 😉
Regards,
@TomiKomo
Resources:
Here's an example of something I coded to get all songs so I could play them for example:
Let vRecordNo = NoOfRows('WheneverExposed');
For i = 0 to $(vRecordNo) //this variable set in prior section
LET vSongTitle=Peek('Song Title',$(i),'TmpTable');
LET vReleaseYear=Peek('Release Year',$(i),'TmpTable');
SET vTrackName = "track:$(vSongTitle) year:$(vReleaseYear)";
Endpoints Used - Spotify REST API
I was approached by a colleague with a simple but recurrent question, how can I use for…while loops in conjunction with the REST connector, and how can we make it work with the connection library that comes with Qlik Sense.
A few months ago I shared a “hack” so we can do loops in our scripts as we do with QlikView, activating Legacy Mode will make connection library optional, please remember that there are a bunch of good reasons for not do that. “With connection” is a great solution for those of you who don’t want or just can’t activate Qlik Sense Desktop to work in Legacy Mode but still need to loop through several URLs to get complete data.
Let’s do a quick example.
We need to load data from an online data source, we have a URL to connect to the data that contains the ID of each one of the elements that we would like to load into our app.
https://www.domain.com/element?key=elementID/more_stuff
We have a list of 100 alphanumeric elementIDs and we need to make sure we load them all. Using our REST connector, we could easily connect to the online data source and extract the data, but we faced the issue of how to make to connection loop trough a series of items.
In our example we have an inline table that contains each one of the ID numbers of the elements we want to read in the REST connector, and we need to pass that parameter to the connection URL below.
LIB CONNECT TO 'REST'; ElementsToLoad: Load * inline [ ElementID 12fa91 1sy293 h13d13 … ];
Let j=0; for j = 0 to 99 Let vElementID = peek('ElementID', $(j), 'Teams'); RestConnectorMasterTable: SQL SELECT fields FROM "datad") FROM JSON (wrap on) "root" PK "__KEY_root" WITH CONNECTION(Url "https://www.domain.com/element?key=$(vElementID)/more_stuff/"); NEXT j; DROP TABLE RestConnectorMasterTable; exit Script;
After the inline statement, we loop over the REST connection 100 times, one time for each row of the inline table, I know we have 100 rows so I'm hard coding that number but if you don't know how long your table is you should check that before and store it in a variable.
Lately, using "With Connection" we have access to the data source URL so we can expand my variable "vElementID" containing the necessary ID for the connection to work.
More info about "With Connection" here -> https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/Load-REST-data/Load-data.htm#WITH-CONNECTION-keyword
Arturo @arturoqv
I wish you all a great end of the year and a very successful 2019.
We’re super excited to tell you about our new course: Predictive Analytics with Qlik AutoML! This course will take you into the amazing world of Machine Learning, and guess what? You won’t need to write any code! Can you imagine doing predictive analysis without being a Data Scientist? This is the revolution you’ve been waiting for!
And if you’re already a Data Scientist, don’t worry, this course is for you too. It will help you automate your work, so you can focus on what matters most and save time.
In just one day, you will be able to:
Our first session is scheduled for November 13 and it comes with some fun surprises that we’ll reveal over time! Register this week to get 30% off (use code CLASSROOM30 at checkout)
But hurry, only the first 10 people to sign up for the first course will get these exclusive bonuses.- Don’t miss out!
And this is just the beginning! Next week, we’ll reveal the second bonus, and the week after that, the third bonus. The surprises keep coming!
Book your seat now! before all the spots with bonuses are gone.
Happy Learning!
Hello Qlik Admins and Developers,
The next major Qlik Sense Enterprise on Windows release is scheduled for November 2024. The update will introduce changes that will have an impact on the following add-ons:
The changes affecting the add-ons are:
New versions of all affected add-ons will be available with the November 2024 release, and the associated Release Notes will provide detailed information on any improvements and changes.
Please plan your upgrade accordingly to prevent interruptions:
If you upgrade to Qlik Sense Enterprise on Windows November 2024, all listed add-ons must be upgraded as well. If you only plan to upgrade the add-ons, Qlik Sense Enterprise on Windows does not need to be upgraded.
Thank you for choosing Qlik,
Qlik Support
If you’ve came across the initial Qlik Cloud Wordpress plugin on the Qlik Community Design blog and gave it a try, you probably have run into some issues with it. Today, I’m going to share a new updated version of the Qlik Cloud WordPress plugin that brings a more efficient way to embed Qlik Cloud analytics into your WordPress websites.
In this post, I'll walk you through the steps to install, configure, and use the new version of the plugin to bring your Qlik Cloud visualizations directly into your WP pages and posts.
The previous version of our plugin relied on JWT tokens for auth, iframes (single integration API) and nebula.js for embedding, which worked but had limitations such as third-party cookies. Qlik Embed is the new embedding library and adopts better auth flows. In this version, I'm using OAuth impersonation to generate access token on the backend without need for users to interact with a login page.
Note: If you have the previous version installed, deactivate and delete it before installing the new one to avoid conflicts.
Before using the plugin, you'll need to set up OAuth impersonation in your Qlik Cloud tenant.
Docs here: https://qlik.dev/authenticate/oauth/create/create-oauth-client-m2m-impersonation/
Make sure to read through the Guiding Principles of OAuth Impersonation: https://qlik.dev/authenticate/oauth/guiding-principles-oauth-impersonation
P.S: this method will create a number of anonymous users on your tenant and you need to implement a way to remove these users periodically (using a Qlik Application Automation / users API)
https://your-tenant.region.qlikcloud.com
.
With the plugin configured, you can now embed Qlik Cloud content using Shortcodes.
Use the [qlik-embed-app]
shortcode:
[qlik-embed-app appid="1234-c56a-4062-ac50-377bba443e85" sheetid="12345-698f-449f-9a17-dca17eeadb71"]
Parameters:
Use the [qlik-embed-object]
shortcode:
[qlik-embed-object appid="1234-64317-8432" objectid="1234-5553-326432"]
Parameters:
Use the [qlik-embed-selections]
shortcode:
[qlik-embed-selections appid="1234-c56a-4062-ac50-377bba443e85"]
Parameters:
Tip:
/sheet/
You can download the plugin here: https://github.com/qlik-demo-team/wp-qlik-saas-plugin
P.S: this plugin is maintained by myself. If you find any bugs or issues, please report them to me or create an issue on Github and I'll do my best to resolve them quickly.
Thank you!
Hello all,
This has been resolved as of 13:00 Central European Time, 2nd of October. Should you still experience issues, please do not hesitate to use our Chat and we'll be right with you. Thank you for your patience.
Due to a degradation in Salesforce service performance, users are currently unable to log in to the Qlik Customer Portal.
While we work on resolving the issue for you, please continue using our Chat to remain in contact with us.
Thank you for choosing Qlik,
Qilk Support
In this blog post, I will revisit a topic that I blogged about over a decade ago, the use of a silent legend. By default, a legend is created in a visualization when there are multiple dimensions and/or measures. The legend helps the user understand the visualization. Legends are helpful and without them, users may not comprehend the data in a visualization. But what do you do if have many visualizations on a sheet? Do you need a legend for each chart? Let’s look at the various ways a legend can be used and how a silent legend can reduce the clutter and give a sheet a cleaner look.
In the screen shot below, there are four visualizations at the bottom of the sheet with legends.
In this app, the legends are all the same because the visualizations are using the same asset class dimension. In this example, the legend does not need to be displayed for each visualization because it is redundant. Let’s see how this sheet will look if only one of the legends are kept on the sheet. A legend can easily be removed by toggling off Show Legend in the properties of the chart.
Here is what the sheet looks like with just one legend.
The sheet looks better with one legend versus four legends. This use of one legend for four charts, has decluttered the sheet and reduced repetitiveness. If a developer wants a legend to be displayed without expanding the chart, they need to ensure the visualization is large enough. Without the legends in the three stacked bar charts, less space is needed for the charts, thus they can be made smaller, if desired, to take up less space on the sheet. Since all the visualizations at the bottom of the sheet are using the same legend, the legend was placed with the first visualization, assuming a user is reading top to bottom, left to right.
Now, the beauty of a silent legend is that all visualization legends can be removed from a sheet. In the screenshot below, the four headings at the top of the sheet are colored based on the asset class they represent. So, Equity is green, Fixed Income is dark blue and so on.
This is an example of silent legend. The legend is implied by the asset class headings. This option looks even better and cleaner than the sheet with one legend.
The use of a silent legend is possible in this app because there are only four values for asset class. I have seen this work nicely with up to six values. Anything more may become too cumbersome and may require a legend to be used. Also, if the four visualizations at the bottom of the sheet used different dimensions, then multiple legends should be used. Legends are important and they should not be removed to add space if the chart is unreadable without it. What good is a pretty chart if you do not understand it.
Thanks,
Jennell