Qlik Sense

// Conexão com SQL Server
ODBC CONNECT TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorks;Data Source=localhost];

// Carregamento de tabela de vendas
Sales:
LOAD
    SalesOrderID,
    CustomerID,
    ProductID,
    OrderDate,
    SalesAmount,
    Quantity,
    Year(OrderDate) as Year,
    Month(OrderDate) as Month,
    'Q' & Ceil(Month(OrderDate)/3) as Quarter
FROM AdventureWorks.dbo.Sales;

// Carregamento de dimensão de produtos
Products:
LOAD
    ProductID,
    ProductName,
    Category,
    SubCategory,
    UnitPrice
FROM AdventureWorks.dbo.Products;

// Carregamento de dimensão de clientes
Customers:
LOAD
    CustomerID,
    CustomerName,
    City,
    State,
    Country,
    Region
FROM AdventureWorks.dbo.Customers;

// Total de Vendas
Sum(SalesAmount)

// Vendas Ano Anterior
Sum({} SalesAmount)

// Crescimento %
(Sum(SalesAmount) - Sum({} SalesAmount)) / 
Sum({} SalesAmount)

// Top 10 Produtos
Sum({} SalesAmount)

// Vendas Acumuladas
RangeSum(Above(Sum(SalesAmount), 0, RowNo()))

// Média Móvel 3 meses
Avg(Above(Sum(SalesAmount), 0, 3))

// Percentual do Total
Sum(SalesAmount) / Sum(TOTAL SalesAmount)

// Conditional Formatting
If(Sum(SalesAmount) > 1000000, Green(), 
   If(Sum(SalesAmount) > 500000, Yellow(), Red()))

// Engine API - Conectar a app
const enigma = require('enigma.js');
const WebSocket = require('ws');

const session = enigma.create({
    schema: schema,
    url: 'wss://localhost:4848/app/engineData',
    createSocket: url => new WebSocket(url)
});

// Abrir app
session.open().then(global => {
    return global.openDoc('Sales Analysis.qvf');
}).then(app => {
    // Criar objeto
    return app.createObject({
        qInfo: { qType: 'chart' },
        qHyperCubeDef: {
            qDimensions: [{ qDef: { qFieldDefs: ['Product'] } }],
            qMeasures: [{ qDef: { qDef: 'Sum(Sales)' } }]
        }
    });
});

// Repository API - Listar apps
fetch('https://qlik-server/qrs/app', {
    method: 'GET',
    headers: {
        'X-Qlik-xrfkey': 'abcdefghijklmnop',
        'X-Qlik-User': 'UserDirectory=DOMAIN; UserId=user'
    }
}).then(response => response.json())
  .then(apps => console.log(apps));

// my-extension.js
define(['qlik', 'jquery', 'd3'], function(qlik, $, d3) {
    return {
        definition: {
            type: "items",
            component: "accordion",
            items: {
                dimensions: {
                    uses: "dimensions",
                    min: 1,
                    max: 1
                },
                measures: {
                    uses: "measures",
                    min: 1,
                    max: 1
                }
            }
        },
        paint: function($element, layout) {
            // Limpar elemento
            $element.empty();
            
            // Criar visualização D3
            const data = layout.qHyperCube.qDataPages[0].qMatrix;
            const svg = d3.select($element[0])
                .append('svg')
                .attr('width', $element.width())
                .attr('height', $element.height());
                
            // Implementar visualização customizada
            svg.selectAll('rect')
                .data(data)
                .enter()
                .append('rect')
                .attr('x', (d, i) => i * 50)
                .attr('y', d => 200 - d[1].qNum)
                .attr('width', 40)
                .attr('height', d => d[1].qNum);
        }
    };
});