• Peek() or Previous() ?

    This article was sparkled by this discussion thread on Qlik Community. The question was: how to calculate the difference between dates that are stored in consecutive rows of a table? Three answers to the question sugg...
    Oleg Troyansky
    last modified by Oleg Troyansky
  • Section Access

    How could I make sure that certain data are only for certain users available?   The answer is SECTION ACCESS. Section access is a connection between an authorization table (commonly placed in a hidden script and...
    Marcus Sommer
    last modified by Marcus Sommer
  • JSON Loader

    Hey,   I hope I can solve a lot of peoples headache with a better way of loading JSON data.   This method works by loading the JSON data into an table with a single field, and then placing it into a variab...
    Torben Seebach
    last modified by Torben Seebach
  • iFrame Integration Example

    Have you ever wanted to display QlikView content in a thrid party application? I was recently asked for a simple way of doing this, and found myself quite surprised how simple it actually was.   The brief was to...
    John Trigg
    last modified by John Trigg
  • multi_header_pivot_import.qvw

    This example qlikview document can help you load excel files that contain a pivot table with multiple horizontal headers (dimensions) like in the image below: The instructions on how to use this documents can be fo...
    Gysbert Wassenaar
    last modified by Gysbert Wassenaar
  • QlikView and Salesforce.com Single Sign On

    Introduction  SalesForce.com provides a cloud based solution for CRM and other systems. QlikView provides a connector to be able to extract data entered into Salesforce.com for analysis and discovery.  This...
    Joe Bickley
    last modified by Joe Bickley
  • Sheet level access

    Hi,   This document helps in implementing Sheet level access based on the user using Section Access.  I configured four users A, B, C and D and no password is required to login.   If you login as A, th...
    Koen Bal
    last modified by Koen Bal
  • QlikView 12 Application: System Monitor

    A derivative of the QlikView System Monitor for versions 10/11, finally the QlikView 12-compatible version has arrived. The UI has undergone some changes and the structure/setup has been simplified. This application w...
    Michael Terenzi
    last modified by Michael Terenzi
  • QlikView Scheduled & Automated Reports – Sending Excel via Email

    Hello everyone!   Higher management often requires specific data delivered to their mailbox every morning. They are not interested in interaction, using filters and “playing” with data. They just wan...
    Jakub Szurogajło
    last modified by Jakub Szurogajło
  • Useful Qlikview Shortcuts

    Dear All, I hope, everyone enjoy the Qlikview through useful shortcuts. Please find attachement. Kind regards, Ishfaque Ahmed
    ISHFAQUE AHMED
    last modified by ISHFAQUE AHMED
  • More advanced topics of qlik datamodels

    Beyond the basics of data modelling and the advanced topics of qlik datamodels there are more things which you might need if the amounts of data are increasing or if your datamodel is more complex. This meant if you h...
    Marcus Sommer
    last modified by Marcus Sommer
  • Calendar with flags making set analysis so very simple

    NOTE: A more recent version with added functionality can be found here: Calendar with AsOf Flags, Compare Easter to Easter   Hello   Calendars are one of the first things developed when working with Qlik a...
    Richard Pearce
    last modified by Richard Pearce
  • Script for Storing/ Dropping Table with Exceptional list

    Problem Statement: Always tedious task to maintain drop table statement for all existing table of any Application. Below script handle table list which should be there even if there is drop statement. At the end of ...
    Ravi Balar
    last modified by Ravi Balar
  • Set Analysis - Análisis de conjuntos (en Español)

    There are many documents and notes which talk about Set Analysis, but until the moment I started to write this manual I didn´t find any in Spanish, so I decided to write it. Most of it is based on translated ada...
  • Dynamic Tables and Graphs

    Dear community,   When I started with QlikView, I wanted to replicate what I knew before. One good thing was the possibility to choose the dimensions and measures that compose the table or graph. It is not comp...
    Fabrice Aunez
    last modified by Fabrice Aunez
  • How to use - MaxString & MinString

    Bullet points: MaxString and MinString belongs to Qlikview String Aggregation function. They are equivalent to MAX and MIN for integers They return the highest and lowest string value   What actually a value o...
    Robert Mika
    last modified by Robert Mika
  • Missing Manual - Before() and After()

    Have you ever wondered how the examples from the Qlikview help may look like? Please see below and enjoy responsibly...   Before () and After()       Description Returns the value of expressio...
    Robert Mika
    last modified by Robert Mika
  • Qlik Developer Toolkit

    This is the Qlik Developer Toolkit created by Demo & Best Practices at Qlik.   The Developer Toolkit contains several assets to help speed up the development process while still creating beautiful, usable an...
    Alexander Karlsson
    last modified by Alexander Karlsson
  • QlikView How To (or Tips & Tricks) Application

    Some time ago I began an application designed to work as a general "How To" or "Tips & Tricks" document for QlikView developers. Up until now (9/12/2013) I have not made it available on community, which is somethi...
    Lee Matthews
    last modified by Lee Matthews
  • Human Body Parts Graph

    A picture is worth a thousand words, and this is even more true in BI. With this in mind, it came to me this solution for representing accidents in a plant in a QV document, as one of the most important issues for red...
    IOSU GARCIA
    last modified by IOSU GARCIA