• MIN AND MAX IN LARGE TABLES

    Hi Experts, this is a small document about performance issues when looking for min and max values in very large tables.   Lets imagine that we have a fact table called myData with more than 100 M rows and we ne...
    Santiago Respane
    last modified by Santiago Respane
  • 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
  • Tennis data - ATP and WTA

    Hi everyone,   For tennis fans out there, I built 2 apps on for Women's tennis data (WTA) and one for men's (ATP).   Jeff Sackman ! !was kind enough to share some tennis data and the apps are built on the...
    Cheenu Janakiram
    last modified by Cheenu Janakiram
  • QlikView Control (SPC) Chart

    How do we create a simple Control or SPC chart in QlikView? You can see how to do this in the attached Application and Document. I have also placed a short blog post on the QlikView Design Blog.   ABY
    Adam Bellerby
    last modified by Adam Bellerby
  • Sheet Level Security.qvw

    Today, I am going to share a document on applying Sheet Level Security in Qlikview. Suppose our QV Dashboard have 4 levels of users like ADMIN  - Who can have access to all sheets REGION - Only have access to She...
    Jhansi Jangam
    last modified by Jhansi Jangam
  • Simply create YTD, moving totals and comparisons versus Year Ago

    When we want to do something with QlikView, we face so many possibilities to achive the goal. And sometimes, the first idea we have is not necessarily the simplest one. I wanted to do create YTD and moving totals mea...
    chinna katiki
    last modified by chinna katiki
  • Hierarchy in QlikView

    QlikView is an associative BI tool, not a hierarchical one. The different bricks of a hierarchy are splitted into the different levels so that can be mixed up. However, we want sometimes have a hierarchical represent...
    Fabrice Aunez
    last modified by Fabrice Aunez
  • 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
  • Set Analysis: syntaxes, examples

    For those that find this document in a search - you may also want to check out these videos to learn Set Analysis:   Introduction to Set Analysis (video) - Part 1   About the attached document:   The...
    Michael Tarallo
    last modified by Michael Tarallo
  • Files for creation of a Gantt chart

    Have you ever wanted to create a Gantt chart in QlikView, only to find out that this chart type is not one of the pre-defined charts? Then you should be happy to learn that it is possible to create a Gantt chart and t...
    Henric Cronström
    last modified by Henric Cronström
  • 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
  • How to Create a Profit and Loss Statement in QlikView

    Have you ever created a P&L statement in QlikView?  Well, this technical brief outlines how to create a P&L statement in QlikView 11 using IntervalMatch.   Also check out this blog post.   Tha...
    john pett
    last modified by john pett
  • An introduction to QlikView Security using Web Tickets

    QlikView provides a range of features to allow users to login and view documents using Single Sign On with a range of different technologies. A high level document detailing all of the various security options in Qlik...
    John Trigg
    last modified by John Trigg
  • Using Peek and Previous Functions Recursively to Help Transform Data

    Hey everyone, a large problem with unstructured data is that it's, well, unstructured. One of the most common problems we see here at Qualcomm, especially with testing or engineering data is when you have a table of r...
    John Trigg
    last modified by John Trigg
  • Ignore all selections except some specific fields using Set Analysis

    Hello. As far as I was designing apps for QV - I've found a great need in some charts to ignore all possible selections except some specific fields. Exploring possible ways to do so - the first my decision was to us...
    Denys Smakovskyi
    last modified by Denys Smakovskyi
  • Three Tier Architecture

    The Three-tier Architecture includes three layers in order to extract the data from the various database and store data in the qlikview data file, apply the business logic and develop the data model using QVD files an...
    mayilvahanan ramasamy
    last modified by mayilvahanan ramasamy
  • 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
  • Peek() vs Previous() – When to Use Each

    This zip file contains a technical brief, a qvw and a small file. The technical brief walks the user through the steps of when to use peek() vs previous() functions. I published a blog about it as well. You can fiund ...
    Charles Bannon
    last modified by Charles Bannon
  • How to use - MaxString & MinString

    Bullet points: MaxString and MinString belongs to Qlikview String Aggregation function. They are equivalent to MAX and MIN for integers They return the highest and lowest string value   What actually a value o...
    Robert Mika
    last modified by Robert Mika
  • How to find a number for a char: chr() and ord() functions

    Everyone knows that sometimes we need to use chr() function to put paragraph sign - chr(13) – or single-quote - chr(39). But sometimes you need a special symbol, but you don’t know the number. You can fin...
    Sergey Makushinsky
    last modified by Sergey Makushinsky