• 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
  • 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 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
  • 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
  • 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
  • Missing Manual - Map...using

                  Have you ever wondered how the examples from the Qlikview help may look like? Please see below and enjoy responsibly...   Map...using or ...
    Robert Mika
    last modified by Robert Mika
  • Master Calendar with movable holidays

    Beside the main-use of a master-calendar to create various date-clustering fields like week, month, quarter, year and similar to the date-values could be an extended use the calculation of working days. Of course you ...
    Marcus Sommer
    last modified by Marcus Sommer
  • Inter-Record Functions

    Inter-Record Functions: These functions are used when a value from previously loaded records of data is needed for the evaluation of the current record.     For Example  ,will Take Sample Table&nbs...
    Hirish V
    last modified by Hirish V
  • QlikView JDBC Connector

    Hi everyone,   this is a demo version of our JDBC Connector for QlikView. It will enable a lot of non-ODBC/OLEDB sources for loading data into QlikView.   Also, it would give much more performance on QV 9 ...
    Ralf Becher
    last modified by Ralf Becher
  • QvM - Qlikview Modules

    QlikView Modules Demo - YouTube   More info at QlikViewModules.com   Have fun Qlik'n, Koen
    Koen Bal
    last modified by Koen Bal
  • Generic keys

    Generic Keys is a way to define keys between tables in a more general way so that their values can represent other things than individual key values; they can represent groups of key values or any key value. As an exa...
    Henric Cronström
    last modified by Henric Cronström
  • QlikView Section Access Examples

    The  attached file SectionAccess.zip contains several example documents that show how Section Access can be used to restrict access to specific users and to specific data.   This is not a guide on how to us...
    Colin Albert
    last modified by Colin Albert
  • VB Macro Loop to Create Field Trigger Set Variable Action

    This has been created with help from multiple questions and answers on the forum and some extra vb searches. Hopefully, others will be able to adapt this for other purposes as required.   Requirements I needed ...
    Nathan Wright
    last modified by Nathan Wright
  • QlikView App - Generic Data Profiler

    Often when building QlikView applications, or picking up applications which have been built by someone else I want to have a quick and easy way of viewing the data that is in that application.  To enable me to do...
    Steve Dark
    last modified by Steve Dark