• Load latest Excel file to Qlikview

    Hi All,     The below script helps you in loading the latest data from the given folder based on the filename.  The below script helps you in loading the latest year automatically   Example: File...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • Steps for beginners to implement Google Maps in Qlikview

    Find the attachement to implement google maaps in qlikview. Documents with screenshots are avail. Attached the QVW file also for your reference. Regards. Siva Sankar k I've re-edited the document  and fixed the&...
    sivasankar kanagasabai
    last modified by sivasankar kanagasabai
  • Qlikview Parameterised Variables

    The Qlikview Variables are quite cool and they can be used as little functions too. For example, the below variable declaration gives the flexibility to use any simple aggregation functions on any fields in the model ...
    Sasidhar Parupudi
    last modified by Sasidhar Parupudi
  • Do you Qualify?- How to use QUALIFY statement

    What it is used for? The Qualify statement is used for switching on the qualification of field names, i.e. field names will get the table name as a prefix.’   In situation where we have two (or more) Ta...
    Robert Mika
    last modified by Robert Mika
  • QvM - Color Management

    "How to reduce time to set up and manage the colors of your dashboard and start creating business value faster?"   Imagine there would be a module that could help set up and manage the colors for your dashboard ...
    Koen Bal
    last modified by Koen Bal
  • QvM - AdHoc table

    The AdHoc table module provides an easy to setup AdHoc table (aka lego table). The dimensions and expressions are managed in the QVMeta_Dashboard excel which is part of the Documentation Module. The possibility to add...
    Koen Bal
    last modified by Koen Bal
  • Data speaking to you

    NLG (Natural Language Generation) is a task of Natural language processing which helps in generating natural language from a machine representation system. It is a translator which converts a computer based representa...
    Sampada Bhumralkar
    last modified by Sampada Bhumralkar
  • How to use- Dual()

    Have you ever wonder how the examples from the Qlikview help may look like? Please see below and enjoy responsibly...   Dual()   Definition: Forced association of an arbitrary string representation s with a...
    Robert Mika
    last modified by Robert Mika
  • Mini Bar Chart inside Straight Table and in List Box

    Hi,   Created a simple document with steps on creating a Mini Bar Chart inside Straight Table and in the Listbox. Hope it helps for the beginners. Your comments are welcome.   - Siva Sankar
    sivasankar kanagasabai
    last modified by sivasankar kanagasabai
  • One Table to Rule Them All

    Introduction   In Business Intelligence and data science there has always been this debate about whether a star schema is better than a snowflake schema or vice versa. This post, is not about that argument. This ...
    Thabang Petje
    last modified by Thabang Petje
  • Qlik Sense Waterfall Chart with Bar Chart (without extension)

    A simple approach to get a waterfall chart with a bar chart. Using an offset segment that is set to white and a little bit logic in the load script to be able to read a straight-forward data table.  
    Petter Skjolden
    last modified by Petter Skjolden
  • Dynamic KPIs

    Sometimes, when you have less space in Dashboard and you have much information/KPIs to show OR If you want to let user to select what specific information he wants to look at rather than pouring all information in das...
    Kamal Kumar Sanguri
    last modified by Kamal Kumar Sanguri
  • Set Analysis for Rolling Periods

    Hi All,   Sometimes there may be requirements from users where they want to see the charts by rolling periods based on the selected periods, please check below for various scenarios.   Note: The format defi...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • New to QlikView Videos

    These videos help you get started with QlikView and provide the basics you'll need to begin creating your own QlikView apps.   Getting Started with QlikView Series Video 1: Download and Install QlikView Persona...
    Michael Tarallo
    last modified by Michael Tarallo
  • Set Analysis: syntaxes, examples

    For those that find this document in a search - you may also want to check out these videos to learn Set Analysis:   A Beginners' Introduction to Set Analysis (video)   About the attached document:   ...
    Michael Tarallo
    last modified by Michael Tarallo
  • Calculation of MTD, YTD, QTD, WTD in script level - The As-Of table concept - MTD, YTD, QTD, WTD calculation made easy

    Hi, I have prepared a script that will calculate the MTD, YTD, QTD, WTD without using complex set analysis using the As-Of table concept.   Also from my script various types of calculations can be made like cur...
    sandip Ghosh
    last modified by sandip Ghosh
  • Qlikview Learning: General topics with Examples and Help Material

    Attached the documentation , examples and learning material which i have collected over the years. It will help everyone in the community. Some of the files are from community itself. But re posting them so that every...
    Vinay kumar Bangari
    last modified by Vinay kumar Bangari
  • QlikView Interview Quesitons.pdf

    Dear All,   Most frequently asked questions in QlikView interview. Kindly, find attached document.     Kind regards, Ishfaque Ahmed
    last modified by ISHFAQUE AHMED
  • Useful Qlikview Macros

    Hope the below macro scripts helps beginners Source : QlikView Macros – Useful collection | Lucian Cotea   1) Run external program: FUNCTION RunExe(cmd) CreateObject("WScript.Shell").Exec(cmd) END FUNCTION...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • F1 Data of Formula 1

    Hello everyone, We attach a file with data QlikView history of Formula 1 from 1950 to today. Not particularly bright in terms of presentation, but if you have enough information that Formula 1 fans will surely appre...
    Enrique Colomer
    last modified by Enrique Colomer