• QlikView 12 Application: System Monitor

    A derivative of the QlikView System Monitor for versions 10/11, finally the QlikView 12-compatible version has arrived. The UI has undergone some changes and the structure/setup has been simplified. This application w...
    Michael Terenzi
    last modified by Michael Terenzi
  • 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
  • RightQlik: quick access to common operations on QlikView files

    If you’re a QlikView developer, you probably know that there are a few tasks that can be performed with QlikView from the command line. One of my favorites is the Open without data option (see below to read how ...
    Mike Garciam
    last modified by Mike Garciam
  • Fiscal Calendar with Non-Standard Days (Not 1-31)

    Hi All, Hope the below script helps for those who are looking for a Fiscal Calendar for non standard dates.  For example the month starts from 26 th of previous month to 25th of current month.   Jan-2015: ...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • QlikView and Python Integration

    Python is a very popular scripting language and below explains how to implement Python into QlikView by using the edit module. In the below example, we will be returning operating system info by using Python’s ...
    Sinan Ozdemir
    last modified by Sinan Ozdemir
  • Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)

    Hello Friends, WTD (Week To Date), MTD(Month To Date), QTD (Quarter To Date) & YTD(Year To Date) are commonly used for any kind of analysis. Below are some expression which you can use while doing the same: &n...
    Rahul Pawar
    last modified by Rahul Pawar
  • 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
  • QlikView: The Mirable Miracle Use of Pixel Perfect Developer Work Space...

    QlikView: A Wonderfull User Experience!! The Mirable Miracle of Pixel Perfect Developer Work Space... Some my personal "best practice" document to UI with mustache!: A User Experience with Big <U > ! The DashB...
    valerio fatatis
    last modified by valerio fatatis
  • Apply Map Concept

    For new comers I am Uploading example of How Apply Map works.   Thanks   Vikas
    vikas mahajan
    last modified by vikas mahajan
  • Qlikview Learning: General topics with Examples and Help Material

    Attached the documentation , examples and learning material which i have collected over the years. It will help everyone in the community. Some of the files are from community itself. But re posting them so that every...
    Vinay kumar Bangari
    last modified by Vinay kumar Bangari
  • 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
  • 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
  • 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
  • Using FirstSortedValue in the Script

    Hi,   I have been looking into FirstSortedValue funtion within a script. Here is an example which uses the function within a loop transforming the original data to either one with flags or a new dimension feild....
    Richard Pearce
    last modified by Richard Pearce
  • QlikView Application: System Monitor v5.1.23

    New - Version 5.1.23 (posted 9/25/2014)   ***added workaround for "UserAgent" bug where condition is not met but QV reads the Else field anyways ***Edited expressions for TotalMaxCalsInUse charts to reflect max...
    Michael Terenzi
    last modified by Michael Terenzi
  • 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
  • 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
  • Use OLEDB to get Excel sheet names

    Having in the past used the ODBC method of getting .xlsx sheetnames (How to load EXCEL worksheets and retrieve tab names), I recently worked for a client who didn't have access to be able to install the ODBC driver re...
    gareth wilson
    last modified by gareth wilson
  • QvM - Key Check

    "How to check the links between your tables? Do the values of the key between the two tables match as predicted?"   When building a data model it is important that you have a good understanding of the links betwe...
    Koen Bal
    last modified by Koen Bal
  • QvM - Documentation

    When there is a handover of a Qlikview project from one developer to the next it is highly recommended to add some documentation about the project. The Documentation Module exists out of a check list with the question...
    Koen Bal
    last modified by Koen Bal