• Functions Cheatsheet.pdf

    Hello Everyone,   I have attached the document for the important Qlikview functions used in script as well as in UI. Please have a look and also feel free to update the document or comment in the session for th...
    Ritesh Agarwal
    last modified by Ritesh Agarwal
  • Loading Multiple Excel Sheets Dynamically along with file name and sheet name

    Hi All,   This document helps you in loading multiple excels and excel sheets with the name of the sheet and data.   //to read each file from the specified folder FOR EACH file in FileList('filepath\*.xlsx...
    Enrique Colomer
    last modified by Enrique Colomer
  • Lineage / Dependency Analyzer for QlikView

    A free QV App that allows you to visualize your solution as a system of related elements. The application scans your QV environment and automatically discovers dependencies between QVW Apps, QVD Tables, Flat fil...
    Vasily Petrenko
    last modified by Vasily Petrenko
  • Q-Eye version 6.5 is available for download

    Q-Eye is an easy to use QVD files editor that works with both QVD and QVX files It can export data as excel text and sql files   In this release we concentrated on making the life of end users easier.   Th...
    Mike Rewnick
    last modified by Mike Rewnick
  • User-Experience Guidlines for QlikView

    We all dream of building QlikView applications that show off the peaks and valleys of the data through stunning visualization and bring out the value of QlikView. But have you ever wondered what creates an overall goo...
    Sara Leslie
    last modified by Sara Leslie
  • How to do Forecasting In Qlikview( with Example)

    Hi All,  Here is another document with screenshot for beginners. This is all about how to perform 'Forecasting' in qlikview with manual input. Please find the document attached.  Your comments are welcome. R...
    sivasankar kanagasabai
    last modified by sivasankar kanagasabai
  • Power Tools 1.2 for QlikView

    Power Tools for QlikView Version: 1.2   For the absolute latest version, please see Power Tools for QlikView - One-stop-shop   In this release:   QlikView Server Agent *updated* - 1.6.2 QlikView S...
    Stefan Bäckstrand
    last modified by Stefan Bäckstrand
  • 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
  • Power Tools for QlikView - One-stop-shop

    This page will collect all relevant release information about Power Tools for QlikView, and will be continuously updated with each new release and with any patches that are issued. This way we hope for a more consolid...
    Stefan Bäckstrand
    last modified by Stefan Bäckstrand
  • Address2Coord.xlsm

    Hi All   This is a Excel Macro to obtain GPS coordinates from addresses to use it in map objects. You can configure it to adapt it to your data model addresses.   I hope this will be useful for anyone &nb...
    Jose Miguel Vilaplana
    last modified by Jose Miguel Vilaplana
  • Power Tools 1.3.0 for QlikView

    Power Tools for QlikView Version: 1.3.0     Yes, it's actually true! Long story short; we'll be starting to release smaller releases, where we add support for QlikView 12.X continuously in the existing t...
    Stefan Bäckstrand
    last modified by Stefan Bäckstrand
  • 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
  • Use Silent Legend with Cross Colors

    When I create a dashboard to mantain a good layout and to offer a good user experience always I need to set the same color for the same dimension value in each chart. Unfortunally there isnt' a easy way to do this, a...
    Luca Jonathan Panetta
    last modified by Luca Jonathan Panetta
  • 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
  • SQL Writeback from QlikView extension object.

    This example demonstrates the SQL WriteBack capability of QlikView via the use of an Extension object. It can be useful for passing a filtered subset of data to a database, writing a comment to a record or simply amen...
    Martin Mahler
    last modified by Martin Mahler
  • 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
  • Easily managing global variables externally

    A really simple script I must_include at the beginning of all my scripts to load global variables, managed in a seperate place (an Excel file in the example below, could of course be just as well SQL.   Any comm...
    Ronald van der Does
    last modified by Ronald van der Does
  • COLORS / COLORES

    Hi all, Often we miss a lot of time carefully selecting the colors you want to use. In the attached file you will see a wide range of colors grouped together to make it easier to search and selecting the right color...
    Enrique Colomer
    last modified by Enrique Colomer
  • QlikView Data Analyzer

    I developed the QlikView Data Analyzer Application with features to do Data profiling, Rapidly analyse and validate the data in the Data model of a QlikView Application. I have added Macros & Buttons to the layout...
    Sandeep Vangala
    last modified by Sandeep Vangala