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
-
Creating a Collapsible Filter Panel
In my last blog / video. I showed you how to easily create visual buttons to apply selections and change their visual selection state so they can appe... Show MoreIn my last blog / video. I showed you how to easily create visual buttons to apply selections and change their visual selection state so they can appear enabled or disabled (selected, not-selected). In this video I'll show you how to setup a filter panel using buttons and the layout container to create a simple collapsible filter panel that is both esthetic and functional while also providing real estate for your dashboard objects.
Resources:
- Sample attached
- More Tips and Tricks
-
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. -
Updates to Qlik Cloud Security Roles
On April 16th, 2024, Qlik is launching a highly anticipated capability: custom security roles. What do custom security roles do? Custom security roles... Show MoreOn April 16th, 2024, Qlik is launching a highly anticipated capability: custom security roles.
What do custom security roles do?
Custom security roles introduce fine control of data export and access permissions within Qlik apps. This allows you to tailor permissions to your specific needs, enhancing data security and compliance.
The first delivery on April 16th includes the capability to control who can export content. Additional capabilities will be added soon after, such as who can create data connections, reports, and similar.
What does this mean for me?
As part of this update, the existing "has restricted view" space role will gain the ability to export data to Excel. This adjustment is in line with Qlik's capacity-based pricing model, ensuring basic users have essential tools.
If you do not wish for users with the "has restricted view" space role to be able to export data, you will need to create a custom role on the release date to maintain the desired restrictions.
Stay tuned for more information and resources leading up to the April 16th launch. We are excited about these enhancements and the value they will bring to your data management and security efforts within Qlik.
Thank you for choosing Qlik,
Qlik Support -
Button + Reload Data or Button + Execute App Automation - which do I use?
When creating Qlik Sense Apps - you can use a Button object and configure a variety of actions or navigation settings to it. One of those actions is ... Show MoreWhen creating Qlik Sense Apps - you can use a Button object and configure a variety of actions or navigation settings to it. One of those actions is the ability to Reload Data for the app you are in. This comes in handy during development, but also can be used where users require new data on demand.
However, when using the Reload Data action - other users may not be able to perform the reload action as they don't have ownership of the app or reload rights to the app / space the app is developed in. Here is an approach when using Qlik Cloud and Qlik Application Automation that can workaround that. This approach will also work for any App Automation that you want any user to execute.
-
New Set Analysis syntax
Set analysis is a way to define an aggregation scope different from current selection. Think of it as a way to define a conditional aggregation. The c... Show MoreSet analysis is a way to define an aggregation scope different from current selection. Think of it as a way to define a conditional aggregation. The condition – or filter – is written inside the aggregation function. For example, the following will sum the amounts pertaining to 2021:
Sum({<Year={2021}>} Amount)
This syntax however has a couple of drawbacks: First, it is not easy to combine a master measure with different set expressions, since the set expression is hard-coded inside the master measure. Secondly, if you have an expression with multiple aggregations, you need to write the same set expression in every aggregation function.
Therefore, we introduce an additional position for set expressions: They can now be written outside the aggregation function and will then affect all subsequent aggregations. This means that the below expression is allowed:
{<Year={2021}>} Sum(Amount) / Count(distinct Customer)
For master measures, this change will allow a very powerful re-usability: You can now add set expressions to tweak existing master measures:
{<Year={2021}>} [Master Measure]
Lexical scoping
The outer set expression will affect the entire expression, unless it is enclosed in round brackets. If so, the brackets define the lexical scope. For example, in the following expression, the set expression will only affect the aggregations inside the brackets - the Avg() call will not be affected.
( {<Year={2021}>} Sum(Amount) / Count(distinct Customer) ) – Avg(CustomerSales)
Position
The set expression must be placed in the beginning of the lexical scope.
Context and inheritance
Aggregation functions that lack set expression, will inherit the context from the outside: In earlier versions the context was always defined by the current selection. Now we have added the possibility of having the context defined by a set expression. So, now “context” means current selection or an outer set expression.
Inner set expression
If an aggregation function already contains a set expression, this will be merged with the context. The same merging rules as today will apply:
- An inner set expression with a set identifier will NOT inherit from the context. It will inherit the selection from the set identifier instead.
- An inner set expression that lacks set identifier – it has only a set modifier – will inherit from the context.
- How the merge is made depends on the set assignment for the field; whether it is made with an equals sign “=” or with an implicit set operator, e.g. “+=”. The logic is identical to how current selection is merged with a set expression.
Examples:
{<OuterSet>} Sum( {<InnerSet>} Field )
The OuterSet will be inherited into the InnerSet, since the inner set lacks set identifier.{<OuterSet>} Sum( {$<InnerSet>} Field )
The OuterSet will not be inherited into the InnerSet, since the inner set expression contains a set identifier.Aggr()
The set expression of the outer aggregation will never be inherited into the inner aggregation. But a set expression outside the outer aggregation will be inherited into both.
Examples:
Sum({<Set1>} Aggr(Count({<Set2>} Field )))
The Set1 will not be inherited into Set2.{<OuterSet>} Sum({<Set1>} Aggr(Count({<Set2>} Field )))
The OuterSet will be inherited into both Set1 and Set2.Summary
Nothing changes for existing set expressions – they will continue to work. But with this additional syntax we hope to simplify your work and your expressions and allow you to re-use your master measures more effectively.
This change affects all Qlik Sense editions from the August 2022 release. It will also be included in the next major QlikView release, planned for late spring 2023.
See more on
https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344HIC
-
Entitlement Analyzer for Qlik Sense Enterprise SaaS (Cloud only)
We are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! This application will enable you to answer questions like:... Show MoreWe are happy to share with you the new Entitlement Analyzer for Qlik Sense Enterprise SaaS! This application will enable you to answer questions like:
- How can I track the usage of my Tenant over time? How are my entitled users using the Tenant?
- How can I better understand the usage of Analyzer Capacity vs. Analyzer & Professional Entitlements?
The Entitlement Analyzer app provides insights on:
- Entitlement usage overview across the Tenant
- Analyzer Capacity – Detailed usage data and a predication if you have enough
- How users are using the system and if they have the right Entitlement assigned to them
- Which Apps are used the most by using the NEW "App consumption overview" sheet
- And much more!
The Entitlement Analyzer uses a new API Endpoint to fetch all the required data and will store the history in QVD files to enable even better Analytics over time.
A few things to note:
- This app is provided as-is and is not supported by Qlik Support.
- It is recommended to always use the latest app.
- Information is not collected by Qlik when using this app.
The app as well as the configuration guide are available via GitHub, linked below.
- QVF: https://github.com/qlik-oss/qlik-cloud-entitlement-analyzer/releases/latest/download/entitlement-analyzer.qvf
- Release Notes: https://github.com/qlik-oss/qlik-cloud-entitlement-analyzer/releases/latest
- Installation Guide: https://github.com/qlik-oss/qlik-cloud-monitoring-apps/releases/latest/download/qlik-cloud-monitorin...
Any issues, questions, and enhancement requests should be opened on the Issues page within the app’s GitHub repository.
Be sure to subscribe to the Qlik Support Updates Blog by clicking the green Subscribe button to stay up to date with the latest Qlik Support announcements. Please give this post a like if you found it helpful!
Kind regards,
Qlik Platform Architects
Additional Resources:
Our other monitoring apps for Qlik Cloud can be found below.
- App Analyzer
- Reload Analyzer
- Access Evaluator
- OEM Dashboard (for OEM Partners and multi-cloud tenants)
-
Welcome back Javier Leon - Qlik Educator Ambassador for 2024!
Since we last spoke to Javier for our Academic Program blog he has successfully completed his PHD in data science and is now teaching at 5 universitie... Show MoreSince we last spoke to Javier for our Academic Program blog he has successfully completed his PHD in data science and is now teaching at 5 universities! Javier is an adjunct professor at Saint Joseph's University, Villanova University, Drexel University, Rowan University and Southern New Hampshire University.
In 2024, Javier aims to leverage his knowledge in data science, business intelligence, analytics, and data visualization to enhance students' professional competencies and readiness. One of his aims as an educator is to bridge the gap between theoretical knowledge and practical application, so that students develop the necessary skills to excel in the data driven business landscape. He is already putting this into practice in his Data visualization class at Drexel University:
“In that class I am having students create projects that leverage the capabilities of Qlik…..My teaching is currently focusing on practical, hands-on projects that mirror real-world business challenges, encouraging students to apply Qlik's powerful analytics and visualization features to derive actionable insights. In one of the projects, the students must identify relevant data sets to tell a story about a movie that they like. To do this, they must ensure that the data they find meets the criteria for quality data. Next, they must tell a story about the movie: how much it grossed, how it performed versus movies in the same year, in the same genre, etc.”
One of Javers significant achievement from the past year has been his role in the creation of an Academy called Bright Future Schools of Professional Development, “we have an entire course dedicated to Qlik’s Essentials. The idea is to help students understand the basics of data visualization with a user-friendly software that will enable them to grow professionally.”
Javier believes that I the most important thing happening on at the moment is the AI revolution, “I think it will significantly reshape the landscape of analytics and higher education. …AI technologies like machine learning and deep learning are augmenting human capabilities by automating routine tasks, providing insights from large datasets, and enhancing decision-making with predictive analytics. And what is most important, we are barely scratching the surface of AI capabilities. We can augment ourselves as professors, students, and professionals with the use of AI.”
Javier believes that AI may revolutionize the way educators teach and students learn, “For instance, AI can personalize learning experiences, adapt to individual learning paces, and provide real-time feedback, thereby enhancing student engagement and outcomes. The demand in higher education is shifting towards graduates who are not only proficient in analytics but also in the application of AI and its subset, machine learning, within analytics.”
Javier decided to apply for his fourth year as an educator ambassador because of the knowledge sharing and networking that the program offers, “It is a great way to be surrounded by excellent professionals who are dedicated and passionate about teaching and helping students achieve their academic and professional goals. Also, to be recognized by Qlik, a leading company in BI, offers credibility in an ever-changing and competitive industry. This in turn, can be used to reach more students and help them in their data literacy journey. Aside from all that, I believe in Qlik’s Mission of getting the most value out of data by revealing hidden patterns and addressing today and tomorrow’s complex challenges in the industry.”
To learn more about the Academic Program go to qlik.com/academicprogram.
-
Traffic Accidents in Brazil
Traffic Accidents in Brazil Hyperscale This dashboard was developed with the aim of studying the new layout Container and design possibilities i... Show MoreTraffic Accidents in BrazilHyperscale
This dashboard was developed with the aim of studying the new layout Container and design possibilities it offers. The data used originated from a survey of accidents on federal highways in Brazil.
Discoveries
Types of accidents most common on Brazilian highways, which highways are the most dangerous and require an action plan to reduce accidents, the times and days with the highest occurrence of accidents.
Impact
Mapping the most dangerous highways for a future action plan to reduce accidents, monitoring the most critical times on the roads.
Audience
Traffic enforcement agencies, municipalities, and states
Data and advanced analytics
Ease of visibility of Brazilian highways and comparison between states and highways.
-
Qlik Analytics connectors: Twitter connector to be updated
Update April 18th 2024: As of April 2024, the Twitter Connector will be permanently removed from Qlik Sense SaaS. The removal from Qlik Sense client-m... Show MoreUpdate April 18th 2024: As of April 2024, the Twitter Connector will be permanently removed from Qlik Sense SaaS. The removal from Qlik Sense client-managed is scheduled for the August 2024 release, and the removal from the standalone Qlik Web Connector is targeted for fall 2024.
There are currently no plans to introduce a new Twitter Connector, although this was previously the intention.Twitter has changed the structure for the available API access levels and removed broader access to analytics via Twitter API v1.1. Due to this change, the Qlik Sense connector for Twitter has recently stopped working. The Twitter API v2 is now required, but the current Qlik connector only supports API v1.1.
Additionally, Qlik has managed a common Twitter App for all users’ authentications, which with this change can no longer be used to support the requests made via the connector.
Qlik will introduce a new connector against the Twitter API v2. This new connector will support customer-managed Twitter Apps, allowing you to acquire the API access level specific to your needs and access the analytics data with your own account. Consequently, there will be no API access provided by Qlik.
Unfortunately, this means that the current connector for Twitter will be deprecated, and it will be removed from Qlik Cloud Analytics. It will also be removed from Qlik Sense Enterprise on Windows in the August 2023 release and the standalone Qlik Web Connectors package in December 2023.
You can find detailed information about the Twitter access levels and versions in the Getting started page in the Twitter developer portal. There is also a Step-by-step guide to making your first request to the new Twitter API v2, which explains how to manage and create a Project and connect an App within your Twitter account.
Thanks for choosing Qlik!
Qlik Global Support -
Welcome back Angelika Klidas - Qlik Educator Ambassador Class of 2024!
This week we would like to introduce Angelika Klidas, who happens to be a returning Educator Ambassador. We are excited to select Angelika as an Amba... Show MoreThis week we would like to introduce Angelika Klidas, who happens to be a returning Educator Ambassador. We are excited to select Angelika as an Ambassador for the 3rd year in a row due to her continued enthusiasm for Qlik’s Academic Program and her efforts in 2023.
Angelika’s journey with Qlik began in 2008 when she started out installing and managing a successful QlikView Competence Center as a team manager of the team for a Governmental Organization in the Netherlands. Since then, she has always been a huge Qlik Advocate in both her day job and her university teaching. Angelika works currently as an Advisor & Trainer and the Business Data Challengers and is responsible for the BDC Academy, sales and account management along with some innovative work! She also teaches Data and Analytics at the University of Applied Sciences in Amsterdam which is her part time role. She is a conceptual thinker who lives by the phrase “think big, act small, and scale fast” which she uses to inspire others to evolve in their use of data and analytics.
In 2022, Angelika began writing a book together with Qlik’s Chief Learning Officer Kevin Hanegan about Data Literacy. The book was formally launched on the 30th of November 2022 and is called “Data Literacy in Practice”. The book is available through Amazon.com and Packt.com.
Angelika applied to become a Educator Ambassador with the Qlik Academic Program as she is passionate about educating students in data analytics and championing the cause of Data & AI Literacy. Due to the change in situation in the field of education, she included new aspects in her teaching style which include setting up training materials “how to use Qlik Sense from an analysis perspective so that students know and understand the full power of Qlik Sense, using AHA Slides (to make the lectures more interactive) and the book “Data Literacy in Practice”. Her book is now also a mandatory book for the University. With the help of the techniques from the book and learning to work with Qlik Sense helps her students not only to analyze the data in a better manner but also how to help organizations form a data strategy, develop organizational KPI’s and build amazing dashboards & reports.
Angelika is proud of the fact that she is the Qlik Academic Program Ambassador and has included the Educator Ambassador badge, mentioned it on her resume and highlights it in her presentations! This year again she is presenting twice at Qlik Connect and is also a Panelist for around the topic ethical handling of data.
In Angelika’s words, “I love the power of grey, love the academic program and the great benefit that it gives to me and my students. My students can pursue their dreams when they would like to work in data and analytics .” She is excited about the fact that some of her students got a job in the data and analytics world, which is amazing! An interesting fact is that since 2008, 34% of her 295 students are working in the field of data and analytics. Her main goal for 2024 is to work on new training materials for Data & AI Literacy in Dutch and English. Angelika has developed several Generative AI trainings that help people (at school and in her commercial work field) to use the Gen AI tools, but also she trains them to question the outcome. Questioning the results, either from insights that we create or the results that we get from the Gen AI tools we use is mega important. Next to that Angelika has developed a “Serious Data Training” where she combines a the first basic concepts of Data & AI Literacy, a Data Escape Room and a session of reflecting on the soft skills that people need during the process of data informed decisions.
Angelika feels that more and more organizations are now emphasizing the importance of Data & AI Literacy. She loves to work with the four pillar system which should be the basis of every organizations journey towards “Active Intelligence” so they will be future ready!
In Angelika’s words, “I love the Qlik Academic Program, it helps the students in gaining analytics knowledge for my students. They can learn at their own pace and look for solutions through the learning platform, but also use the knowledge from the community and demos.qlik.com where they can find all kinds of cool solutions”
We are looking forward to working closely with Angelika during her tenure as an ambassador yet again and creating more links with Universities in the Netherlands.
For more information about our Ambassador Program, please visit: qlik.com/us/company/academic-program/ambassadors
-
The new Qlik Google Analytics 4 (GA4) Connector
Google's Universal Analytics will stop processing new hits on July 1st 2023 and makes room for Google Analytics 4. Continue loading your data using Ql... Show MoreGoogle's Universal Analytics will stop processing new hits on July 1st 2023 and makes room for Google Analytics 4.
Continue loading your data using Qlik's new GA4 connector, available for Qlik Cloud and Qlik Sense Enterprise on Windows as of today: Google Analytics 4 (Cloud) | Google Analytics 4 (on-premise)
The new Google Analytics 4 connector is also included in the Qlik Web Connector Standalone package: Google Analytics 4 (standalone)
Related Content and Relevant Sources:
[GA4] Introducing the next generation of Analytics, Google Analytics 4 | support.google
Prepare for the future with Google Analytics 4 | blog.google -
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!
-
Join Us Live! Q&A with Qlik: Qlik Sense Enterprise Migration
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. REGIS... 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
-
New Helpful Features
In this blog post, I will cover four Qlik Cloud features that you may not be aware of, but I find to be useful. They are: New navigation option for b... Show MoreIn this blog post, I will cover four Qlik Cloud features that you may not be aware of, but I find to be useful. They are:
- New navigation option for buttons.
- The ability to change the opacity of a background color.
- The ability to add links to straight and pivot tables.
- Placement of sheet navigation buttons with hidden sheet header.
The first feature is the option to navigate to a specific chart using button actions and navigation. We have always had the ability to navigate to a specified sheet but now, we can select a chart to highlight. In the Sales Analysis sheet below, there is a View Sales Details button on the bottom left that is used to navigate the user to the Details sheet and highlight the Sales Details table.
To implement this, the actions and navigation properties of the button need to be set to the Details sheet and the chart ID for the Details table, as seen below.
The Chart ID drop down will show all the IDs for charts on the selected sheet. (In this case, the Details sheet). To ensure you are selecting the correct chart, you can check or copy the chart ID by right clicking on the chart, clicking on …, selecting Share from the menu, then selecting Embed from the menu. These steps are illustrated below.
The Embed dialog window below will open and beneath the chart is its object ID. You can copy the object ID and paste it in the properties window for the button or note it and select it from the chart ID drop down list.
In this example, I used the “go to chart” to navigate between sheets but it can also be used on a single sheet. Now, when the user clicks on the View Sales Details button, they are navigated to the Details sheet and the Sales Details table, at the top of the sheet, is highlighted. Notice the blue colored box around it.
The second new feature is the ability to change the opacity of the background color. In the chart below, I have added a background color in the styling properties of the chart. After I select a color for the background, I can use the slider to adjust the opacity, if I choose. In this example, I set it to 60%. By default, it will set to 100% opacity.
The third new feature is the ability to add links to straight tables and pivot tables. Both tables are found in the Visualization bundle.
To add the link is easy. In the properties of the column (see image below), the Field should be the URL you would like for the link. In this example, the link is hard-coded, but you can also use a field value or expression to generate the link. The key to this working is setting Representation to Link (versus Text, which is the default).
The fourth, and last, new feature that I am going to cover in this blog is the new placement of the sheet navigation arrows when the sheet header is hidden. In a previous blog, I discussed how to toggle the sheet header and sheet toolbar. The sheet navigation arrows are in the sheet header as seen below and in the past when the sheet header was hidden, the navigation arrows were not available.
Now, when the sheet header is hidden, the sheet navigation arrows are moved up to the sheet toolbar. A small change, but quite helpful.
Now if you opt to hide the sheet toolbar as well, you may want to consider adding navigation to your sheet.
To wrap it up, this blog covers some small new features that you may find helpful. Users can now navigate to a visualization via button actions, the styling properties have been improved with the ability to set the opacity for a background color, URL links are available in straight and pivot tables and sheet navigation has become a little more flexible. Check out these new features next time you are developing an app.
Thanks,
Jennell
-
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
-
Social networks analysis
Social networks analysisActium DigitalThis application is used Instagram, Twitter and Google analytics. Folowers, posts and visits.DiscoveriesYou can ... Show MoreSocial networks analysisActium DigitalThis application is used Instagram, Twitter and Google analytics. Folowers, posts and visits.Discoveries
You can analyze visits to your web, views to you instagram profile
Impact
You can review impact on your posts.
Audience
Marketing people
Data and advanced analytics
You can check most visited pages on your web
-
Reporting Service Packaging Changes
Qlik Cloud Reporting packaging changes are here! We’ll be replacing the multiple tiers with simple ‘Small and Large Add-On Packs’, alongside standardi... Show MoreQlik Cloud Reporting packaging changes are here!
We’ll be replacing the multiple tiers with simple ‘Small and Large Add-On Packs’, alongside standardized limits for easier management.
Our new Standard, Premium and Enterprise customers using our Capacity Model, will have reporting entitlements included in their package. Customers on our User Based Model will have 1000 reports included and available to them.
All customers can purchase our add-on packages when needed.
See structure below:
Key: QSE = Qlik Sense Enterprise / QCA = Qlik Cloud Analytics
Items to Note:- Depending on your product package, you will be automatically placed in the standardized limits above. Those who already have paid tiers will continue-on their current tier until their contract ends.
- If you’re expecting to exceed your standard limit, be sure to contact sales to purchase our add-on packages to prevent future overages.
Additional Resources:Reporting Services | Product Innovation Blog
Reporting from Qlik Cloud Analytics | Qlik Help Page
Tabular Reporting Corporate Blog -
Techspert Talks - Migrating Qlik Sense Client-Managed
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.
The Techspert Talks session from April looked at Migrating Qlik Sense Client-Managed.
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:
- Demo of migration process
- Back-up Best Practices
- Troubleshooting Certificates
Click on this link to see the presentation.
-
Qlik Cloud ３月の新機能
分析の新機能 管理スペースでの表形式レポート 管理スペースで公開されたアプリケーションに対して、表形式レポートタスクを開発・設定できるようになりました。Microsoft Excel用のQlikアドインは、管理スペース内のアプリケーションに接続できるようになっています。 テンプレートはアプリの公開... Show More分析の新機能
管理スペースでの表形式レポート
管理スペースで公開されたアプリケーションに対して、表形式レポートタスクを開発・設定できるようになりました。Microsoft Excel用のQlikアドインは、管理スペース内のアプリケーションに接続できるようになっています。
- テンプレートはアプリの公開前でも公開後でも開発可能です。公開前に作成した場合は、公開後にアドインの接続アプリを変更してください。
- 配布リストは公開前にアプリに追加する必要があります。配布リストの更新にスペースを考慮したスクリプト構文を使用してください。
- レポーティングタスクの他のすべてのタスク要素は、管理スペースで作成できます。
シートナビゲーションの位置変更
アプリの「シートヘッダーを表示」をオフにした場合の、シートナビゲーションの位置が変更になりました。
その他
- 階層構造の Parquet ファイルのStoreにフォーマット指定子が追加されました。[Delimiter is] 指定子を使用すると、単一テーブルをネスト モードで保存することもできます。
- AutoMLの実験に使用したデータセットをカタログから変更、更新できるようになりました。
- データ接続 API が更新されました。すべての分析データソースに対する直接接続、ゲートウェイー直接アクセス経由の接続をサポートします。
- アプリの自動化において、Triggered と Webhook のフローは最大１４日間キューに保存され、実行されない場合はキューから削除されて、ステータスは失敗となります。
データ統合の新機能
様々な機能強化
これらの機能強化を利用するためには、Qlik Data Gateway - Data Movement 2023.11.4 以降が必要です。
- Red Hat 9.xへのデータ移動ゲートウェイのインストールをサポート
- データ移動ゲートウェイのサービスの停止、開始、ステータスチェックのコマンドの変更
- Amazon Redshift で VARCHAR(1) にマッピングされていたBOOLEANのデータ型は BOOLEAN に、BYTES、BLOBのデータ型は VARBINARY にマッピングするよう変更
- 新しくサポートするデータベース、データベースバージョン、ドライバーバージョン
- データソース
- Azure Database for MySQL - フレキシブル サーバー (MySQL ソースコネクタ経由)
- MariaDB 10.4 - 10.11 (以前は 10.4 and 10.5)
- ターゲット
- Azure Database for MySQL -フレキシブル サーバー (MySQL source connector 経由)
- Databricks: Databricks 13.3 LTS 、 Serverless SQL Warehouse
- SAP HANAドライバのバージョン
- Red Hat Linux 9.xにData 移動ゲートウェイをインストールしたいSAP HANAソースを持つお客様は、SAP HANA ODBC 64-bit Driverバージョン2.0.19以降をインストールする必要があります。
- 下記のデータソースはサポートを終了します。
- Oracle 11.x
- SAP HANA 1.0
- データソース
物理オブジェクトとデータプレビュー
データ統合で、データセットを構成する基礎となる物理オブジェクトを表示することができるようになりました。また、物理オブジェクトのデータサンプルもみることができるようになりました。フィルタリングで表示範囲を絞ることもできます。SQL変換の結果を直接プレビューすることもできます。
あらかじめ、管理コンソールの「機能コントロール」＞「データ統合でデータを表示」をオンにする必要があります。またデータ接続のあるスペースに対して「Can view data」権限が、データプロジェクトがあるスペースに対して「Can view」権限が必要です。
DDL プロパゲーションのサポート
レプリケーション・プロジェクトを設定する際に、ソース・システムで発生した DDL 操作をターゲット・システムと自動的に同期するようにタスクを設定できるようになりました。ターゲットテーブルへのDDL変更の適用は、以下のようなイベントに対して有効にすることができます。
- 新しいカラムの追加または既存のカラムの変更
- テーブル選択用のワイルドカードパターンに基づく新しいテーブルの追加
接続作成インターフェイスの改善
すべてのコネクターを1つの共通インターフェイスに統合しました。ソース、ターゲット、アプリケーションに関係なく、ユーザーは同様の合理化されたインタラクションを利用できます。全てのコネクタの表示と、最近使用されたコネクタの表示を切り替えることができます。
SaaS アプリケーション接続の追加
下記の接続が追加されています。
- ADP
- Enverus OpenInvoice
- Google AdMob
- Google AdSense
- Google Business Profile
- Google Play
- Google Workspace
- Infor Data Lake
- PagerDuty
- SAP Employee Central Payroll
- RingCentral
- TikTok
- UKG Pro Workforce Management (formerly Dimensions)
管理者向けの新機能
ゲートウェイー直接アクセス 新バージョン
Direct Access gateway 1.6.4 がリリースされました。
新機能
- 管理コンソールのQMCのデータゲートウェイのタブで「ログの表示」でログを表示またはダウンロードできます。
- 直接アクセスゲートウェイのサイレントインストール
- セッションの継続性の向上
解決された問題
- configuration.propertiesファイルのパラメーター名の誤り
- リロード・ポッドの可用性
その他
- スペースの新しい権限 Can Operate が追加されました。管理スペースでリロードスケジュールを設定することができます。
- ゲートウェイの新バージョンの通知を受け取ることができるようになりました。
- キャパシティ消費量確認アプリが更新されています。
- OAuth machine-to-machine トークンに admin.apps scopeを割り当てている管理者は、API を使用して Qlik Cloud アプリケーションのすべてのメタデータを管理できます。
- OAuthのインパーソネーショントークンによって、OAuthクライアントが登録されているテナント内のユーザーの代わりに、Webアプリケーションがアクセストークンを作成することができます。
