Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
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.
Hello Qlik Community!
Happy Earth, Wind & Fire Day! Has anyone else been singing “September” all month long?
Here are the September enhancements for Qlik Community:
Find inspiration with the Qlik Gallery
Walk through the Qlik Gallery to find inspiration! Enjoy our new 'gallery view' to get ideas and see what your fellow Qlik users are creating!
Chart your path with the Qlik Greenway
Want to be more involved in the Qlik ecosystem? Use the Greenway as your step-by-step guide to an epic journey at Qlik.
Earn Qlik Nation points
Are you a Qlik Nation member? You can now complete challenges within Qlik Community! Look for the challenge carousel on the Homepage, below the Featured Member.
Filter the Leaderboard
It’s now easier than ever to find out the leaders for daily. Weekly, All-Time and more! Use the green filter on the Leaderboard to adjust the time period.
Simplified Release Notes filters
We’ve removed the “version” filter since most release notes are for a monthly release or aggregate the initial release and patches for a specific version into one post.
Fixed issue with Table of Contents
There was an issue with the table of contents jumping under the sticky nav. Now when clicking on a TOC link, the page will jump and the header will be just below the navigation.
Let us know what you think in the comments below! And don’t forget to make the 21st night of September a night you remember 😊
Your Qlik Community Admins,
Melissa, Sue, Jamie, and Nicole
Transformational. 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?
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!
Introducing Qlik Staige
Confidently embrace the power of AI with an all-encompassing solution that brings better insights to your business, faster.
Latest Qlik Sense Updates
Make an impression with the top recent data visualization enhancements available in Qlik Sense Cloud. Learn More
Not on Cloud yet? Check out the highlights from the August Client Managed release. Read Blog
Qlik Cloud Reporting Q&A
Join our live Q&A with Qlik Experts on 26 September. You'll be given solutions to common issues faced in Qlik Cloud Reporting, best practice guidance, and more. Register Now
New capacity pricing model and usage telemetry in Qlik Cloud
Discover what this new pricing model means for you and see a demo. Get empowered to better leverage your data sets and support more analytics use cases, with the use of AutoML and GenAI capabilities. Learn More
Deep dive into database-to-database synchronization
Check out the first in our blog series on 7 Data Integration and Data Quality Use Cases for Qlik and Talend. This first post focuses on database-to-database synchronization.
What do you think of the Qlik Digest?
We want to make to make sure the Qlik Digest is exactly what you’re looking for from a monthly newsletter. Take our 2-minute feedback survey and be in with the chance to win one of five exclusive Qlik swag packs. Take Survey
Build on your success with Qlik
Join Qlik Nation to learn about new features, influence the product roadmap, share expertise, and enhance your learning- all while having fun and earning rewards.
There have been many new capabilities that give developers ways to customize and style an app. In this blog, I will review how the sheet header and toolbar can be toggled on and off and the benefits of each, as well as things to consider. The sheet header and the toolbar both appear at the top of an app. The sheet header, outlined below in yellow, includes the name of the sheet, an optional logo or image, and previous and next sheet navigation arrows.
The toolbar is the row above the sheet header. It includes buttons and links to Notes, Insight Advisor, selections tool, bookmarks, sheets and edit sheet.
The toggle for the sheet header and toolbar can be found in the app options section of an app. Open app options by clicking on the arrow next to the app name at the top center of the app. From there, click on the App options icon on the right.
Once the app options are open, you will find the toggles for Show toolbar and Show sheet header.
One of the main benefits of removing the sheet header and toolbar is to gain more space on the sheet. The space that is used by the sheet header and toolbar become area that developers can use for additional filter panes and/or visualizations. Another benefit is developers can add custom capabilities to replace the Qlik Sense defaults. For example, a developer may want to create their own navigation buttons and have more control over the options that are available to the user. If the sheet(s) are being used to create a PowerPoint presentation, removing the sheet header and toolbar makes the presentation look more polished.
Now let’s discuss some things to consider when removing the sheet header. If the sheet header is removed, alternative sheet navigation should be provided for the user. It is possible to use your keyboard to navigate the sheets, but many people do not know that so custom navigation should be created by the developer using buttons or links. In the image below, buttons are used.
In the image below, buttons are used again but the highlighted button indicates the sheet the user is on. So, in this example, the developer has replaced the sheet navigation and the sheet title that was included in the removed sheet header.
A sheet title can also be added to a sheet using a Text & image object. The custom navigation can be designed to match a theme or company brand which gives the developer a lot of flexibility and can give a company’s apps a consistence look and feel.
When the toolbar is toggled off, features are hidden but they are not removed from the app entirely. This is great but not all users may be aware of alternative ways to access the features on the toolbar, so it is important to keep this in mind. For example, users can still create notes for a visualization or view notes for a visualization by right-clicking on a chart, selecting the eclipse (…) and then selecting Notes. Another example is users can still access bookmarks or the sheets in an app via the App Overview. Users can still ask questions via Insight Advisor, so not functionality is loss with the removal of the toolbar. Other things to consider is that while selections can still be made via filter panes and visualizations, without the selection bar, users may not be aware that selections have been made. This is why the developer needs to make sure there are filter panes or some way for users to know what has been selected. When it comes to selections, buttons can also be used to perform actions such as clearing selections and making selections in a field.
The overall goal is not to make things harder for the user so knowing possible issues and designing for them is smart. While there are benefits in toggling off the sheet header and/or toolbar, developers must consider how this may impact their users and how their users will use the app. The user experience can be just as good with the sheet header and toolbar toggled off if the developer plans well for an intuitive user experience.
Thanks,
Jennell
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
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).
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
Hello Qlik Users,
A security issue in Qlik Sense Enterprise for Windows has been identified, and patches have been made available. Details can be found in the Security Bulletin Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-pending).
Today, we have released eight 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:
No workarounds can be provided. Customers should upgrade Qlik Sense Enterprise for Windows to a version containing fixes for these issues. The listed fixes also address CV-2023-41266 and CVE-2023-41265 (link).
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.
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 Critical Security fixes for Qlik Sense Enterprise for Windows (CVE-pending) is 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
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:
The Entitlement Analyzer app provides insights on:
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:
The app as well as the configuration guide are available via GitHub, linked below.
Any issues or 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.
These are the two technologies that are changing how humans work and interact with computers and create content. Understanding what they are is key to understanding the impact they might have on your future career, since you may well be expected to use and interact with these technologies once you enter the workplace. According to World Economic Forum research, while AI could displace jobs it could potentially create up to 97 million jobs in fields ranging from big data and information security to digital marketing. As AI becomes more integrated into business practices there will also be a much higher demand for AI support roles, according to a McKinsey Report. In 2022, 39% of businesses reported hiring software engineers, and 35% hired data engineers for AI-related positions. It's clear that the use of AI in job roles could become the norm, therefore an understanding of how these technologies work will become a necessity.
Data science central have put together this useful guide for understanding the differences between conversational AI and generative AI. Key points are below, but to read the full article follow this link - A complete guide: Conversational AI vs. generative AI
User experience & human interaction
Conversational AI believes in meaningful conversations. Thus, provides quick, direct, crisp, and relevant answers. Generative AI does not engage directly but contributes to user experience by coming up with useful content like blogs, music, and visual art.
What does the future hold?
The trend we observe for conversational AI is more natural and context-aware interactions with emotional connections. Generative AI’s future is dependent on generating various forms of content like scripts to digitally advance context.
Use cases:
• Conversational AI is used in industries like healthcare, finance, and e-commerce where personalized assistance is provided to customers.
• Generative AI is mostly applied to creative domains like content creation, entertainment, design, etc.
To learn more about how you could get free access to analytics software and resources through the Qlik Academic Program, visit qlik.com/academicprogram . By making the most of our software and resources, you can gain future proof data analytics skills regardless of your degree course.
As one creates QlikView applications one sometimes encounters a data modeling problem where a dimensional attribute varies over time. It could be that a salesperson changes department or a product is reclassified to belong to another class of products.
This problem is called Slowly Changing Dimensions and is a challenge for any Business Intelligence tool. Creating an application with static dimensions is simple enough, but when a salesperson is transferred from one department to another, you will have to ask yourself how you want this change to be reflected in your application. Should you use the current department for all transactions? Or should you try to attribute each transaction to the proper department?
First of all, a changed attribute must be recorded in a way that the historical information is preserved. If the old value is overwritten by the new attribute value, there is of course nothing QlikView can do to save the situation:
In such a case, the new attribute value will be used also for the old transactions and sales numbers will in some cases be attributed to the wrong department.
However, if the changes have been recorded in a way so that historical data persists, then QlikView can show the changes very well. Normally, historical data are stored by adding a new record in the database for each new situation, with a change date that defines the beginning of the validity period.
In the salesperson example, you may in such a case have four tables that need to be linked correctly: A transaction table, a dynamic salesperson dimension with the intervals and the corresponding departments, a static salesperson dimension and a department dimension. To link these tables, you need to match the transaction date against the intervals defined in the dynamic salesperson dimension.
This is an intervalmatch. The solution is to create a bridge table between the transaction table and the dimension tables. And it should be the only link between them. This means that the link from the transaction table to the bridge table should be a composite key consisting of the salesperson ID (in the picture called SPID) and the transaction date.
It also means that the next link, the one from the bridge table to the dimension tables, should be a key that points to a specific salesperson interval, e.g. a composite key consisting of the salesperson ID and the beginning and end of the interval. Finally, the salesperson ID should only exist in the dimension tables and must hence be removed from the transaction table.
In most cases of slowly changing dimensions, a salesperson (or product, customer, etc.) can only belong to one department (or product group, region, etc.) at a time. In other words, the relationship between salesperson and interval is a many-to-one relationship. If so, you can store the interval key directly in the transaction table to simplify the data model, e.g. by joining the bridge table onto the transaction table.
A word of caution: If a salesperson belongs to several departments at the same time, such a join may cause QlikView to make incorrect calculations. Bottom line: Double-check before you join.
For a more elaborate description of Slowly Changing Dimensions and some script examples, see the technical brief IntervalMatch and Slowly Changing Dimensions.
9月12日 QlikWorld Tokyo が開催され、300名を超える方にご参加いただきました。当日は最新の Qlik & Talend ソリューションをご確認いただくと同時に、ユーザー同士の交流も活発に行われました。
ワイドサイズのスクリーンに圧巻のオープニング映像が映し出され、弊社カントリーマネージャー今井のご挨拶でスタートです。協賛パートナー10社様、ご登壇いただく7名のお客様、そして午前中のミートアップからご参加いただいた熱狂的なユーザーの皆様に感謝の意を述べ、Qlik + Talend の今後の方向性をご紹介しました。
続いて、技術本部長の濱野から最新の Qlik と Talend の製品情報をデモを交えてご紹介しました。
昨年までのゲストによる基調講演に代わり、今年は先進ユーザー企業であるホンダ、富士通、大日本印刷のキーマンによるパネルディスカッションを行いました。まずは各社の DX推進・データ活用の取り組みについての「これまで」をご紹介いただき、続いて「理想と現実」という観点からの各社の課題を議論いただきました。詳細はここでは書けませんが、「ここだけの」貴重なお話・気づきを多数いただきました。
実はこのパネルディスカッション、事前に2回ほど打ち合わせをしたのですが、その合計時間が本番の時間(45分)を大幅に超える4時間近くとなりました。まだまだお話足りないところや、まったく触れられなかったテーマなどもありました。今後も機会を設けて、お話いただける場を作っていきたいと思います。
休憩時間には、コーヒーを片手にスポンサー様の展示ブースに参加者の方にお立ち寄りいただきました。
後半はビジネスセッションとテクノロジーセッションのふたつのトラックです。ビジネスセッションでは、グローリー様、東亞合成様、日本製鉄様、千趣会様からそれぞれ事例講演をいただきました。なお、グローリー様、千趣会様については後日 QlikWorld Tokyo オンラインにて配信を予定しておりますので、お楽しみに。
テクノロジーセッションでは Qlik プリセールスチームから「データファブリック」「Talend」「Qlik Cloud」「AutoML」の4つのテーマで製品・技術情報を詳しくお伝えしました。
最後は恒例の懇親会です。今井の乾杯で始まり、パートナー、Qlik 社員がドリンクを片手に交流を深め、また Qlik & Talend グッズの当たる抽選会も行い、大いに盛り上がりました。最後は Talend ユーザーのお客様から一言いただき、無事に閉幕いたしました。
QlikWorld はこの後も Global Tour として各国を回ります。
日本でも引き続き、このモーメンタムを感じていただく場を作ってまいりますので、ご期待ください!
Streamline your project management with insightful start-to-finish timelines. Plan, schedule, and keep projects on track and within your budget.
Track progress across stages to spot bottlenecks and optimize workflows. Identify task dependencies and key milestones to prioritize effectively.
Project managers, team leaders, and anyone involved in project planning and management. Anyone interested in exploring the capabilities of Gantt charts within Qlik Sense.
This application features Gantt charts built with AnyChart's Gantt Chart Extension for Qlik Sense, utilizing fictional data to illustrate its capabilities.
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.
Let our Qlik experts offer solutions to common issues encountered with Qlik Cloud Reporting, best practices, and important configuration settings.
Not able to make it live? Don't worry! All registrants will get a copy of the recording the following week.
See you there!
Qlik Global Support
Qlik Data Gateways Upgrade is Required by September 15
Due to planned certificate maintenance in Qlik Cloud, customers must upgrade their Data Gateway installations by September 15.
If you are on version 1.3.2 or earlier, you must upgrade to the latest major version to continue using the Direct Access gateway by September 15.
Setting up Qlik Data Gateway - Direct Access | Qlik Cloud Help
To continue using the Data Movement gateway, customers must upgrade to the latest version 2022.11.74. Please see the documentation below for more details on upgrading:
Please contact Qlik Support if you have any issues with the upgrade: How to Contact Qlik Support
9月12日、Qlik Japanユーザーミートアップを実施しました。今回は、QlikWorld Tokyoとのジョイント・イベントという形でQlikWorld Tokyoと同日・同会場で実施されました。
2023年Qlik Japanユーザーグループは、ハンズオンやデータソン、もくもく会、ライブ配信など、様々な形でユーザーイベントを実施してきましたが、今回のユーザーミートアップは2月に実施して参加者に大変好評だった「アプリ自慢大会」をメインコンテンツとしてお送りしました。
会場受付では、今回のミートアップ限定の「Qlikタオル」が配られました。冒頭の写真でも確認できますが、要所でタオルを掲げて盛り上がりました!
司会進行を務めた学研の渕さんから全体のアジェンダについてご紹介があり、続いてOGIコンサルティングオフィス荻本さんに開会のご挨拶をいただきました。
(学研 渕さんによる司会進行。渕さんはユーザー会幹事でもあります!)
そして、セガの萬さんからQlikルミナリーとQlikアドボケイトのプログラムについてご紹介がありました。Qlikルミナリーはグローバルで、Qlikアドボケイトは国内で、それぞれQlikに関する情報発信などをするいわばエヴァンジェリストのようなプログラムです。ルミナリー・アドボケイト限定のイベントや特典もございますのでご興味ある方はぜひQlikにご相談ください。
(セガ 萬さんはグローバルで50名、日本からわずか3名しか選ばれていないQlikルミナリーのひとりです!)
続いて、アプリ自慢大会が始まりました。こちらのコンセプトは、「完全非公開!リアルな本番アプリをご紹介!」です。撮影や内容のSNS投稿は禁止する代わりに、誰もが知っている大手企業が実際に社内で使っている、リアルなBIアプリケーションを披露しました!今回は、セガ、学研、スズキ、富士通の4社に登壇いただきました。
登壇の様子を少しだけシェアします。ですが、コンセプトにもある通り内容は参加してのお楽しみということになります。毎回ユーザー様にとってすごい刺激になる発表ばかりですので、今回参加できなかったQlikユーザーは、ぜひ次回のイベントにお越しください!
・株式会社セガ 萬様、福山様
・株式会社学研ホールディングス 福田様、横尾様
・スズキ株式会社 仲江川様
・富士通株式会社 池田様
お見せできないのが本当に残念!それくらい、各社のビジネスにおける重要かつリアルなアプリが公開されていました。私自身も大変勉強になりましたね~。
さて、アプリ自慢大会の後は、お楽しみ企画「Qlik Quiz」。このパートは、Qlikのウェビナーでおなじみ、鈴木と中嶋(私)がMCを担当しました。
「Qlikのことをもっとよく知ってもらおう」という趣旨でQlikに関する2択クイズを10問出題しました。間違えた時点で脱落というサバイバル方式で、最後まで勝ち残った10名の方にQlikWorld Tokyo限定のQlik Tシャツをプレゼントいたしました!問題は意外と難しかったようです😅😅😅
(解答選択肢に応じてタオルか手を上げてもらう、というシンプルな方式。ここでもQlikタオルが大活躍!)
最後に、お知らせのコーナー。
なんと、これまで英語でしか受験できなかったQlikの認定資格「Qlik Senseビジネスアナリスト」がついに日本語で受験できるようになりました!ここで、Qlikアドボケイトである富士通の中川さんより、「これを機にみんなでQlik資格を取りましょう!」というメッセージもいただきました。
最後に、次回のミートアップ予定が発表されました。次回は、12月に大忘年会と称して、一年を振り返る会を実施します。日付やアジェンダはTECH PLAYのQlik Japan User Groupページから改めてご案内します。(グループのフォローもよろしくお願いします!)
それでは、次回大忘年会でお会いしましょう!
la facturacion que no se emite en tiempo
un incremento en cobranza y emision de facturas
Genrentes y personal de CxC
para el departamento tener en una sola vista todo el reporte y poder revisar el saldo por cliente en especifico
Hello Qlik Users,
Beginning October 10, 2023, access to the tenant recovery URL for tenants (https://<tenant name>.<region>.qlikcloud.com/login/recover) will be restricted to the Service Account Owner of the tenant. This update is performed on all Qlik Cloud tenants to handle circumstances in which the service account owner for a tenant was changed or will be changed.
If you are using the recovery login URL to access your tenant regularly, we recommend you use the standard login URL for your tenant (https://<tenant name>.<region>.qlikcloud.com/login) instead. You cannot access the tenant through the recovery login after October 10, 2023.
Thank you for choosing Qlik,
Qlik Support
What does this mean for you?
Capacity pricing removes restrictions around data sources and users, allowing for greater value around data loading and analysis. This new pricing model uses Data as the primary value metric and is designed to empower you to better leverage your accessible data sets and support more analytics use cases with the use of AutoML and GenAI capabilities in Qlik Cloud. The structure of our new model is based on extensive market research and customer feedback, with the goal of providing greater flexibility and predictability when using Qlik Cloud. You can now subscribe to pre-defined data packs at a fixed monthly cost while making it easier to adopt the full set of cloud capabilities. All of this, with embedded telemetry, organizations can understand and monitor their data usage.
Capacity pricing offers the following benefits:
Can't see the video? Watch it here
What are the new pricing tiers?
Understand the details of Qlik’s capacity pricing and packaging options on a new pricing page on Qlik.com showing the list prices of each plan. New customers can choose from three distinct plans when doing business with Qlik: Standard, Premium, and Enterprise. And existing customers can move to the new pricing model on their own timeline and can decide what tier is best for their needs. Work with your account team to explore migration to this capacity model.
Just to showcase the Qlik Cloud possibilities
Not because it is just a DEMO
Trying to inspire the Qlik Community with nice ideas and designs
Not
We understand that when you encounter issues or have questions, you need quick and convenient access to assistance. That's why we're thrilled to introduce our latest beta enhancement: In-Product Support Chat for Qlik Cloud Administrators.
We're taking customer support to the next level by making it more accessible and user-friendly. Whether you're a seasoned pro or a new administrator, getting the help you need is easier than ever.
You'll find our Support Chat right under the Resource Center in your cloud tenant:
Whether it's troubleshooting technical issues, getting guidance on using our features, or simply asking a question, our always-learning chatbot is at your service 24/7. Or you can be easily connected to our support team to provide you with personalized assistance tailored to your specific needs, Monday-Friday.
We’re excited to embark on this journey with you. Please be sure to share feedback on your chat experience at the end of each conversation so we can continuously make improvements.
Thank you for choosing Qlik, we look forward to chatting with you!
If you have any questions about our new in-product Support, don’t hesitate to reach out.
Sincerely,
Qlik Global Support
Ever found yourself stuck with a messy pile of data that seems more like a labyrinth than a pathway to clean insights? You're not alone. Today, we're diving into the world of data cleaning in Qlik Sense to help you uncover the analytical potential hiding behind your data.
Imagine you're baking a cake. Would you eyeball the measurements of your ingredients? Probably not, unless you fancy a disaster cake. Just like one poorly measured cup of flour can ruin your entire recipe, a small data error can throw off your whole analysis. That's why, before you dive into the fun part—data analysis—you've got to make sure your key ingredient (data) is as clean and precise as possible.
It's not just about tidying up; it's about quality control. Skipped steps or overlooked errors can lead to inaccurate results that could misinform your business decisions.
These types of tables behave differently than other tables in that they are stored in a separate area of the memory and are strictly used as mapping tables when the script is run, they are then automatically dropped.
Let’s take a look at how to do this and the different statements and functions that can be used:
CountryMap:
MAPPING LOAD * INLINE [
Country, NewCountry
U.S.A., US
U.S., US
United States, US
United States of America, US
];
Keep in mind that a mapping table must have two columns, the first containing the comparison values and the second contains the desired mapping values.
The ApplyMap function is used to replace data in a field based on a previously created Mapping Table.
CountryMap:
MAPPING LOAD * INLINE [
Country, NewCountry
U.S.A., US
U.S., US
United States, US
United States of America, US
];
Data:
LOAD
ID,
Name,
ApplyMap('CountryMap', Country) as Country,
Code
FROM [lib://DataFiles/Data.xlsx]
(ooxml, embedded labels, table is Sheet1);
The first parameter in ApplyMap is the Mapping Table name in quotes. The second parameter is the field containing the data that needs to be mapped.
You can add a third parameter to the ApplyMap function that serves as a default to handle cases when the value doesn’t match one in the Mapping Table.
For instance:
ApplyMap('CountryMap', Country, 'Rest of the world') As Country
after mapping:
ReplaceMap:
MAPPING LOAD * INLINE [
char, replace
")", ""
"(", ""
"\"", ""
"/", ""
"-", ""
] (delimiter is ',');
TestData:
LOAD
DataField as data,
MapSubString('ReplaceMap', DataField) as ReplacedString
INLINE [
DataField
"(415)555-1234",
"(415)543,4321",
"“510”123-4567",
"/925/999/4567"
] (delimiter is ',');
after cleaning:
Map Country Using CountryMap;
Data1:
LOAD
ID,
Name,
Country
FROM [lib://DataFiles/Data.xlsx]
(ooxml, embedded labels, table is Sheet1);
Data2:
LOAD
ID,
Country as Country2
FROM [lib://DataFiles/Data.xlsx]
(ooxml, embedded labels, table is Sheet1);
UNMAP;
UserData:
LOAD * INLINE [
UserID, FullName
1, "John,Doe"
2, "Jane,Doe"
3, "Alice,Wonderland"
4, "Bob,Builder"
];
CleanedData:
LOAD
UserID,
SubField(FullName, ',', 1) as FirstName,
SubField(FullName, ',', 2) as LastName
RESIDENT UserData;
Drop Table UserData;
Example 1:
Using a combination of the functions above to clean up a field. Let’s take a more complex field and try to extract the first name and last name.
UserData:
LOAD * INLINE [
UserID, Object
1, "37642UI101John.Doe"
2, "98322UI101Jane.Doe"
3, "45432UI101Alice.Wonderland"
4, "32642UI101Bob.Builder"
];
CleanedData:
LOAD
UserID,
SubField(Right(Object, Len(Object) - Index(Object, 'UI101') - 4), '.', 1) as FirstName,
SubField(Right(Object, Len(Object) - Index(Object, 'UI101') - 4), '.', 2) as LastName
RESIDENT UserData;
Drop Table UserData;
after cleaning:
Example 2:
Cleaning HTML in a field
Paragraphs:
LOAD * INLINE [
Paragraph_ID, Paragraph
1, "<p>This is a <strong>paragraph</strong>.</p><br><p>This is another <em>paragraph</em>.</p>"
];
// Loop through each paragrpah in the Paragraphs table
For vRow = 1 to NoOfRows('Paragraphs')
Let vID = Peek('Paragraph_ID', vRow-1, 'Paragraphs'); // Get the ID of the next record to parse
Let vtext = Peek('Paragraph', vRow-1, 'Paragraphs'); // Get the original paragraph of the next record
// Loop through each paragraph in place
Do While len(TextBetween(vtext, '<', '>')) > 0
vtext = Replace(vtext, '<br>', chr(10)); // Replace line breaks with carriage returns - improves legibility
vtext = Replace(vtext, '<' & TextBetween(vtext, '<', '>') & '>', ''); // Find groups with <> and replace them with ''
Loop;
// Store the cleaned paragraphs into a temporary table
Temp:
Load
$(vID) as Paragraph_ID,
'$(vtext)' as cleanParagraph
AutoGenerate 1;
Next vRow;
// Join the cleaned paragraphs back into the original Paragraphs table
Left Join (Paragraphs)
Load *
Resident Temp;
// Drop the temporary table
Drop Table Temp;
after cleaning:
I hope you found this post helpful!
Attached you can find a QVD that contains the scripts used in the post.
Happy data cleaning!