Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Qlik Gallery is meant to encourage Qlikkies everywhere to share their progress – from a first Qlik app – to a favorite Qlik app – and everything in-between.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
This week we introduce you to one of our returning Educator Ambassadors for 2023, Nassir Ibrahim, a lecturer at Birmingham City University. This is Nassir's second year as an Educator Ambassador. Nassir integrated Qlik Sense and the Academic Program into his teaching in the last year or so, however he immediately saw the benefits to his students and their employability.
Nassir introduced Qlik to his final year undergraduate students on his Data Intelligence module, having heard about Qlik from a colleague and Qlik Educator Ambassador. He explained “what I found from using various tools, is Qlik has an edge over other tools, because of its user friendliness and because of its training and learning materials online.”
Nassir, like many Educators, wanted to incorporate Qlik Sense into his teaching but he had not yet used it himself, “Qlik has excellent training resources, [some] of the best I have ever seen so I had to become familiar with the technology and know how to use it myself. There are the video training materials you have; they are excellent... It’s about becoming a student and learning yourself in order to help others learn.”
Many Educators who join the Academic Program are unsure of how they can incorporate Qlik sense into their teaching, Nassir found that the best way to do this was by utilizing the interactive videos we offer. “Some of your videos are quite long but generally they are 30 to 40 minutes and I think that’s perfect. We would structure our classes with breaking down some of the longer videos. They would have 20 minutes of the tutorial and then the students would do the exercises themselves, because the students benefit more from doing”.
One of Nassir's goals with implementing Qlik Sense into his teaching was to support student employability. “The job market is asking for knowledge of Qlik now and by doing well in this module [students] could show that they have a good understanding of the functionalities of Qlik. There was one student who graduated last summer, and he is now working in a company as a software developer and they use Qlik.”
“This was a proud moment because all of the resources you shared with me, were actually required in the job market. It showed that we were preparing our students for the industry world adequately…all it takes is one student to show that the work we had done was worthwhile”.
Regardless of proud moments such as this, Nassir is still determined to reach those students who still might not be as engaged with Qlik. “In the next Academic Year I think I will they will have to present their work back to us and demonstrate how they’ve used the tool to stretch them a bit more”. Nassir wants to cover the fundamentals but then have the students explore the tool for themselves as well. “What can they discover about the tool that they had not anticipated previously? only when they start to explore and imagine some of the things that they could do with the tool will they be able to say hey, this is actually something which we could use to solve our problem in ways that we didn't think of in the beginning”.
When Nassir isn’t teaching, he likes to spend time working on his own personal development, weight training and trying to beat his best time on the racetrack! Nassir also enjoys developing scientific toolkits for business decision-making and that automate business tasks!
If you are interested in learning how the Academic Program can support your students with their data analytics and employability skills, you can learn more by visiting qlik.com/academicprogram.
Find the agenda here. Log in and start registering for sessions by clicking the “+” button to build your personal schedule to get the most value from your QlikWorld experience!
You won't want to miss the Qlik Product Roadmap session to hear our strategy for 2023 and beyond from our Product Management and Product Marketing Leadership teams, @Ian_Crosland , @TimGarrod , @Denise_LaForgia , @PietMichielRappelet
As well as teaching at Saint Joseph’s University, Vilanova University and Drexel University. This past year Javier joined Rowan University, teaching Market Research to Undergraduates. The main objective of his new course at Rowan is to help students improve their research abilities using applied statistics and data analysis.
Javier is passionate about data literacy and this drives many of his courses,” I teach several different courses in areas such as Marketing, Business Intelligence, Business Analysis, Business Analytics, R Programming, Management Information Systems, Statistics, and Data Visualization. In all courses, I have started talking to my students about the importance of data literacy and I make it a point for them to see how Artificial Intelligence can be used to augment their capabilities in each area.”
One of Javier’s key aims this year is to continue giving his students the chance to learn on market leading software through the Qlik Academic Program. He has set himself a number of objectives this year, one of which is “Provide students with the necessary tools to help them become data literate I want all my students, regardless of their major, program, or background, to be able to read and communicate with data. One great enabler for this objective is Qlik Continuous Classroom because it offers students multiple tools and courses that allow them to turn their data into information and actionable dashboards using Qlik Sense.”
Javier foresees a great increase in demand for professionals who can work with data visualization, AI and machine learning, data privacy and cybersecurity and cloud computing. He also believes,” Business intelligence is an essential part of analytics, and there is a growing demand for professionals who can use data to help organizations make informed decisions. In higher education, there is a growing demand for programs that teach students about business intelligence and its applications in various industries."
As well as teaching Javier continues to work as a project manager for Amazon Produce Network, where he is working on a tool to connect the capabilities of growers with the needs of customers. Yet he still found the time to apply as an Educator Ambassador for the third time, “I applied once more because I believe in Qlik's Vision of (...)a data-literate world. Where people, businesses, organizations, and governments tackle their most complex challenges with data. Being an ambassador I have the opportunity and privilege to work with multiple different professionals who are passionate about knowledge. Also, thanks to the seminars and meetings we hold, I have the opportunity to keep my knowledge current and to be exposed to new trends and tendencies in the Industry, something much needed by every professional... . I think I will apply for as long as you will have me!”
If you'd like to learn more about the free software and training resources you could be eligible for as part of our program please visit qlik.com/academicprogram.
QlikWorld is back in person for the first time since 2019, and this year is a year to come join us in Las Vegas to celebrate!
We’ve reinvented our biggest event, so now you get all of the learning, all of the inspiration and lots of peer connection – but also a thrilling time filled with ways to get you excited about data integration, analytics and everything in between.
We have EXTENDED Early Bird Registration until March 21st! SAVE $200 by registering for QlikWorld now!
SAVE $150 on Certifications. Spots are limited so be sure to snag the time slot you desire most because once they’re gone, they’re gone, and we would hate for you to miss this incredible in-person opportunity. Learn more here.
New! Check out our breakout catalog with 100+ sessions! Attendees will hear customer success stories from companies like Volvo, Lenovo, Intuit, Siemens, Samsung, and Takeuchi as well as partners and industry analysts. Stay tuned for more announcements about our keynote speakers.
For more details including the agenda and FAQs, visit our QlikWorld page.
Feel free to post using #QlikWorld and the photos below once you have registered! We’ll see you in Las Vegas!
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 Ambassador for the 3rd year in a row due to her continued enthusiasm for Qlik’s Academic Program and her efforts in 2022.
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 Operations Manager at Bitmetric BV and is responsible for general management, determining the strategic and tactical direction of the company, 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 Professor Ambassador with the Qlik Academic Program as she is passionate about educating students in data analytics and championing the cause of data literacy. Due to the change in situation in the field of education, she included new aspects in her teaching style which include preparing questions in Kahoot and the book “Data Literacy in Practice” 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! She is keen to present at Qlik World, Qlik’s flagship event, and hopefully that might materialize in the future!
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, 32% of her 275 students are working in the field of data and analytics. Her main goal for 2023 is to work on training for Data Literacy in Dutch and English, based on the book Data Literacy in Practice.
Angelika feels that more and more organizations are now emphasizing the importance of data literacy and putting data management in place. 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
Qlik は、今年も「2023 ガートナー データ & アナリティクス サミット 」に、講演およびブース出展します。
Qlik のエンドツーエンドのデータ統合および分析クラウドプラットフォームが、どのようにビジネスの瞬間を捉えるのか。受け身のツールセットから、リアルタイムの情報を提供し、即座に行動を起こすことができるよう構築された能動的なシステムへ移行する方法をご紹介します。
データとアナリティクスのリーダーが一堂に会する世界で最も重要な IT イベントに、ぜひご参加ください。Qlik 講演および Qlik ブースで、皆さまをお待ちしております。
詳細を見る
【開催概要】
日時:2023年 4月 4日(火)– 6日(木)
会場:ウェスティンホテル東京(恵比寿)
WHAT’S NEW AT QLIK?
Qlik already supports over 250 data sources, but there’s more to come. Introducing the Connector Factory - our strategy to accelerate the delivery of connectors. We’ll be delivering enhanced connectors for Analytics, plus over 100 new connectors in 2023 for Qlik Cloud Data Integration. LEARN MORE
Get the new client-managed releases for Qlik Sense, Qlik Replicate and more. Download here
QlikWorld Session Catalog
The breakout agenda for QlikWorld is now available! Explore hundreds of great sessions, from outside the box thinking on Qlik Sense Tips and Tricks, to Building a “Data Powerhouse” on Snowflake.
Supply Chain Disruption Meets Real-Time Data
Join us on March 14 as we discuss the necessity of smart, timely responses to critical supply chain issues we are all experiencing, both professionally and as individual consumers.
Why Data Needs More Diversity
As a fierce advocate for women’s STEM education, Deborah Berebichez shares her journey to becoming the first Mexican woman to gain a PhD in Physics from Stanford University. Discover her views on the importance of diversity in data and our collective responsibility to empower others.
ADDITIONAL FEATURED CONTENT
Hello, Qlik Community!
We are thrilled to introduce you to the Qlik Partner Ambassador Class of 2023. Partner Ambassadors are some of the most engaged and influential members of Qlik’s global partner ecosystem. Selected for their Qlik technical expertise, industry knowledge, thought leadership, and public advocacy, you will see them all being active throughout Qlik Community.
Partner Ambassadors are identified in Qlik Community by the Partner Ambassador badge. Coming soon- they will also be recognized with a new Partner Ambassador rank! Partners who have previously served as Ambassadors will also be identified with a Partner Ambassador Alumni badge.
Partner Ambassadors are passionate about Qlik and share our enthusiasm for helping customers drive impactful results through data. Get to know them- and watch for their activity and leadership throughout Qlik Community, at QlikWorld, on social media and beyond!
If you are a Qlik Partner, be sure to subscribe to the exclusive Partner-only Area of Qlik Community to stay up to date on partner news, events and opportunities.
More information about the Qlik Partner Ambassador Program can be found here.
Congratulations again to all our outstanding Ambassadors!
REGISTER FOR MARCH 29 LIVE "DO MORE WITH QLIK" SESSION on BUSINESS GLOSSARY
Can't see the video, YouTube blocked? View it here: SaaS in 60 - Business Glossary
How does your company define “profit”? What about an “order” or a “customer”? While you may think that terms like these have only one common definition, we’ve found that different organizations can describe these terms quite differently. And even within a single company, different people may be defining the same term in multiple ways.
That’s why Qlik is pleased to announce the initial release of a business glossary which will be available to all Qlik Cloud Analytics customers as part of their existing subscription. Built upon the Cloud Catalog framework, users can now access a single, easily-accessible repository of business terms and descriptions. This ensures that everyone in the organization has the same understanding of key business terms.
When Data stewards are defining and managing these business terms, they can also categorize terms logically by business context, define relationships between terms, reference related apps & datasets as well as control which terms are accessible to users.
Having a business glossary helps ensure that everyone in the organization speaks the same language. It can streamline data-based decisions by eliminating misunderstandings due to competing terminologies or inconsistencies between technology definitions and business language. And a glossary can simplify regulatory compliance and serve as a crucial tool for data governance.
To learn more about Qlik’s business glossary, check out these two demo videos:
If YouTube is blocked - you can watch the video here:
This video shows how a data user would interact with the glossary.
If YouTube is blocked - you can watch the video here:
And this video is focused on the data steward.
REGISTER FOR MARCH 29 LIVE "DO MORE WITH QLIK" SESSION on BUSINESS GLOSSARY
新世代のデータアナリティクスプラットフォーム、Qlik Sense Business の入門 Web セミナーです。Qlik Sense Business のセットアップから分析の実践・共有・コラボレーションまで、一通りの分析ワークロードを 1 時間ほどで体験いただき、基本的な機能や操作について理解いただける内容となっています。
この度、以下の内容を追加して新たに公開しました。ぜひ、ご視聴ください!
Qlik Sense Business はクラウド製品(SaaS)です。クレジットカード不要で 30 日間の無料トライアルにサインアップできますので、PC とインターネット環境とメールアドレスがあれば、Web セミナーの案内に従ってすぐに分析を開始できます。

