• Passing Selections and Document Chaining

    Document Chaining What do you do when your model is so big to the point that isn’t usable and you can’t increase resources to your environment? I found that the best solution that worked for me is to spli...
    Sibusiso Phumelo
    last modified by Sibusiso Phumelo
  • Let's read Qlik

    !Greetings to all. I love Qlik, but lately I do not have enough time to keep track of everything that happens. I have to visit many resources for reading news, articles, tricks, videos. I set myself the goal of bei...
    Stanislav Chernov
    last modified by Stanislav Chernov
  • My simple Dynamic Report Builder - use with any data source

    This is old news but I just realized I never gave the example someone asked for a year ago.   Load any data source(s) with unlimited tables unlimited fields. My example uses the attached data source to load som...
    Daniel Greenberg
    last modified by Daniel Greenberg
  • 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
  • QlikView automation by external VBScript scripts

    You can do all sorts of administrative tasks with QlikView applications through Automation API. Export charts to excel or csv files, export variables from application, set sheet level security parameters before depl...
    VADIM TSUSHKO
    last modified by VADIM TSUSHKO
  • Qlikview Shortcut Keys

    Find the attached document helps to know shortcut keys in Qlikview. Regards. Siva   Note: Updated the versions as per the comments(additional shortcut keys)  by the community members below.
    sivasankar kanagasabai
    last modified by sivasankar kanagasabai
  • 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
  • Send mail and Export in Qlikview

    Hi All, Please find the threads for sending email in Qlikview. Hope this will help. Thank you.   sending mail from desktop qvw app CREATING AUTOMATED ALERTS AND EMAILS SENDING BASED ON DATA LOADED IN QLIKVIEW...
    arjun rao
    last modified by arjun rao
  • Useful Qlikview Macros

    Hope the below macro scripts helps beginners Source : QlikView Macros – Useful collection | Lucian Cotea   1) Run external program: FUNCTION RunExe(cmd) CreateObject("WScript.Shell").Exec(cmd) END FUNCTION...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • 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
  • Table Viewer Table Automatically generated and Export to Excel

    Hi Community,   I developed the Northwind application for table viewer table automatically generated and Export to Excel in Local drive ('C:\Northwind DataViewer Table) using Macro. Please check and let me know...
    iyyappan v
    last modified by iyyappan v
  • How to manage your NPrinting task execution from QlikView script

    Recently I have heard this question several times, therefore it might be worth of writting something about it.   Since version 17.2, NPrinting has empowered its features to external programs by its RESTful APIs....
    Yang Jiao
    last modified by Yang Jiao
  • dropdown menu extension

    When you are using many tab sheets within QlikView your application can easily become unclear and very full. Using standard tab sheets it is not possible to build a hierarchy in your menu. I have built a dropdown ...
    Petra Bloem
    last modified by Petra Bloem
  • 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
  • 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
  • Customisable Straight (and Pivot) Tables - more food for thought

    EDIT 25th November 2014!! Guests to the inaugural #QlikDevGroup meeting tonight - the flexi-chart demo goes waaaayyy beyond this!! (updated doc and code will made available to everyone soon) Hello everyone,   ...
    Jason Michaelides
    last modified by Jason Michaelides
  • How to use - Dimensionality()

    Definition: Returns the number of dimension columns that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates. A typical use is in attribute expressions, when you want to apply di...
    Robert Mika
    last modified by Robert Mika