• 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
  • 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
  • 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 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
  • 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
  • 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
  • Controlling Colours in Charts

    Controlling Colours in Charts - YouTube   There are four major places to control colour in QlikView charts properties.  They are found in the following locations in the chart properties dialog:   Colors...
    Josh Good
    last modified by Josh Good
  • Date Selections - By Period & Range

    20/2/2014 - The QVW has been updated to set the min and max dates to match the date range in the data and to prevent selecting an end date prior to the start date, and some of the action buttons have been revised. &nb...
    Colin Albert
    last modified by Colin Albert
  • Improving Image Quality Export using Clipboard Zoom

    Greetings,   For the longest time, I have been trying to improve the quality of an exported image out of Qlikview.  Sometimes my end users want to just copy an image to the clipboard and paste it into an e-...
    Mattias Malre
    last modified by Mattias Malre
  • QlikView App: At The Qlik Of A Button

    This example has been produced to accompany the blog post QlikView Buttons, When, Why and How.   The shared QlikView demonstrates how actions can be attached a number of different types of objects and used to na...
    Steve Dark
    last modified by Steve Dark
  • Turning Unoptimized Loads into Optimized Loads

    I wanted to share a couple of test I did on trying to get loads to be as fast as possible and hopefully get some feedback or some other tips.   Sorry for the long post I believe it's worth reading through.  ...
    John Trigg
    last modified by John Trigg
  • 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