• 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
  • World Cup 2018 Competition

    (MENSAJE EN ESPAÑOL A CONTINUACIÓN)   Hi guys,   There are only 52 days left until World Cup 2018 (https://fifa.com/worldcup) starts. Who will be the World Champion? Will the Cup stay in Europe...
    Muñoz Héctor
    last modified by Muñoz Héctor
  • Variables

    Variables are really useful for a lot of things because you could store many different things within them and this could be changed while runtime or on user-action. Therefore they will be called variables.   Qli...
    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
  • 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
  • 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
  • Script for Incremental Loading of Multiple QVDs from a List of Table Names

    Below is a script that was developed to quickly pull the fields from a list of tables into QVDs and perform incremental loads on the QVDs going forward.  This particulate script was created to pull data from Sale...
    Josh Good
    last modified by Josh Good
  • Dependency Matrix

    Hi Qlikers,   Update: Added a date formatting parameter to verify if the QVDs are in a certain format to the QVW. Added the QVW lineageinfo directly by loading the Discriminator field from the [DocumentSummary...
    Felip Drechsler
    last modified by Felip Drechsler
  • Section Access: Strict Exclusion

    The strict exclusion feature often causes confusion and misunderstanding. The main purpose is to protect user access, due to  incorrectly setup section access reduction. A good start to understanding the feature ...
    Toni Kautto
    last modified by Toni Kautto
  • Load Multiple excel sheets using For loop

    Hi All, The script below loads the data into qlikview file for multiple sheets in a single load by using the Loop statements.    LET vStartSheetNumber = 1; LET vEndSheetNumber = 50; LET vExcelFileName ...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • Tasklog_Auditlog_Joiner.txt on QV Server (for QlikView)

    This VBS script shows how to combine report files in QV Server Audit.log with Tasklog.txt entries of Distribution Server   Example: Automatically restart qvw reports in QMC console (with edx-trigger) when no act...
    Marcel Hug
    last modified by Marcel Hug
  • QlikView App: QVD Meta Data Viewer

    There is a large amount of useful information that is stored in the header of QVD files.  This gives information about the data in the file, when it was created and which app created it.  This data is in an ...
    Steve Dark
    last modified by Steve Dark
  • Colors in Qlik

    I must admit that I never really thought about how Qlik handled colors internally and how they are stored. Inspired by the following discussion: https://community.qlik.com/thread/297454 I looked a bit more closely and...
    Marcus Sommer
    last modified by Marcus Sommer
  • Calculating Holidays in script

    Every time I see a discussion which mentions holidays, there is a recommendation to keep holiday list in an external file or hardcoded using load inline.   Both these methods are valid.  QlikView is very go...
    Michael Solomovich
    last modified by Michael Solomovich
  • Optimize Group By Performance

    One of our Qlik Community Buddy (Rupinder Singh) shared an awesome way to optimize the performance of group by statement but I don't think this got enough lime light which it should have. In order to give it better ex...
    Sunny Talwar
    last modified by Sunny Talwar
  • Barcode 39 with QlikView Standard Barchart (no font)

    QlikView can produce Barcodes (Encoding: 39)  itself. This little app uses the ability of a QlikView standard bar chart to draw the necessary black and white stripes to build a scanner-readable barcode   A ...
    Christof Schwarz
    last modified by Christof Schwarz
  • Batch file script to reload Qlikview Applications

    Hi Folks,   Recent days,I have seen some of them are asking on running Qlikview applications through windows scheduler in community. Generally we follows 3 tier architecture in our project. Assume we have 3 qv...
    arjun rao
    last modified by arjun rao
  • QlikView Date fields

    QlikView has an intelligent algorithm to recognize dates independently of which region you are in. In most cases, you will have no problems loading them. It just works and you do not need to think about it. However, i...
    Henric Cronström
    last modified by Henric Cronström
  • Close Document Session

    Hi,   I've built a document extension that allows you to close the ajax session when closing the browser or browser tab.   There's another document extension in the forum that never worked for me that's wh...
    Jeremy Latimer
    last modified by Jeremy Latimer
  • Introduction to Section Access

    A great primer to Section Access by Gustav Guldberg of QlikView Support.
    Community Administrator
    last modified by Community Administrator