Using Datama Solutions as a Qlik extension is a great way to make your report more insightful with the benefits of both Datama and Qlik.


1. Overview

This document provides detailed documentation for the “Datama Compare - Smart waterfall” Plugin, a powerful extension for Qlik. This plugin enhances data analysis capabilities by explaining performance variations with easy to understand data visualization graph.

Watch this video to properly understand our extension and how to use it.


2. Features

  • Multi-view workspace: Waterfall and smart comment pinned side by side by default, with optional table and tree views.
  • Smart Scoring Engine: Automatically identifies and displays key factors that explain performance variations, simplifying complex data.
  • Mix Effect Analysis: Assess the specific impact of Mix effect on your performance metrics.
  • Intelligent Comments: Convert data analysis into smart, actionable insights; narrative stays in sync when you drill or Split by.
  • Interactive Charts: Zoom, click, filter, dimension drill-down, custom pillars, and a richer right-click menu (bars and labels).
  • Side settings panel: Configure Comparison, Modeling, Market Equation, Chart, Colors, Waterfall, Tree, and Table next to the viz (Apply vs live).


Tip of the Week 130: Customize comments in your Datama extension!

✨ Want to add your personal touch to comments while interpreting comparison analytics from the Datama extension in Looker Studio, PowerBI, or Tableau? 🤔 Yes, you can! 🌈 Say goodbye to default comments and hello to your custom insights below the waterfall chart ! 🎉

Only 4 steps to get it done:

  1. Right-click on the sentence you’d like to modify and select “Edit Sentence” to open the settings panel.
  2. 📝 Edit the relevant text in the left coding panel. Check out your changes with a 📺 live preview on the right!
  3. When ready, ✅ click “Apply” at the bottom right to save your changes and see the update instantly.
  4. Need to Reset? Click “Reset” (left of “Apply”) to return to the default style if you want to start over or if an error pops up.

Advanced customization: Click “+Available Variables” for even more options!

🎥 See below our GIF guide for a step-by-step walkthrough.

📊 Make your Datama Extension uniquely yours! Humanize your analytics tools and bring clarity to your data insights!

Tip of the Week 130: Customize comments in your Datama extension!


3. Add the extension into your report

3.1. Add the extension to your list of Qlik extensions

In order to use Datama in your report, you first need to add a new extension to your Management Console.

To add the Datama extension to Qlik Sense Online, follow these steps :

  1. Open your Management console
  2. On the left side panel, click Extensions
  3. Click on the Add button on the top right of the page
  4. Then browse your file and add the extension
  5. Finally, click Upload



3.2 Add the extension into your app

Follow these steps to add Datama in your app :

  1. From the Analytics Services page, open your App
  2. Click on the sheet you want to use Datama on
  3. If you are not in edit mode, click on Edit sheet
  4. Make sure Advanced options is turned on
  5. On the Assets panel on the left, click Custom objects
  6. Click on Extension
  7. Drag and drop the Datama extension in your sheet



4. Get a free trial period

You can get a free trial period of 7 days allowing you to test the full version of the extension by following these steps :

  1. Click on “Trial version” link of Datama footer
  2. Click on “Upgrade”
  3. Create your Datama account
  4. Get your Trial extension with no engagement, and no credit card required


5. Getting started

Once you’ve imported the extension, here is how you can use it.

1. First think at your use case: You need first to consider which KPI you want to analyse and what are the steps that lead to the main KPI.

2. Prepare your dataset: 4 steps are needed to properly set your dataset.

  1. Main KPI: Define the main KPI you want to compare (e.g. Revenue, Leads, Margin…)
  2. Comparison Dimensions: Define on which elements you want to compare your KPI (e.g. Period: Compare Month over Month, Country: Compare one country to the other…)
    • by default, Datama will select the first two elements of your dimension, or split a date range in two.
  3. Steps: Define the steps that correspond to the funnel that lead to your main KPI. For example (eCommerce funnel, or Finance funnel) See dataset examples
    • To better defined your steps (or metric equation), you can read our dedicated article.
  4. Explanation dimensions: Add Dimensions that will be used to explain the variations of your performance. Each variation will have an interest score to see how important they are to explain your variations.



3. Custom settings: Open the side settings panel next to the chart (collapsed by default on Compare). Use the icon rail to jump between Comparison, Modeling, Market Equation, Chart, Colors, Waterfall, Tree, and Table. Analysis changes require Apply; chart and visual options update live.

4. Save settings: If you have a paid licence, settings will be automatically saved along with your dashboard. O

5. Leave edit mode: In the Qlik side panel, in the “Datama Setting” tab, untick the “Edit mode” toggle. Dashboard viewers won’t see the top header and footer anymore, for a smoother experience.


6. Read your Analysis

  • Performance Overview: Each blue bar represents the performance of your main KPI, using your chosen comparison dimension. helping you quickly gauge performance across different segments.
  • Intermediary Step Analysis: Intermediary steps depict the ratio evolution of your KPI. The impact is quantified in the units of your main KPI, allowing for a consistent measurement of progress or regression.
  • By default, the most interesting dimension will be selected for this zoomed step. Right-click a bar or a value / top-line label, then use Split by to change dimension. Drill up or click another step to leave the zoom.
  • In-depth exploration: Click a step to open the strongest drivers. You can pin the Table or Tree view, add custom pillars, and keep comment / title in sync with the active split.

To discover more about how to read Waterfall, you can read our dedicated section


7. Advanced Usage

Follow this link to get the full view of the extension Settings.


8. Get more insights

Explore related documentation to understand how to generate insights in Datama Compare


9. Support and Resources

If you require assistance or have any questions, feel free to reach out. We’re here to help!

  • 📧 Email: Send us an email at contact@Datama.fr for any inquiries or support issues.
  • 🌐 Contact Form: Prefer to use a form? Fill out our online contact form, and we’ll get back to you promptly.