Gantt charts in this app make it easy to plan, schedule, and track projects at different levels within an organization. The data is arranged into three major views: Executive, which provides a high-level overview of the overall performance of each division (department); Division, which offers an in-division view; and Assignee, which shows the tasks and progress of each employee.

Make data-driven decisions and improve overall performance. Organize complex projects and establish schedules. Encourage teamwork, maximize resources, manage integration, control costs, manage changes, and manage quality.

All levels of management — to bring teams together across your entire organization, providing visibility in a single location for the most effective project management and decision-making.

This application was built using AnyChart's Project Gantt Chart extension for Qlik Sense. The dataset is fictional, covering 6 divisions, 24 projects, 1000 tasks, and 80 assignees.
A definition for insanity is doing the same thing over and over expecting a different outcome. In this blog, I hope to save you, the reader, from going through what I went through, maybe five minutes of reading, will save you from the hours of confusion that I had to endure.
Background: In case you don’t know me, I’m Matt Smart. I work on the demo team here at Qlik. I am currently in the process of updating some Qlik Sense apps. This can involve updating extensions that may not work properly, correcting expressions that are no longer functioning, or more cosmetic, such as refreshing the color schemes of an app. The latter is where my problem began.
Situation: While updating an app titled ‘Overall Equipment Efficiency’, I wanted to change the color scheme of a sheet titled “Shift OEE”. This sheet used a burnt orange and gray color scheme to designate the differences between a ‘Morning’ and ‘Evening’ metric.
I wanted to change the colors, so I navigated to the properties panel and selected Appearance > Colors and Legend where I found the following expression: if(ShiftType='Afternoon', $(vAfternoonColour), $(vMorningColour)) . Great, the colors are controlled by an expression, this expression says “If the shift type is Afternoon, use the vAfternoonColour, otherwise, use vMorningColour. The ‘v’ in front of these parameters tells me that they are variables. Awesome, all I have to do is change the values of these variables, and I can change the colors to the new colors.
So I venture to ‘Variables’ at the bottom left-hand part of the ‘Edit sheet’ page.
Within the list, I find the variables contained in the color expression, along with their definitions, RGB values to designate the colors attached to them.
Now all I have to do is change these values to whatever colors I want, and I am done. I go to edit, change the values and BAM! My colors are updated, and the app is looking good.
After being away from my computer for a bit, I return to resume editing the app and what do I find? The colors reverted back to their original values.
Maybe my changes didn’t save. No problem, I’ll just fix it again and continue working.
The next morning, I get on my computer again, load everything up and:
Burnt orange and gray. Something is wrong. The other changes I made are still in place so it cannot be an issue in saving. I go back to variables and change the values back to Purple and Blue. “I’ll test it out.” I say to myself, completely exiting out of my browser and signing back into my tenant.
Finally. It saved. I can move on, and I do. Continuing to work on the app again until lunch time. A full belly later, and I reopen my tenant and:
“Witchcraft.” I mutter to myself. Why is this happening? There must be something I am missing. Why is it only this value that continues to revert? I ponder on it, changing it back, worried that the next time I open my tenant, I’ll see burnt orange and gray yet again. The next morning, orange and gray. What is happening?
The Solution: It is important to remember that here at Qlik, we’re all one big team, and I am lucky to be a part of an amazing subsection of this team, the Demo Team. I bring up my problem in the morning meeting, expressing that I am dumbfounded. I have tried everything that I can think of. When I am told, “Did you check the Data load editor”. I hadn’t. Sure enough, in the script for this app, we’d find colors and:
vMorningColour and vAfternoonColour. I change the values here and:
I eat lunch, I load up and:
Finally, success.
What was happening: What confused me originally was the time of the changes. It seemed to only happen after a certain amount of time had passed. This should have been my first clue. While I was changing the values in the variables section, these values would only stay for a certain period, that period being a data load. When the data would load again, my values would be rewritten and thus my bars would return to their former color. To put it simply: the data load trumped my edit in the variable section. That’s why it would only happen after a certain amount of time. It wasn’t a saving issue at all.
Conclusions: There is always a logical reason behind why something is happening. When you run into a problem, begin looking for a solution in a different place. My problem was I thought I knew what was happening, and I repeatedly tried the same solution hoping it would stick instead of investigating further. Additionally, different points of view can lead to different solutions.
Hopefully my pain can be a lesson to you, and this can help you on your Qlik journey.
PS: Don’t forget to check your Data load editor.
L&T Edutech is the education arm of India's large diversified conglomerate, L&T.
L&T Edutech aims to integrate academia and industry by enabling job ready talent through world class application oriented learning and assessments, powered by L&T's decades long expertise in Engineering and Technology. The current focus is on offering industry relevant skills and knowledge to the graduating college students, thereby making them employment ready. Launched in Oct 2021, L&T Edutech has already partnered more than 50 colleges and institutions and strongly growing.
The Qlik Academic Program is an initiative of Qlik which offers real time data integration and analytics solutions. This program is a part of Qlik's vision of a data literate world. The academic program is meant for accredited universities and institutions and offers free resources including software, online training, qualifications and certifications etc. Professors and students are eligible to sign up for the program and after their application is successfully processed, they get access to these resources. To know more about the academic program, visit: qlik.com/academicprogram
Recently, L&T Edutech and the Qlik Academic Program entered into an MoU so that partner institutions part of the L&T Edutech network can benefit by leveraging the free analytics resources of the Qlik Academic Program.
Here is a link of this announcement: https://lntedutech.com/newsroom/collegeconnect/lnt-edutech-collaborates-with-csi-to-offer-real-world-technical-expertise-to-learners/
Placeholder
Placeholder
Placeholder
Placeholder
Blerim has been teaching since 2007, he is a Senior Lecturer at Lund University in Sweden teaching Decision Support Systems for BSc, as well as two MSc courses; Business Intelligence and Business and Artificial Intelligence. Throughout his time as an Educator Ambassador Blerim has done a lot to promote the program within his university, he has introduced many faculty members to Qlik which is now being used within the highly popular course MSc Data Analytics and Business Economics.
When talking about his courses Blerim says, “A distinctive feature of all these courses is that they help in addressing the need to educate a data and AI-literate generation (required by the business and public sector) by being grounded in solid theoretical foundations, addressing real-world projects and using practitioner-oriented tools.” This is one of the reasons why Blerim collaborates so closely with industry, students studying on his courses can expect to gain both theoretical knowledge and hands on experience with tools such as Qlik, “We use the Qlik software and online training on Qlik products, up-to-date demos, Qlik customer stories, and applicable self-paced courses. The latter allows me for a flipped classroom or blended learning format, which [was] immensely useful during the COVID-19 pandemic”.
Blerim found the Academic Program resources especially useful once he started teaching a blend of online and in person classes, and they helped him in moving towards a more modern way of teaching “Blended teaching and learning with flipped classroom methods should be here to stay. Students do not only learn in a classroom…Qlik provides us educators and students various resources for free, as well as short module-based courses. I could not have done the same here alone or even with a help of a colleague. We can be really cutting edge by embracing these new initiatives and connecting different elements in our courses in a form of guest lectures or industry-led ’learnathons’, not just by relying on textbooks of 20 years ago”.
One of the reasons Blerim does this is his belief that jobs and education go hand in hand: “Many of my students immediately or even before graduating are taking on roles in industry as BI analysts, developers etc. In particular, I'm very proud that many of the expat female course participants quickly get employed”.
When asked about the future of analytics and education Blerim believes that that future is in “Cloud-based and self-service platforms, such as Qlik sense Business, so that access to advanced analytics across organizations is democratized, this has dramatically increased the need for data literacy of students within higher education”.
Educators and students can get access to free Qlik software and training resources by applying to the Academic Program today: qlik.com/academic-program

The application shows which makes and models have better pass rates in their MOT tests. This is broken down various ways and is colour coded throughout. Further metrics can be viewed, such as the average mileage per year and average vehicle age, so that the pass rate can be put into context. For instance, Mercedes drivers average over 10K miles per year but still have a pass rate of over 82%.

These data can be useful for many industries and purposes. Insurers might use it to see which makes of vehicle are likely to be driven further each year. The motor trade may use it to fine which models in their range tend to be more reliable. Individuals can even use the application, choosing which day of the week they book their car in for a test - as there is a significant difference in pass rate on different days.

The application has been built to demonstrate the power of the application framework that it is built in, and that of Qlik's SaaS offering. It could potentially have a very wide audience of people who have an interest in the motor industry or UK demographics.

The application has been built using freedom of information data and Quick Intelligence's Instant Sense Application. This application is free to download and allows you to upload your own data, along with a set of metadata, to have a working application in minutes and not hours or days. This is particularly useful for prototyping of applications, but can be used in production also.
See a live demo of the UK MOT application here:
https://www.quickintelligence.co.uk/sense/instantmot.html
Find out more about the Instant Sense Application and download it from here:
https://www.quickintelligence.co.uk/instant-qlik-sense-app/
This video briefly demonstrates Section Access (Dynamic Data Reduction) in the Qlik Cloud Platform and introduces Section Access support for Qlik Sense Apps in Insight Advisor Chat.
NOTE: When using Section Access - I found that the field values you are restricting on must be in UPPER case.
Can't see the video? YouTube blocked by organization or region?
Use this link: https://videos.qlik.com/watch/5AeCZADbpd1jQhHDvqiFJB?
More on this topic here - Qlik Help - Section Access
まず初めに、本ミートアップのホストを務める Qlik プリセールスの中嶋より、Qlik として今年はオンライン配信の Qlik Japan Live!やデータソンのリアルでの開催、QlikWorld Tokyo、忘年会などユーザー様とのタッチポイントを定期的に作り、他社に負けない(?)活発なコミュニティを立ち上げていくことを表明させていただきました。
続いて、世界でわずか 50 人の Qlik Luminary のお一人であるセガ株式会社の萬様より、Qlik Luminary ならびに Qlik アドボケイトの概要と活動について、ご紹介がありました。Qlik アドボケイトは、「Qlik を通じてビジネスを変革し、その成果を社内外に幅広く発信されているトップユーザーを支援するプログラム」で、この日は会場にお越しいただいた多くの Qlik アドボケイトメンバーをご紹介いただきました。
続いて、皆さまが一番期待されていた事例のご紹介です。今回は、株式会社IHI、株式会社クレハ、大日本印刷株式会社、東亞合成株式会社のご担当者様より、各社における Qlik の活用方法と実際の業務でご利用されている Qlik アプリをご披露いただきました。経営・企画・調達・生産・品質・会計・人事・労務で活用されている、全 16 種のアプリをご紹介いただき、この貴重なお話を熱心にノートに書き留めている方々もいらっしゃいました。また、お客様の Qlik アプリを実際に拝見できるのは、Qlik 社員にとっても非常に貴重な機会となりました。
最後は、Qlik プリセールスの川畑が「これまで開催したユーザーミートアップで一番盛り上がったのではないかと思います。」と、ご登壇・ご参加の皆さまへ感謝を込めたご挨拶で締めくくりました。
ここからは、お集まりいただいた皆さまとの交流の場として、富士通株式会社の中川様による乾杯のご挨拶で懇親会がスタート。
ユーザー同士の情報交換やカジュアルトーク、事例の講演者に質問するなど、リラックスしてそれぞれのお時間をお楽しみいただきました。一方、懇親会中のステージでは、Qlik の鈴木・中嶋より、1月にシンガポールで開催された「Qlik 営業全体会議:Sales Kick Off」の様子や「2023年の Roadmap」 など、Qlik の最新情報をご紹介しました。そして、入場の際に選んでいただいた “I AM Happy Customer” “I LOVE Qlik Sense” “I will go to QlikWorld” などのキーワードを基に、全員もれなくプレゼントの Qlik ノベルティ抽選会がスタート。お帰りの際に、当たったノベルティをお持ち帰りいただきました。
歓談中、ご参加いただいた皆さまから
「非常に参考になる話を聞けて、参加して良かったです。」
「自社のアプリで活用できるか、早速検討してみたいです。」
「次回、機会をいただけたら自社の事例を紹介したいです。」
といった嬉しいお言葉をいただきました。
盛りだくさんのユーザーミートアップとなり、Qlik 営業本部長の槙野から最後のご挨拶をさせていただき、盛況のもとに終了することができました。遅い時間にもかかわらず、最後まで多くの方が歓談を楽しまれていました。
今回ご紹介した内容が、皆さまの今後の取り組みのご参考となりましたら、大変嬉しく思います。Qlik は、今後もこのようなユーザー様同士の情報交換の機会を提供してまいります。ぜひ、ご期待ください!
Today, I would like to introduce César Brochero Castel, an Academic Program Educator Ambassador for 2023! César is our Educator Ambassador for the second year, having been also selected last year!
César lives in Argentina where he is an Educator and has been teaching for 8 years at both the Universidad de Palermo and the Universidad Católica. He was inspired to join the Academic Program after discussing with his colleague the difficulties he had using other analytics solutions. During his first several years he taught QlikView and then he migrated to Qlik Sense and has been using that ever since! In addition to Qlik Sense, he also incorporates the Data Literacy training he is provided as part of his membership. Throughout his course the students are required to develop an analytical application using Qlik Sense in which each student freely explores the data with the aim of finding insights and sharing it with others. To help them, they use the social network connector available in Qlik Sense and other resources to go beyond normal dashboard reporting. During his time teaching, César has seen several students decide to use Qlik Sense during their employment which gives him great satisfaction to know that he has helped them out in their professional careers.
César is the Founder of QuAlytics SpA Chile which provides analytics solutions to South American companies using Qlik Sense. In 2022, César also co-funded an EdTech startup called Jupi Digital (Jupidigital.com). The company helps people to re-convert their careers as data analysts. Jupi Digital trains people from diverse fields with all they need to work as data analytics professionals.
When asking César where he believes the industry is going, he replies “I feel that analytical skills are required today more than ever. Today's world requires people trained in data literacy to face the challenges that the world demands. The data is there today, but we must be able to understand it and get something good out of it. We must all go in that direction.”
When César is not teaching or building his business, he spends time with his family and baby Olivia!
Educators and students looking for free analytics software and training can apply to the Academic Program today by visiting qlik.com/us/company/academic-program
The ObjectID and InObject functions are system functions that can only be used in chart expressions. The ObjectID function has one optional parameter and is used to return the object ID of the object the expression is in or of the object type that is included in the parameter. A text & image object with ObjectID() in the expression returns the ID of the text & image object. ObjectID('text-image') also returns the ID of the text & image object. To determine the ID of the sheet the object is on, use the expression ObjectID('sheet'). This will return the ID of the sheet just as you see it in the URL of an app.
In the example below, there are 4 sheets and a button from the master items is on each sheet. An expression is used to color the background of the button based on the sheet it is on. In this expression, the ObjectID function is used to check the sheet ID before assigning the button color.
Here are the results:
The InObject function takes one parameter, which is the ID of an object, and is used to determine if the current object, (where the expression is written), is contained in another object. In the text & image expression below, the InObject function is used to see if the text & image object is in the sheet with ID '040e64b6-4a93-4962-a833-aed253db4ac1'. In this case, the expression returned true (-1) because the text & image object is in the identified sheet. If the expression was false, 0 would have been returned.
The InObject function can also be used to color buttons as done in the previous example. In this example, there are three sheets – a navigation sheet, a blue sheet, and a green sheet. On the navigation sheet there are two master buttons that will navigation the user to the respective sheet.
In the background color expression for the blue sheet, the InObject function is used to determine if the blue sheet button is in the blue sheet. If it is, then the button is colored blue, otherwise it is colored light gray. The parameter used in the InObject function is the sheet ID for the blue sheet.
A similar expression is used for the background color expression of the green sheet button except in this expression, the parameter is the sheet ID for the green sheet.
When the blue sheet button is clicked, the user is directed to the blue sheet and the buttons looks like this:
When the green sheet button is clicked, the user is directed to the green sheet and the buttons looks like this:
Below is another example of the InObject function with a few levels. There is a text & image object in a container object on a sheet. The first three expressions below use the ObjectID function to get the object IDs for the sheet, container, and text & image objects. The last three expressions use the InObject function to confirm that the text & image object is in the container, that the text & image object is in the sheet, and that the text & image object is not in the next sheet.
I would love to hear how you use the ObjectID and InObject functions – share in the comments.
Thanks,
Jennell