Our partner Inphinity has released a brand new version of Forms  – Forms v7.0!

The newest version of Inphinity Forms write-back extension is a demonstration of creativity with added value. Unique new ideas came not only from our team – many users have shared interesting suggestions on how to improve their favourite write-back extension for Qlik. So, what’s new?

 

Upload a file to your data!

Do you have a list of employees in your Qlik Sense? Do you use writeback for adding comments or saving data about their skills, goals, bonuses, or certificates? There’s still something you need to store outside of the Qlik Sense, isn’t it? Thanks to Inphinity Forms v7.0 you can now upload their CVs, employment contracts, or certificates to each of them right within the table in your Qlik Sense app! Files will be securely stored to the server according to your specific customization. When you need to open it… just click on the link in your app… so simple!

Are you thinking about other use cases right now? Yes, you’re right – sales orders, legal documents, documentation, schemas, photos, scans… everything. Together with other field types, you can create your own workflow around these documents – checkbox if it is legally correct (and of course data about who and when checked it), traffic light if the manager approves it, date when it should be sent or declined…

Add colors to your data

The new field type color picker could seem like a fancy feature only. However, you can use Inphinity Forms for defining your own dimensions, teams, categorizations… Thanks to this new field type analyzer users can manage their colors, too!

Adding new rows by default is finally here

Many of the users suggested workarounds by using Qlik features for adding new rows to the Inphinity Forms. Now, this era ends… Adding new rows is officially available within the extension! To meet your different requirements, you can choose whether the key should be autogenerated or the user could enter his/her own value.

 

Totals of measures for better understanding of the situation

Totals for measures from a data model finally arrives! Naturally, with the same concept as you use it in a Qlik default table – on/off and choosing the right type of total function for each measure.

 

Warn user before saving incorrect data

Now you can define your own validation rules for each field type that’ll be checked right when the data is entered.

 

Qlik-style design improved

The user experience of using Inphinity Forms is now much more similar to the Qlik default table with sorting and resizing columns width by drag & drop!

 

The better focus when editing

When you enter data, the specific cell is identified. But not only that. The whole row is highlighted so you will not get lost in large tables anymore!

 

Interactive support wizard for everyone

As a part of the technical documentation, Inphinity has decided to give a possibility to investigate the issue by yourself. Naturally, the support is available at support@inphinity.xyz in case of any questions or issues.

…and that’s not all … try Inphinity Forms 7.0 now to explore more and find for example table background or more intuitive properties panel!

 

Change any Qlik default visualization to the write-back with drag&drop

Thanks to the way how we develop Inphinity Forms – by using as many Qlik features as possible – it really is natively integrated with your Qlik app. Change any Qlik default visualization to the write-back with drag&drop:

If you want to get technically inspired watch Inphinity Forms TechTuesday video series.

Follow Inphinity on LinkedIn not to miss any news from infinite data analytics world!

 

Enjoy Forms 😉

Mayo Hardware uses Qlik Sense data analytics platform to effortlessly surface important insights and leverage them in day-to-day decision-making.

Mayo Hardware, a leading Australian distribution company, has grown twice the size over recent years without any extra headcount thanks to having proper IT systems in place.

Before, they were using data cubes from Pronto ERP with Cognos and Excel, but there were multiple challenges such as slow runtime, lack of ease of use and inability to bring in additional data sources sitting outside of ERP.

In order to overcome this, they implemented a modern data analytics solution based on Qlik Technology, integrating data from Pronto ERP, Salesforce CRM, Demand Solutions planning and Bunnings point-of-sale.

Today, the new solution is being actively used across the whole business. All users have the data available at their fingertips on mobile devices anywhere, so they can quickly make informed decisions.

If you face similar challenges or would like to learn more, download the full case study here.

“Product that is not sitting on the shelves simply can’t be sold. It is our job to make sure all the stores have the right amount of stock available, to maximise sales opportunity. Having this data available at our fingertips is absolutely crucial.” – Ben Kissell, Operations Manager Thunderbox Industries

Main benefits:

Prevention of lost sales thanks to efficient stock management
Identification of new sales opportunities by analysing historical sales patterns
Automation of reporting & analytics means more time to create value

Download the customer story of Thunderbox, the largest toolbox manufacturer in Australia, about how they use Retail Suppliers solution on Inphinity app store to analyze point-of-sale data from Bunnings and use them to efficiently manage sales and inventory of their products.

Please fill in the form below to download the full case study.

“The Inphinity app is fantastic. The platform is easy to navigate and the customer support has been outstanding. Highly recommend to help drive your business success
– Ben Kissel, Operations Manager at Thunderbox Industries

Our partner Inphinity have released a brand new version of Forms  – Forms v6.0!

Forms 6.0 has the longest list of new features they ever had! Almost all of it is based on clients’ feedback and requirements. What’s new?

Automated multinode installation

Since many of you have multinode Qlik Sense environments Inphinity decided to be helpful and support multi-node installation – in Forms 6.0 you find an installer for your RIM nodes – they will be connected to your central node automatically!

Group-based access control

Do you have hundreds of Qlik users and want to manage their access to Forms in a seamless way? Thanks to Forms 6.0 you can use different types of groups that are available on user level in your QMC!

Do you need to change the type of access management? A new automated wizard will help you do it secure and fast!

New field types: currency & traffic light

Based on customer’s requirements the currency type with editable currency sign, thousands and decimal separators were added.

As a bonus, a traffic light have been released – very helpful for your workflows or priorities!

New toolbar button: refresh

What if my colleague did any change in the same Forms a few seconds ago? I can now be sure I see the latest value thanks to a new refresh button. It refreshes only the object – less than one second even in big apps! And if you don’t like it, you can still hide it in the properties panel.

 

Option to hide toolbar labels in small Forms objects

More and more use cases are solved by Forms each day. Sometimes you need to add a small but powerful Forms object to your sheet. To save space you can now hide toolbar labels in Forms action buttons.

Improved Forms Admin app

In the improved Forms Admin app you will find:

  • Database connection wizard
  • License allocation overview
  • New design

You can download the newest Forms right here or ask your Qlik partner.

If you want to get technically inspired watch Forms TechTuesday video series.

Follow Inphinity on LinkedIn in order not to miss any news from inphinite data analytics world!

 

Enjoy Forms 😉

For some people one of the weaknesses of Qlik Sense are limited visualisations, but with a little effort and out-of-the-box thinking you can overcome the obstacles and make creative visualisations in Qlik Sense. Today we will recreate one famous animated scatter plot with no need to develop or download any extensions.

Have you heard about Gapminder’s animated bubble chart? If not, I recommend you to have a look at this webpage  to learn about Gapminder’s noble goal to fight devastating misconceptions about global development. The animated scatter plot is displaying the change in life expectancy and income through time from 1800 to 2018 where bubbles are coloured by 4 world regions (The Americas, Europe, Asia and Africa) and bubble size represents the population. Let me tell you: the world has improved a lot! Roll up your sleeves and let’s make that one using Qlik Sense. You will only need what comes with the standard installation (make sure you have checked the box during installation to install the Dashboard bunde – the variable input is needed).

Gapminder's animated bubble chart

Get the data

First we have to download all the data needed (free data from www.gapminder.org/data)

  1. Population data: https://github.com/Gapminder-Indicators/pop Download pop-by-gapminder.xlsx
  2. Life expectancy data: https://github.com/Gapminder-Indicators/lex Download lex-by-gapminder.xlsx
  3. Income data: https://github.com/Gapminder-Indicators/gdppc_cppp Download gdppc_cppp-by-gapminder.xlsx
  4. Regions data: http://gapm.io/dl_geo will download Data Geographies – v1 – by Gapminder.xlsx

Load data into Qlik Sense

Load data into Qlik Sense so that there are 2 tables in the data model. One is called Data and contains fields geo, Year, Population, LifeExpectancy and Income and the second is called Countries and contains fields geo, Country and Region.

Data model

 

Feel free to use the script at the end of this post, but do not forget to set the connection GapminderData to the folder where you saved the 4 xlsx files. To get the data in correct form Crosstable method is applied.

Build the animated scatter plot

  1. Go to Custom objects > Qlik Dashboard bundle > Variable input. Change it to slider and assign vYear variable to this visualisation. If you do not have such variable, create it either in script or use front-end variable editor. Set Min to 1800 and Max to 2018. Step should be set to 1.
  2. Create scatter plot and set:
    Dimensions > Bubble: =Country
    Measures > X-axis: =Dual(Avg({$<Year = {$(vYear)}>}Income), log(Avg({$<Year = {$(vYear)}>}Income)))
        We are using dual function, because X-axis is transformed using natural logarithm, but on hover on a single bubble we still want to show the actual income values. Do not forget to change Number formatting to Measure expression.
    Measures > Y-axis: =Avg({$<Year = {$(vYear)}>}LifeExpectancy)
    Measures > Size: =Dual(Num(Avg({$<Year = {$(vYear)}>}Population)), Avg({$<Year = {$(vYear)}>}Population) / Max(TOTAL Population))
        We are using dual function, because we need to scale the population using the total maximum (we want to observe how countries grew in time) but when one hovers on a single bubble we still want to show the actual population values. Do not forget to change Number formatting to Measure expression.
  3. Set colours by regions, titles, footnote and you are ready to explore. Navigate through time by dragging the slider or use arrows on your keyboard to move year by year.

Animated scatter plot

Notice how life expectancy dropped globally in 1918. The reason was the influenza pandemic with high mortality in young healthy people also known as Spanish flu which killed more people than World War I. Did you find any other interesting development in the graph that can be explained by historical events? You can apply this approach in many other use-cases. Let us know about your thoughts and suggestions in the comments.

 

Qlik Sense script to load data into 2 tables model to create animated scatter plot

Let vYear = 2018;
Data:
CROSSTABLE (Year, Population, 4) LOAD
    *
FROM [lib://GapminderData/pop-by-gapminder.xlsx]
(ooxml, embedded labels, table is countries_and_territories);
Fact_LifeExpectancy:
CROSSTABLE (Year, LifeExpectancy, 4) LOAD
    *
FROM [lib://GapminderData/lex-by-gapminder.xlsx]
(ooxml, embedded labels, table is countries_and_territories);
Fact_Income:
CROSSTABLE (Year, Income, 4) LOAD
    *
FROM [lib://GapminderData/gdppc_cppp-by-gapminder.xlsx]
(ooxml, embedded labels, table is countries_and_territories);

Drop Fields geo.name, indicator.name, indicator;

LEFT JOIN (Data) LOAD
    *
RESIDENT Fact_LifeExpectancy;

LEFT JOIN (Data) LOAD
    *
RESIDENT Fact_Income;

Drop Tables Fact_LifeExpectancy, Fact_Income;

Countries:
LOAD
    geo,
    name as Country,
    four_regions as Region
FROM [lib://GapminderData/Data Geographies - v1 - by Gapminder.xlsx]
(ooxml, embedded labels, table is [list-of-countries-etc]);

What are Obama‘s or Trump‘s favourite words? Do you want to see how the presidential speeches of the US Presidents have changed throughout time? Who has the broadest vocabulary? Which words are no longer used? Which historical events played a significant role and shaped the way US presidents speak to the nation?

Find out more about Qlik Sense and R project and learn something about history. Instead of laborious background research of all the US president’s speeches, you can try our mashup called Analysis of Presidential Speeches and do not hesitate to click in graphs, move sliders and do your own selections. Ask questions and get the answers right away. For the purpose of this post, we chose two most recent presidents for a quick analysis. However, you can play with the app and come up with your own findings. At this moment the app offers the best experience on Google Chrome.

Which words carrying positive or negative sentiment were mostly used by Barack Obama?

Move the slider one step back and see.

Which words were used by both Donald Trump and Barack Obama?

Click on the Name button in COMPARE SPEECHES section and select one president for the primary group on the left and second president in a secondary group on the right. Then choose Common words instead of All words right under Cosine Similarity.

Were there times when words with negative sentiment overtook words with a positive sentiment?

The times were dark around World War II. Select a period on X-axis and see what the words with negative and positive sentiment were:

 

Clear all selections using buttons on the top and start again or move back and forth or combine selections to get new views on the data. The possibilities are endless.

You can do more with Qlik

If you want to extend Qlik capabilities and use more advanced statistical tools, R or Python are good choices. Both languages can be integrated with Qlik, which means that you can send lines of code directly from Qlik and receive the results immediately. You need to handle SSEPlugin and Rserve package, but I will save this one for another time.

In this case, I took a little bit of R (for text processing) and a handful of Qlik Sense (for powerful interactive visualizations) and blended it all together in a big bowl of the mashup, and voila!

To be more technical

Text mining techniques were implemented to get useful information from transcriptions which were obtained from The Grammar Lab and Miller Center. This is how you prepare data:

  1. Split texts into small entities, in this case, words (tm package is a great help with this one)
  2. Filter out words with no information value (stop words, numbers, special characters, etc.)
  3. Try to get the base form of a word using word stemming and word lemmatization (check out textstem package). You want to have „connect“ instead of „connection“, „connected“, „connecting“. Remember, you are trying to simplify the information.
  4. Assign positive, negative or neutral sentiment to words (afinn lexicon from tidytext package was used for that one).

When the data is prepared the easier part follows – load data and create visualizations using Qlik Sense.

And there you have it. A nice tool to get your own insights without limitations of passive charts, numbers, and tables. Now it is up to you. Get your own insights, share them and let us know what you think.

Find the app HERE: https://qap.emarkanalytics.com/extensions/Emark_PresidentialSpeeches/Emark_PresidentialSpeeches.html

Your favorite self-service input extension is now even better! 

Brand new functionalities will help you to use Forms for more use cases and even more comfortable! So what is new?

Commenting on object level

Commenting on object level enables the Forms users to collaborate on new level! When you are analyzing your data and want to share some insight or question with your colleagues, you can simply add a comment to the specific object – and capture current selections!

   

You can find the summary of comments in the Comments overview object right after opening the sheet!

 

Improved Forms Admin app

Forms General, Forms Comments, Forms Specific… don’t worry – you wont’ be lost. We have improved the Forms Admin app, so now it contains a simple overview of Forms types . There are more news within the app, as well. It now contains:

  • Forms license – sheet with information about your license and possibility to upgrade your license key
  • Forms types – overview of Forms types with examples
  • Forms configuration – the centralized way how to manage all your Forms instances and related settings

 

Integrated recalculate (reload) button

Up to now we recommended to use the combination of Forms and Reload Task Button when you needed to trigger the reload after changes in Forms. Thanks to your very positive feedback about this approach, we decided to integrate the reload button into Forms! It is named recalculate and gives the user possibility to save his modifications and trigger reload of the app. App developer can choose the type of trigger reload (current app, specific task related to the app, none – hide the button). You can enable/disable the button and combines it with already known save button that only saves changes in your editable fields.

Freezing columns

Freezing columns in horizontal scrolling of Forms General has been highly demanded functionality from our clients who use Forms above all for budgeting :). Here it is. Thanks for the feedback!

Managed editability of cells by expression

Do you want to lock values in the specific column or even better in a specific cell? Would you like a possibility to manage it by expression? We hope so ;). Thanks to this new feature you can simply lock columns for historical months or manage permissions according to flags within your workflow (imagine the process where columns are editable only when the manager allows it – by clicking on the checkbox in his Forms object).

…and more improvements (like hiding columns, delete possibility or editable names of metadata fields) that you can find in extended documentation available in your Forms as well as online.

 

You can download the newest Forms right here or ask your Qlik partner.

 

 

I work in data analytics industry for more than 10 years. Since then, I have experienced the dusk of traditional – centralized BI and the transition to 2nd generation of BI, called decentralized, self service BI or sometimes also Data Discovery. And now, I am experiencing the dawn of a transition to the 3rd generation of BI. The new, “democratized BI” where the modern technologies including the Augmented Intelligence and Natural Language Processing are used to help anybody in the organization to utilize data analytics.

No alt text provided for this image

10 years ago, the top 3 needs of our customers were:

  • to get the single version of truth and to avoid siloed reporting by individual departments,
  • to save time with the preparation of manual reports and automate as much as possible and
  • to empower the internal users and enable them to do the data discovery on any platform including mobile devices.

Now, in the exponential world and shared economy, we are getting more specific requirements such as:

  • to make the data analytics solution more flexible and cheaper on cloud or on premise,
  • to involve the external parties including public and
  • to monetize the data and information, creating a new revenue stream for the company.

Many organizations are still reluctant to provide access to their data to customers or suppliers. The reasons behind that could be the fear of the loss of control, technical issues, fear of showing their IP to the competition or simply the lack of confidence that the data is correct.

Some companies are providing data to their suppliers without any analytics, using static reports in portals or scheduled sending of the spreadsheet to the email.

And the most innovative players are giving out everything by providing their partners with the same data analytics tools they are using internally… or even better ones.

Some examples by the industry leaders

Empowering of your suppliers or customers can bring a lot of positive results.

For example, Travis Perkins, a UK building merchant supplier and home-improvement leader empowered their suppliers using a data analytics platform, which resulted in the better product availability, reduced lost sales, optimized margin and lower deadstock. The requirement from CEO was to “Develop a world class solution for our Suppliers”. You can hear the whole story of Travis Perkins in this webinar.

No alt text provided for this image

Mayo Hardware, an Australian distribution company could serve as an example of customer empowering. Mayo Hardware is holding a market leading position in outdoor lifestyle, safety, security and hardware categories in Australia, New Zealand and selected export markets. They are linking the data from their customers with their own, internal data and they use the analytics apps on mobile devices directly in the stores, cooperating with the customers’ staff. Thanks to this, they are able to better manage the availability of their products on shelves, optimize inventory levels and at the end improving sales and also the relationship with their customer.

Another example is from leading leasing company in Europe. As a next step, after completing their journey towards a data driven organization, they are focusing on monetization of their data and knowledge. Currently, they are starting to empower their dealers and external sales managers by providing the detailed analytics online with the potential of future monetization with other partners.

The deployment models

In general, there are 2 main approaches from data analytics platform point of view.

  • a company invests into the creation of the data analytics platform (e.g. Qlik Analytics Platform) and charges their suppliers or customers for the access, commonly using a freemium model. Usually, a core based licensing is being used and the costs start from $ 30k upwards
  • a 3rd party builds a solution and provides it as a SaaS for a low price (e.g. $ 50-100 per month) to the suppliers or customers. An example of this could be an app for the suppliers of large retailers such as Bunnings or Mitre 10 on Inphinity.app created by EMARK Analytics. The suppliers just need to upload their data to a drive, reload the app to fill it with their own data and they can start analyzing right away.
No alt text provided for this image

Inphinity.app is the world’s first SaaS BI app store and deployment platform which is fully self-service and offers plug-and-play Data & Analytics. Customers can get qualified insight into their data using relevant D&A solution in minute and higher value from data analytics than if done in a traditional way. Also, both partners and customers can share and monetize their data and knowledge.

Not only for the large companies

The monetization or empowering of the customers or suppliers is not just a domain of large organizations. Using the efficient platforms such as Inphinity.app, also the small and medium businesses can start to monetize their data or knowledge and create a new revenue stream, which can be substantial in the future.

So, no matter what industry, size or type of organization, monetization and getting better results through empowering the customers, suppliers or partners can achieve unprecedented results.

And how about you? Are you currently thinking about monetizing using data analytics? Are you empowering your customers or suppliers?

Remember, if you do not disrupt your business, somebody else will.*

*Thanks to the Singularity University for teaching me this ;)

The implementation of Sales Planning in Forms took us just 4 weeks – incredible achievement compared to our previous planning solution in Excel, which took us months to build.– JEFF BROWN, General Manager Supply Chain, Mayo Hardware.

 

Australian retailer Mayo Hardware is managing its Sales Budget Planning in Forms, a Qlik Sense write-back extension designed by our partner. Read the story of one of the first Forms implementations in the world.

Download the full success story below.

As in previous years, Qlik’s front-end products achieve an impressive set of results in The BI Survey 19 with 5 top-rankings and 68 leading
positions. Qlik Sense takes two number one spots and 48 leading placements while QlikView achieves 3 number ones and 20 leadership positions.

Qlik Sense offers customers fast query performance and innovative features to implement trending use case scenarios.

QlikView is seen as a solid product that provides good dashboards and analysis functionality as well as the level of performance its customers require. Like Qlik Sense, QlikView’s strong rating in the ‘Business value’ KPI underlines Qlik’s ability to listen to customer needs and fulfill their requirements.

View Fullscreen