Technology Partners Ecosystem

🗽📈✔ Actionable analytics in Manhattan! Interested?

📆Register for the upcoming webinar and get inspired by how Waterfall Asset Management LLC,  is taking action where the data is:

🔶Business areas covered with Qlik in the company
🔶Portfolio management - showcase
🔶Workforce management - showcase
🔶Other use cases and future plans

Global Webinar | ​​​​​​​Waterfall AM, NYC: Inphinity Forms In Financial Services 

Shamanth Muppidi, John Pak, Sean Price, Martin Kostic are looking forward to answering your questions during the live Q&A session. The webinar will be available on-demand on the same link afterward.

Enjoy Forms 🤩,

Maria Sandorova

AnyChart is now a Qlik Technology Partner!

Join us in our new venture! Our award-winning data visualization library is available as extensions for Qlik Sense! (Read more in our blog.)

If you're attending Qonnections in Dallas May 13-16, 2019, please stop by Booth 132 and let us know what you need. If you're not attending, please email us at support@anychart.com with your requests.

UPD: For a quick reference, here's a list of chart types currently available in AnyChart's Qlik extensions:

• Area Chart
• Bar Chart
• Barmekko Chart
• Box Chart
• Column Chart
• Donut Chart
• Donut Chart 3D
• Error Chart
• Funnel Chart
• Gantt Chart:
  
  • Project Chart
  • Resource Chart
• Gauge:
  
  • Linear Gauge
  • Circular Gauge
  • LED Gauge
  • Tank Gauge
  • Thermometer Gauge
• Heatmap Chart
• Line Chart
• Mekko Chart
• Mosaic Chart
• Percent Stacked Charts:
  
  • Area
  • Bar
  • Column
  • Radar
• Pie Chart
• Pie Chart 3D
• Pyramid Chart
• Quadrant Chart
• Radar Chart
• Sankey Chart
• Scatter Chart
• Stacked Charts:
  
  • Area
  • Bar
  • Column
  • Radar
• Stock Chart (available series - Area, Candlestick, Column, Line, OHLC, Spline, and Spline Area)
• [NEW!] Sunburst Chart
• Timeline Chart
• Treemap Chart
• Waterfall Chart
• Word/Tag Cloud

If you need more charts, let us know.

🤩 The newest version of Inphinity Forms write-back extension is a demonstration of creativity with added value!

What's new?

✔ New field type: upload a file!

✔ Inputs validation before saving

✔ Improved Qlik-style design

✔ New field type: color picker

✔ Adding new rows

✔ ...and so much more you really should try it

Unique new ideas came not only from our team – many of you shared interesting suggestions on how to improve your favorite write-back extension for Qlik. Thank you!

More information, references, webinar, our client's success story, and trial download are available on the webpage.

If you want to get technically inspired watch my video series about Inphinity Forms Tech Tuesday

Enjoy Forms 😉,

Maria Inphinity Sandorova

🎯✍📢 Let’s explore how you can enhance the capabilities of your Qlik in many different ways with one extension!

We will walk you through the disrupted business intelligence process by using Qlik and Inphinity Forms together in different Qlik applications.

Hey Qlik users! We at AnyChart, a trusted Qlik Technology Partner, have recently launched a series of video tutorials designed to explain how to create real Gantt charts in Qlik Sense using the AnyGantt visualization extension — still without any technical knowledge and with the same ease and simplicity you've come to expect from Qlik.

At the moment, we already have 6 such Qlik tutorials on YouTube. For your convenience they are embedded below. We're going to keep this thread here updated as new videos are out. However, we advise you to subscribe to our channel on YouTube and turn on the bell to get timely notifications on the new stuff.

Here's a quick list of the available tutorials. Then, without more ado, check out the videos and let us know in the comments if you need any further assistance.

1. Quick Start - How to Create a Gantt Chart (3:28)
2. Adding Dimensions & Measures in Project Gantt Charts (4:12)
3. Configuring Labels in Gantt Charts (5:14)
4. Downloading and Installing AnyGantt Extension in Qlik Sense Desktop (1:31)
5. Downloading and Installing AnyGantt Extension in Qlik Sense Server (1:30)
6. Coloring a Project Gantt Chart (6:13)

1. Quick Start - How to Create a Gantt Chart (3:28):

2. Adding Dimensions & Measures in Project Gantt Charts (4:12):

3. Configuring Labels in Gantt Charts (5:14):

4. Downloading and Installing AnyGantt Extension in Qlik Sense Desktop (1:31):

5. Downloading and Installing AnyGantt Extension in Qlik Sense Server (1:30):

6. Coloring a Project Gantt Chart (6:13):

Forms is a self-service Qlik input extension already certified as Trusted Extension (TED). It allows you to enter your own inputs directly in Qlik Sense: comments, deadlines, responsibilities, custom categorizations, action plans, rankings or any other data. Thanks to Forms you can also comment Qlik visualizations and share your insights with your team. For more information click here.

All the settings of Forms are done by using Qlik native features. So, a combination of Qlik and Forms opens a new universe of possibilities. And since I really like pushing limits of imagination, I decided to share my thoughts with all of you. Forms TechTuesday is a weekly video series about tips&tricks on how to implement Forms within Qlik Sense in an even more creative way! 

Already available:

✔️ How to use more dimensions as a key: watch here

✔️ Optimize what is shown to users - conditional fields: watch here

✔️ Do you think there is only one way how to define the dropdown menu?: watch here

Enjoy Forms!

Maria Sandorova

📈And VOILA! 💥Meet Vizlib Templates – the easiest way to establish visual governance in Qlik Sense, accelerate app development 🚀and drive consistency across your dashboard designs. Save your chart configurations, colors and formatting for later, or for re-use by the rest of your team. 🙌

Vizlib Templates

With approved company templates for various charts, striking a balance between aesthetics 🎨and effectiveness is as easy as pie.

👉Rolling out to the Vizlib KPI Designer, Vizlib Sheet Menu, Vizlib Slider & Vizlib Container Grid. ➕ REST to come soon!

To get started and try it for yourself, download for free here: https://www.vizlib.com/protected/downloads

For more info, watch these awesome 🎥 videos:

#QlikSense #Vizlib #dataviz #GuidedAnalytics

Hello Experts,

Do we have example that shows  how to use vizlib cards to display images for each record in the data? In my use case I have  >5k records and each record has http link of image in  one of the column, say Image_Link column. When I am trying to display the images using Climber Cards, it asks for dimension and measure. I gave id column in dimension but I am not sure what should I provide in measure field and how will it render images for each of the records?
Any idea is appreciated.

Thank You,

              Top 5 data visualization best practices you need to remember

Data visualization can save us from drowning. The tsunami of data that floods our daily lives is on the rise. By 2025 we can expect up to 463 exabytes of data to permeate our daily existence! (Bear in mind that 1 exabyte = 1,000,000,000,000,000,000 bytes!)

Data visualization is the life-preserver we need to manage the heavy-data load, since human processing power falls slightly short of machine learning speeds! Humans do, luckily, respond to and process visual data faster – up to 60 000 times faster than text. The visual medium is natural to us. As a result, businesses can use data visualization to break down vast complex data into bite-size chunks we can understand at a glance.

And there’s potentially more to the subject, a recent Forbes article observes: “Data analysis isn’t just about assembling, ordering and interpreting data; it’s also about educating, simplifying, clarifying, and persuading.”

This raises an important point—persuasion. A visualization needs to be informative but it should also persuade people to take a particular action or decision. The decision may pertain to everyday business or something that affects people on a global scale, like climate change awareness. The bottom line is, data visualization has the power to change people’s perception.

Creating a visualization that steers business decisions or changes the world, begins with a few basics. Here are five best practices to consider when you craft your next visualization:

1. Communicate to a specific audience

When you’re designing a data visualization, you need to know the specific audience you’ll be communicating with. Knowing this helps you to aim the data story at them and speak to their specific needs. Aim it at the highest level persona who will view the visualization and make sure their needs are covered and the common roadblocks they encounter.

Creating a visualization that communicates with a broad audience may result in it being ineffective and could reduce the likelihood of extracting key business insights.

Once you’ve established who your audience is, consider what decision you want them to make from the data. And the nature of their decision. Different roles or functions in a business make decisions differently. C-level executives tend to make strategic decisions. These are usually one-off type decisions. Whereas an Operations Manager has to continually make decisions based on daily operational choices.

Illustration credit: Olia & Roma

Taking into account these decision-making elements, you can then align the data visualization accordingly. Strategic decision-making may require more complex visuals, while for operations, a binary-type interface would suit simple yes-no decisions. The time scale should also be adjusted to display a scale relevant to the decision type.

Now that we’ve got the audience nailed down, let’s look at the visual aspects involved.

2. Choose the best visual

It’s important to choose a visualization that will communicate the right message to your audience. When you’ve got this covered, your audience will quickly understand your point and extract the insights they need.

Each type of visualization works best with a particular data type. These data types could include:

1. Categorical data, also called qualitative data, represents characteristics like a person’s gender or age and is non numeric. 
2. Ordinal data is a sub-category of categorical data. Ordinal data is also non-numeric but the order of the data matters like in surveys or questionnaires. 
3. Quantitative data, also called numerical data, is measured in numbers, like length or revenue.

Let’s take a look at the visuals that pair with these data types.

• Tables can display large quantities of data, categorical or quantitative. If the audience only needs to see a high-level view of the data, the table format may be overwhelming.

Vizlib Table

• Bar charts measure categorical or quantitative data and are a good way to compare the quantities of different categories.

Vizlib Bar Chart

• Line charts use ordinal or quantitative data. They track change over time and the relationship between two variables.

Vizlib Line Chart

• Area charts measure ordinal, categorical or quantitative data. They are similar to line charts, with the area beneath the line shaded in.

• Pie and donut charts demonstrate categorical data. They show the comparison between the parts of a whole. Make sure you label the individual wedges so it’s clear which pieces are larger. And don’t compare two pie charts alongside each other that have different totals!

Vizlib Pie Chart

• Scatterplots reflect quantitative, ordinal or categorical data and show the values of two variables against two axes. The pattern of the results shows the relationship between the variables. You can also demonstrate the relationship by the size of the data bubbles.

Vizlib Scatter Chart

• Heatmaps measure categorical and quantitative data. They show a graphical representation of data with individual values represented by a specific color.

Vizlib Heatmap

3. Use proper design principles

It’s imperative to keep the dashboard simple and uncluttered. Much like any visual presentation, too much clutter will disperse the viewer’s attention and leave them feeling confused and frustrated. They should be able to grasp the high-level meaning of the visualization at a glance if you adhere to a few basic design principles.

Create digestible designs

Firstly, the design must be digestible – quick and easy to understand. Keep the design clean. Instead of trying to jam too much into one visualization, rather create an additional object. Another way to limit the clutter and deliver a better user experience is to include alternative dimensions and measures.

Secondly, consider adopting every good designers’ passion for white space. White space, or the space around objects, gives the eye a rest and allows your focus to fall where it should, on your visualization objects. It allows the viewer to understand what they see more easily and creates a better user experience!

Image credit: storytellingwithdata.com (showing the power of white space)

  Managing color

Color usage is an important design factor in visualizations. Use colors to differentiate visual elements and make your data story as clear as possible. You could combine colors and shapes for your indicators, like a green empty triangle and a red full triangle, for additional visual clarity. Perhaps try using different line styles and different colors with your line graphs. And remember to use a palette that is color-blind friendly to ensure there are no accessibility issues with your visuals. If you’d like to learn more about selecting the ideal color palette, read our guide here.

Visual layout

The layout of visualization elements, like icons and filters, should enhance learning. Ensure you position them in a way that reflects the correct hierarchy of information.

Placing them on the left-hand side of the dashboard is a good idea as users look to the left first for important elements like filters or navigation tiles. The further right you place objects, the less attention the viewer pays to them. The best layout of the main filters or icons is stacked vertically on the left.

A horizontal arrangement is also workable. Placing icons or filters on top allows more space for visualizations. Note that viewers will consider the first icon in the horizontal display as the most important.

Together with positioning, you could also show the importance of data by the size of the chart or text. Make the key objects larger to draw the audience’s attention.

Maximizing understanding

Lastly, the design should maximize understanding and provide a great user experience that is not overwhelming. You could implement this principle by labeling data directly, rather than using a legend and including annotations on your visualization. And, only include visualizations that serve a purpose. This will cut down on distractions and allow the viewer to focus on the key message in your data.

Image credit: storytellingwithdata.com

  4. Provide context for the visualization

The most effective data story-telling always contextualizes the data. Contextualizing refers to showing the bigger picture, the story that surrounds a situation. Framing the data, by including context like annotations, makes it easier to understand. When viewers grasp what they’re seeing, they can interpret it correctly. As a result, you establish their trust.

It’s vital that business leaders understand visualizations at a glance and trust the insights to make their recommendations. Once trust is established, they’ll be more likely to take the action you want them to.

You can contextualize data by comparing your metrics to something tangible like a goal. If you can present metrics in comparison with dynamic thresholds, it’ll make the data easier to interpret.

An additional way to provide context is by including annotations. Annotations, like text labels, tooltips or icons, are visual cues for the viewer and make the visualization quicker and easier to grasp. Annotations help explain large shifts or changes in the metrics. They will also help the viewer stay focused on the visualization's main message.

Vizlib Line Chart with annotations

5. Avoid common pitfalls

Applying best practices will help you master your data visualization skills. And by avoiding common pitfalls you’ll be well on your way to even more effective data story-telling. Look out for these potential glitches when creating or collaborating on visualizations:

• Avoid using too much color. Stick to the fundamental rule—keep it simple. Simplicity leads to understanding and keeps your audience on board.
• Don’t try to embellish the data. Make sure it is transparent.
• Ensure the data is correct! And that the parts add up to the total figure.
• Label the data correctly to avoid confusion and losing your audience.
• Don’t truncate a graph’s axes as it may distort the data representation and minimize the impact of your message.

Data visualizations should be simple and persuasive. Follow these best practices to shape the mind of your audience! You’ll be empowering them to take insightful action in their business or perhaps to change the world!

Here are a few additional examples of Vizlib data visualizations.

Vizlib data visualization dashboards

Get started with a free Vizlib trial!

Hi Team, 

I have a below data set:

ID, Sales

A, 100

B,100

C,200

D,300

E,400

I want the below output in front end table:

ID, Sales, Number

A, 100, 1

B,100, 1

C,200, 2

D, 300, 3

E,400, 4

The above number column should be dynamic .

Thanks in Advance

🔥 Hey everyone, we're delighted to present a special video tutorial that shows how to easily create a Gantt chart using our AnyGantt extension for Qlik Sense.

 ▶️ The video is only 3 minutes — watch it now on YouTube!

See how easy it is to make Gantt charts in this intuitive way.

🤙 Your company has project/resource information to visualize? Go ahead, book a demo call. We'll be happy to discuss your unique business needs, set up a prototype, and demonstrate how to use the AnyGantt extension with your data.

Hey Qlik Community! 👋

Planning to attend one of the upcoming #DataRevTour events? We'll be there and ready to show you the latest and greatest additions to the Vizlib product family. Connect with Martin Mahler, David Alcobero, Joe Warbington, Jonathan Israel, Michael Nordström, Assja Octavia von Kraft or Giuseppe Lolli to put something in the 🗓️.

Qlik Data Revolution Tour Dates with Vizlib

Click to register!

[Chicago] [London] [Toronto] [Milan] [Madrid] [Arlington] [Stockholm] [San Francisco] [New York]

http://bit.ly/VizlibDataRevTour

Vizlib builds powerful value-added products for Qlik Sense. Our feature-rich, intuitive Qlik Sense solutions empower data-driven organisations to extend their current analytics capabilities and uncover meaningful insights faster than ever before.

Our products include:

• Vizlib Library - designed for pixel-perfect dashboards and visual analytics
• Vizlib Self-Service - designed for ad-hoc data exploration and reporting
• Vizlib Finance - designed to deliver unbeatable P&Ls and Balance Sheet reports
• Vizlib Collaboration - a brand new way to bring people and data together

Start building visualizations that make data talk.

• Free trial license for up to 5 users.
• Try any or all Vizlib extensions for free.
• Hands-on support during the trial.

See why data-driven organisations around the world are raving about Vizlib. It’s free, fast and phenomenal, so why not? Learn more and start your trial at vizlib.com

Dear members,

I am working on a new requirement and need to connect Qliksense and Qlikview to Azure Data Lake Store Gen 1.  I  search a lot about it but didn't find any useful information to claim the connectivity betweem Qlik and Microsoft Azure Data lake. 

If any one has worked on it or have any information please share that with me. It will be really helpful.

Thanks in advance.

Regards,

Piyush Jain