Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Analytics & AI
Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
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.
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
-
Using Colors with Qlik Sense Visualizations, Measures and Dimensions
Our Christof Schwarz is back and has created a video tutorial that shows you how to use PERSISTENT CUSTOM colors with Qlik Sense visualizations. Persi... Show MoreOur Christof Schwarz is back and has created a video tutorial that shows you how to use PERSISTENT CUSTOM colors with Qlik Sense visualizations. Persistent colors map all dimension values to specific consistent colors that are represented equally in all charts on the sheet. When you perform selections - the values displayed will all be represented by the same color in the charts. However the colors can change when the sequence or number of values for that dimension have changed. So this tip will show you how to assign specific custom colors to those values so they don't change and remain "sticky" as Christof puts it.
Enjoy!
-
Qlik Sense 3.2: Extension Properties
After reading Michael's wonderful post on the 3.2 features, https://community.qlik.com/blogs/qlikviewdesignblog/2017/04/04/introducing-qlik-sense-32?e... Show MoreAfter reading Michael's wonderful post on the 3.2 features, https://community.qlik.com/blogs/qlikviewdesignblog/2017/04/04/introducing-qlik-sense-32?et=blogs.comment.created#commen…, I admit, I wanted to get into more details on each of the topics he mentioned. Even though this is impossible since there are so many goodies hidden in 3.2, I decided to focus more on the properties panel while creating custom extensions.
Some of these will make us retouch some of our extensions since, personally, I used workarounds like custom color in an input field as hex, inject dropdowns as html etc
Below I show the latest properties and at the end I attach an extension with everything working... Please note that, as the help pages suggest, some of these are "considered EXPERIMENTAL and may be subject to change or be removed in future releases."
For more details, please bookmark Qlik Sense Developer's help page
http://help.qlik.com/en-US/sense-developer/3.2/Subsystems/APIs/Content/extensions-api-reference.htm
SIMPLE TEXT DESCRIPTION Integer 
text: {
label:"This is a description for the properties panel (Text Component)",
component: "text"
},
fontSize: {
type: "integer",
expression: "none",
label: "Font Size (Integer)",
defaultValue: "10",
ref: "vars.fontSize"
},
INPUT TEXT BUTTON 
inputText: {
type: "string",
expression: "none",
label: "String (Input Text)",
defaultValue: "This is a test app to checkout custom properties",
ref: "vars.inputText"
},
button: {
label:"My Button (Button Component)",
component: "button",
action: function(data){
alert("My visualization extension name is '"+data.visualization+"' and have id '"+data.qInfo.qId+"'.");
}
},
BUTTON GROUP Header 2 
weight: {
type: "string",
component: "buttongroup",
label: "Font Weight (Button Group)",
ref: "vars.weight",
options: [{
value: "bold",
label: "Bold",
tooltip: "Select for Bold text"
}, {
value: "normal",
label: "Normal",
tooltip: "Select for normal text"
}],
defaultValue: "normal"
},
show: {
type: "boolean",
label: "Show extra div? (boolean)",
ref: "vars.show",
defaultValue: false
},
COLOR PICKER DROP DOWN 
colorPicker: {
label:"Background (Color-picker)",
component: "color-picker",
ref: "vars.color",
type: "integer",
defaultValue: 0
},
dropDown: {
type: "string",
component: "dropdown",
label: "Select Options (dropdown)",
ref: "vars.dropDown",
options: [{
value: "option1",
label: "Option 1",
tooltip: "Select for Option 1"
}, {
value: "option2",
label: "Option 2",
tooltip: "Select for Option 2"
}, {
value: "option3",
label: "Option 3",
tooltip: "Select for Option 3"
}],
defaultValue: "option2"
},
LINK SLIDER 
link: {
component: "link",
},
slider: {
type: "number",
component: "slider",
label: "Letter Spacing (Slider)",
ref: "vars.slider",
min: 1,
max: 10,
step: 1,
defaultValue: 1
},
RANGE SLIDER SWITCH 
rangeSlider: {
type: "array",
component: "slider",
label: "Range slider",
ref: "vars.rangeSlider",
min: 1,
max: 20,
step: 1,
defaultValue: [8, 17]
},
switch: {
type: "boolean",
component: "switch",
label: "Show Border (Switch)",
ref: "vars.switch",
options: [{
value: true,
label: "Show"
}, {
value: false,
label: "Hide"
}],
defaultValue: false
},
TEXT AREA ARRAYS 
textarea: {
label:"Textarea",
component: "textarea",
rows: 7,//the amount of rows in the textarea component (default is 3)
maxlength: 100,//will not allow more than 100 characters
ref: "vars.textarea",
defaultValue: "This can be your fottnote/legend to your visualizations"
},
MyList: {
type: "array",
ref: "listItems",
label: "List Items",
itemTitleRef: "label",
allowAdd: true,
allowRemove: true,
allowMove: true,
addTranslation: "Add Item",
items: {
label: {
type: "string",
ref: "label",
label: "Label",
expression: "none"
},
textarea: {
label:"My textarea",
component: "textarea",
maxlength: 100,//you shouldn't write too much
ref: "myTextarea"
}
}
}
Attached find the extension.
Yianni
-
The Date Function
Interpretation vs Formatting The first thing you should be aware of is that there are two different functions: Date#() and Date(). The first is an Int... Show MoreInterpretation vs Formatting
The first thing you should be aware of is that there are two different functions: Date#() and Date(). The first is an Interpretation function and the second is a Formatting function.
- Interpretation functions use the textual value of the input, and convert this to a number.
- Formatting functions use the numeric value of the input, and convert this to a text.
In both cases, the output is a dual, i.e. it has both a textual value and a numeric value. The textual value is displayed, whereas the numeric value is used for all numerical calculations and sorting.
The table below shows how to use the interpretation function Date#(). Note that the format code must match the input parameter.
This is very different from the formatting function Date(). Next table shows how to use this function. Note that the format code matches the format of the output text.
In real life, it is often useful to nest an interpretation function inside a formatting function:
Formatting vs Rounding
The second thing you should be aware of is that the Date() function and other formatting functions never change the numeric value of the input value.
This means that you can format a timestamp as a date only, without the time information. This can sometimes be confusing since there is a “hidden” value. In the table below, you can see that the input value corresponds to 12:00 in the middle of the day, but the Date() function effectively hides this from the textual output - but it remains in the the numeric value.
So what should you do if you want to remove the time part of the field, and just keep the date part? Well, obviously you must use a function that changes the numeric value: You need a Rounding function, e.g. DayStart() or Floor().
In the table below, you can compare the output of the Date() function with a couple of different rounding and formatting options.
Summary
The above discussion is not relevant to dates only. It is just as relevant for Years, Weeks, hours, seconds and any other time interval. Further, it is relevant to a number of other functions:
Interpretation functions: Date#(), TimeStamp#(), Time#(), Interval#(), etc.
Formatting functions: Date(), TimeStamp(), Time(), Interval(), etc.
Rounding functions: Round(), Floor(), Ceil(), DayStart(), WeekStart(), MonthStart(), etc.
Combine these functions sensibly, and you will be able to round or format any way you want.
Further reading related to this topic:
-
Qlik Digest - September 2022
What’s New at Qlik?In Qlik Cloud, Qlik AutoML brings the power of machine learning and predictive analytics directly to you. Plus, Direct Access with ... Show MoreWhat’s New at Qlik?
In Qlik Cloud, Qlik AutoML brings the power of machine learning and predictive analytics directly to you. Plus, Direct Access with Qlik Data Gateway enables you to safely connect to and analyze enterprise data that lives behind your firewall.
The August client-managed releases for Qlik Sense, Qlik Replicate and Qlik Catalog feature new capabilities with Databricks and more styling options for your visualizations. Learn More
Get Certified!
Validate your knowledge in Qlik products, data analytics, and data literacy with Qlik Certifications and Qualifications. Once earned, download your digital badge, add it to your email signature, or share on social media to showcase your skills to the world! Learn More
Product Portfolio Roadmap Webinar
Exclusively for Qlik customers and partners, join us on September 22 to get an overview of Qlik’s analytics product strategy, roadmap, and new capabilities in 2022 and beyond. Register Here
Featured Customer Story
Australian energy provider Western Power shares their secret to successful data transformation. Learn More
Additional Featured Content
Watch the latest Qlik Sense SaaS in 60
Register to get a close-up view of Qlik Auto-ML
Be Data Brilliant Podcast: Why Data Needs More Diversity
Lineage and Impact Analysis features now available in Qlik Sense SaaS
-
Bill of Materials
Most hierarchies are dimensional hierarchies. This implies several things: First, you have a many-to-one relationship between the levels: a day belong... Show MoreMost hierarchies are dimensional hierarchies. This implies several things: First, you have a many-to-one relationship between the levels: a day belongs to one (and only one) month, a month to one (and only one) quarter, etc. Strictly speaking, it is not a hierarchy unless this condition is fulfilled.
Secondly, the hierarchy contains no measures. Instead, numbers are stored in a transactional table that is linked to the dimensional hierarchy.
But there is another hierarchy-like structure, the Bill of Materials, the “BoM”. This is a list of items, assemblies and sub-assemblies representing the design of a product or device. Many products are planned and documented with BoMs.
A multi-level BoM depicts parent-child relationships and shows the hierarchical structure of the assemblies and their related subcomponents. A multi-level BoM is essentially a nested list whose items are listed to illustrate multiple assemblies within a product.
But a BoM is very different from a dimensional hierarchy. It does not have to have a strict many-to-one relationship between the levels. For instance, a specific bearing type can be used in several places. For the BoM, this means that the bearing can have several parents in the hierarchy.
Further, each line in the BoM has numbers in it, typically Quantity and Cost. These are measures that should be summed. In a sense, a BoM is more similar to a transaction table than a dimensional table.
A BoM can easily be loaded and analyzed with Qlik Sense or QlikView, but there are some challenges: First, the list often lacks a parent reference. Instead, the parent-child relationship is implied by the order of the rows and the Level field, and visualized by indentations.
Secondly, aggregating the measures is not straightforward. When summing the costs, the multiplicities of all the nodes above it must be taken into account. In the example in the above table, the wheel assembly uses 2 bearings, and the trailer uses 4 wheel assemblies. Then the trailer obviously needs 8 bearings. In other words: The row for the wheel assembly – and all rows belonging to it – must be looped 4 times when summing the cost.
Luckily, both these challenges can be handled in the Qlik script. One possible solution is the following:
Hierarchy ( [Part No], Parent, Description )
Load *,
Subfield( Path, '/', Level ) as Parent;
Load *,
Left( Peek( Path ), Index( Peek( Path ) & '/', '/', Level ) -1 ) & '/' & [Part No] as Path
While IterNo() <= Units;
Load *,
If( Frac( Quantity)=0, Quantity, 1 ) as Units,
If( Frac( Quantity)=0, 1, Quantity ) as Amount
From BoM ;
The reference to the parent is created in two steps: First a Path is built using the Level and the Path of the above row. Having the path, it is straightforward to extract the parent id using Subfield().
Further, each row is loaded several times using a while loop. Hence, row 16 (the ball bearings) is loaded twice since its Quantity is 2. But it should be loaded 8 times since the Quantity of its parent (row 6, Wheel assembly) is 4. This multiplication is achieved using the Hierarchy prefix.
Finally, the above multiplication algorithm only works for integer quantities. For this reason the bottom Load splits the Quantity into two fields: a field Units that is used in the While loop, and an Amount that is used in the aggregation:
Sum( Amount * UnitCost )
However, this means that nodes that have non-integer quantities cannot have any children. If they do, the above algorithm cannot be used, and the cost roll-up must be made a different way. Luckily, this is rarely – or never – the case in real life.
Good luck with your Bill of Materials!
Further reading related to this topic:
-
Qlik Academic Program participates in ICT Learnathon 2022
ICT Academy in association with the industry partners, launched its fifth season of ‘LEARNATHON 2022’ - a self-learning initiative for higher educatio... Show MoreICT Academy in association with the industry partners, launched its fifth season of ‘LEARNATHON 2022’ - a self-learning initiative for higher education students to build their foundational IT skills online.
Since 2018, through Learnathon, ICT Academy has inculcated self-learning among college students and benefitted many students.
The 5th edition of Learnathon has been launched this year by ICT Academy in partnership with global tech majors such as Qlik. This initiative is exclusive to the member institutions of ICT Academy such as colleges and Universities across India.
Learnathon 2022 will see participation from more than 600 colleges. Nine Industry partners including Qlik are participating in this initiative to offer their learning courses and academic programs
The Qlik Academic Program is associated with Learnathon for a second year in a row after a great response in 2021. Students have been very enthusiastic about the learning pathways offered under the academic program and they have actively pursued training for the Qlik Sense Business Analyst and Qlik Sense Data Architect pathways with many of them getting certified. This will add value to the future prospects of students given the fact that data analytics is one of the most sought after careers.
To know more about the free data analytics resources of the Qlik Academic Program, visit: qlik.com/academicprogram
-
In memory of Gysbert Wassenaar
It is with deep sadness that we write this post. Unfortunately, we learned that we lost one of our most valued Qlik Community memb... Show MoreIt is with deep sadness that we write this post. Unfortunately, we learned that we lost one of our most valued Qlik Community members, Gysbert Wassenaar. Gysbert passed away this past weekend. He was not just a member of our Community; he was a Qlik Luminary Alumni, which means he was part of an exclusive program that brings together the best and brightest customers and enthusiasts in the Qlik ecosystem. Most currently, he was part of our Qlik Community MVP Program. As a Qlik Community MVP, he was one of 32 members that went above and beyond answering questions, moderating, and dedicating his time to helping other community members. As a matter of fact, he posted almost 21,000 times! That’s how much he wanted to help! We even featured Gysbert last year; that’s how incredible he was. We were so lucky to get to know Gysbert and knew that we could always depend on his expertise and participation. He will be profoundly missed in our Community.
Words from his family:
It is with great sadness that we must announce that Gysbert Wassenaar has passed away. Our dear, smart, and humble colleague and friend was a pillar of strength to us as well as within the international Qlik Community. Feel free to share this message with other acquaintances. Your memories, replies or condolences will be greatly appreciated.
-
Human Resource Dashboard By Tapati
Human Resource Dashboard By Tapati Freelancer Human Resource Dashboard will be used by my prospective clients as a portfolio of my work and this... Show MoreHuman Resource Dashboard By TapatiFreelancer
Human Resource Dashboard will be used by my prospective clients as a portfolio of my work and this dashboard shows different analyses of employee performance monitoring, employee details and directory.
Discoveries
Human Resource Dashboard will be used by my prospective clients as a portfolio of my work and this dashboard shows different analyses of employee performance monitoring, employee details and directory.
Impact
Organisation will be able to maintain optimum performance of the employee along with their holistic development in the organisation and the Human resource department will be able to keep a track of the overall employee outlook.
Audience
Prospecting human resource managers who will be using this app on regular basis to keep the employee performance in check which helps them for holistic development of employees.
Data and advanced analytics
We have human resource data in this app this will show the trend and give detailed insight about the human resource outlook of the organisation and empower them to make a data-driven decision.
-
事務所移転のお知らせ
時下ますますご清祥のこととお慶び申し上げます。平素は格別のご高配を賜り厚くお礼申し上げます。 この度、弊社はデータを行動につなげる「アクティブインテリジェンス」の実践を通じた機動力の向上、およびアフターコロナの新しいワークスタイルへの対応をめざし、東京本社を新事務所へ移転することになりましたことお知... Show More時下ますますご清祥のこととお慶び申し上げます。平素は格別のご高配を賜り厚くお礼申し上げます。 この度、弊社はデータを行動につなげる「アクティブインテリジェンス」の実践を通じた機動力の向上、およびアフターコロナの新しいワークスタイルへの対応をめざし、東京本社を新事務所へ移転することになりましたことお知らせ申し上げます。
これを機会に、社員一同一層社業に専念いたしますので、今後とも倍旧のお引き立てを賜りますようお願い申し上げます。【移転先住所】 〒105-0001 東京都港区虎ノ門１－３－１ 東京虎ノ門グローバルスクエア 13階
※電話番号は変更ございません
【業務開始日】 2022年 9月 12日（月）2022年 9月吉日
クリックテック・ジャパン株式会社
カントリーマネージャー
今井 浩 -
Qlik AutoML - 機械学習のパワーで分析部門を強化（Qlik Blog 翻訳）
ブログ著者：James Fisher 本ブログは Qlik AutoML – The Power of Machine Learning for Analytics Teams の翻訳になります。機械学習は、売上予測から解約率の低減・顧客生涯価値・在庫の最適化・資本の配分など、多岐にわたる予測分析... Show Moreブログ著者：James Fisher 本ブログは Qlik AutoML – The Power of Machine Learning for Analytics Teams の翻訳になります。
機械学習は、売上予測から解約率の低減・顧客生涯価値・在庫の最適化・資本の配分など、多岐にわたる予測分析のニーズに対し、業界やユーザーコミュニティで利用されています。
通常、データサイエンティストのプロフェッショナルは、非常に詳細かつ高度な方法で、上位の優先事項にのみ焦点を当てます。では、それ以外はどうなるのでしょうか？Qlik AutoML は、「その他の90%」のユースケースに予測分析を適用し、分析部門が大きな価値を創出できるようにします。
Qlik は AIを活用して、単なる履歴的な分析から予測的・処方的な分析への移行を可能にします。従来の分析は、過去のデータから発生したことを把握・深掘りして、「なぜ、そのようなことが起きたのか」という、ある程度のインサイトを得て適切な意思決定を行い、より有効な行動を起こそうとしていました。
Qlik AutoML のロジックも同じですが、機械学習を利用して過去のデータを分析し、将来の結果を予測できるモデルを構築します。推測するのではなく、より具体的な目に見える形で意思決定ができるようになります。予測データと説明できるデータの両方があれば、「これから何が起きるのか」だけでなく、もっと重要な「その理由がわかる」ということです。起こりうる結果とその要因を把握すれば、最善の意思決定から行動を起こすことができるのです。
Qlik AutoML は Qlik Cloud に完全に統合されました。分析部門が AutoML を活用できるよう、シンプルかつコード不要の方法を提供することで、機械学習モデルのトレーニング・予測・意思決定の計画を策定することができます。Qlik AutoML は、独自の分析エンジンを活用し、Qlik Sense で予測データの探索や what-if シナリオのテストを可能にします。また、Qlik のエンドツーエンドプラットフォームを使用すると、通知と自動化で行動を促すことができます。
すべてのエンタープライズ SaaS サブスクリプションには、無制限のテストおよび 2 つの展開モデルが含まれていますので、Qlik AutoML の優れた機能をすぐに体験することができます。ぜひ、お試しください。
-
Do you have what it takes to be a Qlik Academic Program Educator Ambassador?
The Qlik Academic Program provides educators, students, and researchers from accredited universities with free Qlik software and learning resources to... Show MoreThe Qlik Academic Program provides educators, students, and researchers from accredited universities with free Qlik software and learning resources to educate and train the next generation of experts leading with data. Our Educator Ambassador Program aims to shine a spotlight on our most active educator members. Our ambassadors will champion our vision to make more students data literate and to prepare them for the data-driven workplace.
Are you a current educator member who is:
- Passionate about the Qlik Academic Program and the resources provided to students and educators
- Passionate about educating students to be prepared for the data-driven workforce and to secure jobs?
- An active promotor of the Qlik Academic Program to academic peers as well as students?
- Willing to share your experience of the Qlik Academic Program at (virtual) events, in forums, on social media and in the press?
- A contributor to blogs, forums, university publications, professional journals, papers, or other materials that promote the Qlik Academic Program?
If you answered YES to one or more of the above, then we encourage you to apply to the Educator Ambassador Program! Learn more and apply now!
All current educator members are eligible to apply. If you have not already signed up for the Qlik Academic Program, you can do so at https://www.qlik.com/us/academicprogram and then check out our current 2022 Educator Ambassadors.
Application Deadline: The application deadline is November 18, 2022 and the new class of ambassadors will be announced in early 2023.
Ambassador Benefits:
If you are selected as a Qlik Academic Program Educator Ambassador, you will receive a host of benefits including:
- Insight: Exclusive webinars with Qlik leaders, covering the latest trends in analytics and other industry topics
- Credibility: A digital badge to certify ambassador status and a featured online profile
- Exposure: Outreach opportunities to showcase your experience with the Qlik Academic Program via Qlik marketing channels or speaking engagements
- Perks: Discounts on Qlik events and other exclusive rewards
- Community: Collaborate with other educators across various fields and geographies
- Opportunity: Potential to advance your career including meeting university requirements for scholarly contribution beyond the classroom
-
How to make a lollipop chart with Qlik Sense
It's been a while since I posted a tip about creating charts. I say roll up your sleeves and let's hack one of the standard charts to create a chart t... Show MoreIt's been a while since I posted a tip about creating charts. I say roll up your sleeves and let's hack one of the standard charts to create a chart type that doesn’t exist in our chart library. Who's in?
We will be making a lollipop chart and something extra, because, well, why not.
First, let's describe what a lollipop chart is and why it can be useful.
What is a lollipop chart?
A lollipop chart is a variation of a bar chart. It differs from a traditional bar chart in two ways: bars are reduced to a line, and the bar tips are oversized in the shape of a circle. If you're a sweet tooth, it'll remind you of a lollipop.
One of the main benefits of a lollipop chart is that it can be used to represent a large set of tall bars in a less intimidating way. However, it is pertinent to emphasize that this chart is less accurate than a regular bar chart. This is mainly because the center of the circle at the end of the lollipop marks the value. In comparison to the straight edge of a bar, it is difficult to determine where the center is located.
Hands on
We will use a combo chart and some of its not-so-new features to create a lollipop chart. Remember a bar chart needs at least one dimension and one measure.
Drag a combo chart and add a dimension and one measure
Nothing wrong with this chart
Next, let’s start messing with the chart settings. Go to Appearance, Presentation, and then Advance Styling. There you will be presented with a bunch of configuration options. What we want is to make the bar width really thin. Anything around 0.1 usually works well.
Now our combo chart should look something like the one below.
Next, is the time to add the candy on top of those lines. Since we are using a combo chart we can quickly add another measure to it and pick a marker as its representation. Simply add the same measurement you used for the bars again. It will be added as a line and the label will say height of line. Don’t panic, no yet. Next expand the new measure panel and scroll down to click on “More properties” button and pick “Marker” from the options displayed.
Your chart should be looking something like this
The next step is to get the colors of the bars and the marker in sync. Simply select the appropriate color in the menu option under the measure “More properties” panel.
If you want your circle markers in sync with your bars, and you are using something more sophisticated than single color you can go a long way with colors by using expression instead of single color in the panel.
As a final step, make sure that neither the legend nor the tooltip ruin our little hack by showing both metrics. To do that just scroll to the very bottom of the combo chart Presentation properties panel deactivate the legend and change the tooltip properties from basic to custom to make sure you have control over it.
EXTRA TIP:
After learning how to make a fancy lollipop chart using the combo chart, we can spend some time creating a bar chart with rounded corners as in the picture below.
The process is simple, just adjust the bar width until it matches the circle diameter size and voila, your rounded corner bar chart is ready. There are some colors that work better than others at dissimulating marker borders (darker colors), keep that in mind if you are looking for perfection.
Thank you for reading this post I hope you enjoyed it.
Arturo
-
Qlik Sense Mobile SaaS - September Release
Qlik is pleased to announce some exciting new features for Qlik Sense Mobile SaaS. These new updates are intended to simplify and improve the experien... Show MoreQlik is pleased to announce some exciting new features for Qlik Sense Mobile SaaS. These new updates are intended to simplify and improve the experience for all our mobile customers!
With simplified access to our mobile apps, you can now easily navigate to your applicable app store, download the app, and have your tenant automatically added to your mobile device via the options below:
- Scan a QR code using your mobile device found in Qlik Clould
- Click an App Store or Play Store button from Qlik Cloud, your welcome email, or your email alerts
- In the mobile browser, click on the newly added banner!
In addition, we’ve extended our support of landscape mode to our entire application, going beyond just apps (QVFs) and charts. We took into consideration the difference between modals and actual navigation, identified breakpoints where just a regular flip wouldn’t work, and adapted an efficient landscape design for every screen. From start to finish, the Qlik Sense Mobile application is navigable in landscape mode!
We’ve also improved the rendering, performance, and memory consumption of the KPI object as well as added support for the "Link to sheet" action that allows users to navigate to other apps and sheets via the KPI object.
For more information, please check out our SaaS in 60 video – Setting Up Qlik Sense Mobile Improvements and Native Landscape Mode.
-
Qlik AutoML Tips - Tip #2 - The data you should be using - (must contain outcome...
Can't see the video? Watch on the Qlik video site here.Missed Tip #1? - View it here.Tip #2 covers the data you should be using with Qlik AutoML. Whe... Show MoreCan't see the video? Watch on the Qlik video site here.
Missed Tip #1? - View it here.
Tip #2 covers the data you should be using with Qlik AutoML. When creating new ML experiments with Qlik AutoML – you are prompted to select data from the Qlik Catalog. Though you will see data that has been registered in the catalog, it is important to note that not just any data can be used with Qlik AutoML. Historical data ( data you normally use for analytics and reporting with dimensions, measures, time periods, etc. ) is generally not suitable for machine learning. Why? Data you’re accustomed to using in analytics apps is captured all at the same point in time (current, end of day, end of month, etc.). With machine learning and predictive analytics, the dataset needs to contain an outcome we care about and a set of attributes we call features (typically your dimension fields / values) that existed prior to that outcome. That way, a machine learning model can learn the patterns that led to that outcome and therefore identify them in advance when we apply the model to live or current data. That being said – you must select data from the catalog that has been prepared with the main ingredients needed to train machine learning models.
Stay tuned for Tip #3 where I will briefly cover architecting the data set and the needed ingredients.Qlik AutoML Helpful Resources:
-
Qlik Sense Chart Property - Data Handling
Check out this brief video to see how I use the Data Handling property and let the community and I know if you ever used it and if so, how?Can't see t... Show MoreCheck out this brief video to see how I use the Data Handling property and let the community and I know if you ever used it and if so, how?
Can't see the video? View it on the Qlik Video site here
Data handling - Available under Add-on of the selected chart properties
-
Climate Risk Overview
Climate Risk OverviewVan OordThe Climate Risk Overview, a global tool powered by Van Oord where open source data has been mapped onto 10km segments of... Show MoreClimate Risk OverviewVan OordThe Climate Risk Overview, a global tool powered by Van Oord where open source data has been mapped onto 10km segments of the world’s coastlines. The overview brings together key parameters such as populations, low lying land and expected sea level rise to anticipate the hazard of flooding for all coastlines and societies around the world. Use the filters on different criteria to find your own selection of hotspots based on your own perspective. This tool is the first step in a broader plan to bring climate adaptation solutions to the coastal areas which need it the most. Once you have had a look why don’t you reach out to us to discuss how we can collaborate further? The Climate Risk Overview has initially been developed in Qlik Sense. The internal Qlik Sense version is still used to explore new data and visualizations. But most of all to find Climate Adaptation Action opportunities. This Qlik Gallery dashboard is a public demo version for Qlik for Climate Action. https://climaterisk.data.vanoord.com/Discoveries
Van Oord identified 10 locations where we now pursue sustainable business opportunities.
Impact
The planet is facing enormous challenges, caused by human activity, increasing the vulnerability of coastal communities and ecosystems to the forces of nature. This is worsened by the effects of climate change, which is threatening the world’s coastal defences. Van Oord has responded to these challenges by developing the Climate Risk Overview. It is designed to raise awareness and encourage meaningful dialogue between stakeholders in order to provide ready-to-scale marine solutions that help increase the resilience of the communities and ecosystems of coastal areas.
Audience
All stakeholders that deal with coastal communities at risk due to sea level rise on one hand, and are dedicated to further the use of Nature based Solutions on the other hand.
Data and advanced analytics
The app has impacted our field by adding an intuitive geo-spatial multi-criteria analysis with Qlik's famous data exploration dedicated to the general public. The Qlik app adds a valuable new combination to the plethora of valuable, yet siloed data portals on the web.
-
A look at our EMEA Survey Results
87% of respondents said their Academic Program experience was either ‘Somewhat Positive’ or ‘Very Positive’.76% of our educator respondents said they ... Show More- 87% of respondents said their Academic Program experience was either ‘Somewhat Positive’ or ‘Very Positive’.
- 76% of our educator respondents said they felt that earning a Qlik Sense qualification helped to make their students ‘Extremely Marketable’ or ‘Very Marketable’ to prospective employers.
- When asked on a scale of 0-10, how likely they would be to recommend the Academic Program to a colleague or student, 76% gave either a 9 or a 10.
When asked to rank the most useful Academic Program resource, our QCC offering came out as the most useful:
1 – Qlik Continues Classroom Business Analyst and Data Architect Videos
2 – Data Analytics Curriculum
3 – Qlik Sense Qualifications
4 – Academic Program forum on Qlik Community
Here are some of the ways respondents described their experience with Qlik and our Academic Program:
- ‘Qlik Academic Program is practical, supportive and enables me to teach students skills…which will enhance their graduate employability’
- ‘The Qlik Academic Program offers a very professional, straight forward entry for students into the modern, data-driven world of business intelligence applications’
- ‘Our students felt that they gained important skills in an industry-leading tool’
- ‘Qlik Academic Program provide great opportunities for ensuring high quality teaching for me and learning experience for my students’
- 'Qlik Sense, one of the top 3 BI & Analytics platforms worldwide, is my favorite because of its beautiful look & feel, its easy handling, & the great support given for all aspects of a modern cloud based BI platform.'
- 'Thank you for the many years of support and materials, we appreciate it a lot!'
If you’d like to explore our program for yourself, and understand what all the excitement is about, follow this link to learn more: qlik.com/academicprogram
-
Example Questions in Insight Advisor
Insight Advisor helps a user explore their data, generate visualizations, and analyze their data through Qlik Sense features such as Insight Advisor S... Show MoreInsight Advisor helps a user explore their data, generate visualizations, and analyze their data through Qlik Sense features such as Insight Advisor Search, Insight Advisor Analysis Types, and Insight Advisor Chat. In this blog, I am going to review how example questions can be added to Insight Advisor to help users when they start their analysis. Example questions are added at the app level and a developer can add example questions to any of their apps. When using Insight Advisor Search, users will see the example questions when they click in the “Ask Insight Advisor” search box (see image below). From there, users can select one of the example questions or enter a question of their own.
When using Insight Advisor Chat, users will see example questions from all apps that have example questions provided they have access to those apps. Below is an example from Insight Advisor Chat. Notice that the “Show example questions” is toggled on. This needs to be on for the example questions to be presented.
When Insight Advisor Chat is opened, the example questions are presented. If a user would like to see the example questions again later in a chat thread, all they need to do is click on the Questions button to view them. As with Insight Advisor Search, a user can select one of the example questions or enter a question of their own. If you find that the example questions are not showing up in Insight Advisor Chat, be sure to check the app options and make sure “Insight Advisor in hub” is toggled on. This setting can be accessed from within an app by clicking on the app name in the navigation bar and then selecting the app options icon.
Now, let’s take a look at how to add example questions to an app. From within an app, click on Prepare and then select Vocabulary.
Click on the Example questions tab and click on the + Add question button. In the Add Example Question pop-up window, select the language for the question and then enter the question. Once you hit enter, a preview of a generated visualization will be displayed. If you would like to add an example question in multiple languages, click the + Add language button, select the language, and enter the example question in the respective language. Once you are done adding the question, in their respective languages, click the Add button to add the example question.
Repeat this process until all example questions have been added to the app. Here is what it will look like once all the example questions have been added.
Example questions for Insight Advisor allow developers to provide hints and help when using Insight Advisor. They can be used to get the user started with using Insight Advisor and guide them on how to ask their questions about an app. Check out Michael Tarallo's SaaS in 60 video and if you need more information, check out Qlik Help. If you are interested in Insight Advisor Analysis Types, check out my blog.
Thanks,
Jennell
-
Qlik Sense on Windows: Node.Js Vulnerability for versions prior to Nov. 2021
A node.js security update released new versions of14.x, 16.x, and 18.x to address three medium and two high severity issues. Impact Client-managed ... Show MoreA node.js security update released new versions of14.x, 16.x, and 18.x to address three medium and two high severity issues.
Impact
Client-managed Qlik Sense Enterprise on Windows release versions prior to November 2021 are affected.
Recommendation
It is recommended affected users upgrade to the following releases:
- November 2021 latest patch
- February 2022 latest patch
- May 2022 latest patch
- August 2022 IR
To download the latest patch, log into Qlik Community with your Qlik ID, and navigate to our downloads page. Filter by Data Analytics, Qlik Sense Enterprise on Windows, and find the latest version to upgrade to.
-
Qlik AutoML Tips - Tip #1 - Know the outcomes you wish to predict
Can't see the video? Watch on the Qlik video site here.Tip #1 – covers knowing the outcomes you wish to predict, as well as the questions you want to ... Show MoreCan't see the video? Watch on the Qlik video site here.
Tip #1 – covers knowing the outcomes you wish to predict, as well as the questions you want to ask based off your current findings from your historical analytical data. Let’s say when analyzing your sales and order data you have noticed a number of orders that have been cancelled. Further investigation shows those cancelled orders have gone unfulfilled for a specific period of time since being placed. This may be due to the sheer volume of orders and the number employees you have available to process them. You may want to get a better handle on understanding the pattern of cancellation and create some predictions to answer questions like:
- Will a customer cancel their order before it is fulfilled? - Or -
- How many days pass before a customer cancels their unfulfilled order?
Answering these questions will enable you to be proactive with certain customer orders and possibly direct your employees to give those order priority and fulfill them sooner to avoid cancellation. Now that we have our predictive question, we need to architect a data set that will support it so Qlik AutoML can use it effectively. Stay tuned for Tip #2 where I will cover the data you should be using to train machine learning models with Qlik AutoML.
Qlik AutoML Helpful Resources:
