• QlikView App: Set Analysis - Prior Period Comparison

    This QlikView shows how basic Set Analysis syntax can be used to deliver a Prior Period Comparison.   Rather than taking the approach of flagging rows as being in certain periods at load time this example shows t...
    Steve Dark
    last modified by Steve Dark
  • QlikView App: The Power Of Yellow (Show Alternatives)

    The blog posting 'The Power Of Yellow' describes how Show Alternatives can be used to highlight data excluded by a selection on a field that would otherwise be included.  This QlikView application illustrates thi...
    John Trigg
    last modified by John Trigg
  • Use of a Silent Legend

    In the attached technical brief, learn how to add silent legends to your QlikView applications.  Check out the blog I wrote on this topic.
    Jennell McIntire
    last modified by Jennell McIntire
  • Waterfall Chart for Bridging data

    Hi community,   This is my first contribution as a document. First I apologize for my english level, I hope it will be understandable. I searched the community and I think this subject is not covered.   ...
    shivaji ch
    last modified by shivaji ch
  • 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
  • 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
  • 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

    Hi All,  Here comes a document on how to create automated alerts and emails sending based on the data using qlikivew. For the benefit of beginners or newbies, i've created the document with few screenshots. Pleas...
    sivasankar kanagasabai
    last modified by sivasankar kanagasabai
  • 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
  • Automated Excel Export and Email Macro

    The intended purpose is to automate the exporting of an object to a predefined file location in Excel format unless the chart renders no data in which it would export a confirmation file in .txt format. For the Excel ...
    Curt Daughtry
    last modified by Curt Daughtry
  • 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

    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
  • Converting 64 bit hexadecimal (PGO dates) to decimal

    Hi,   Dates (like the LastUsed date) in the CalData.pgo.xml file are saved as 64 bit hexadecimal numbers. Those numbers can be converted to decimals by using the double precision floating point format (IEEE-754...
    René Verschuren
    last modified by René Verschuren
  • Calculating rolling n-period totals, averages or other aggregations

    A question that gets asked regularly is how to calculate a rolling measure over a period of N-months (or weeks or days). For example a 12-month rolling total or a 4-week rolling average. There are several ways to do t...
    Gysbert Wassenaar
    last modified by Gysbert Wassenaar
  • Different Join Functions in Qlikview

    In join functionality we have four type of the joins as we know and at the place they differently used in the data model. I provide this document for under stand the functionality of the joins in the 4 ways.   T...
    Anand Chouhan
    last modified by Anand Chouhan
  • 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
  • QlikView Technical Brief - Loading Images into QlikView.zip

    This technical brief explains the Bundle Load function in QlikView. The files contained in this zip file are the technical brief, a QVW, and the supporting data and image files. I wrote a blog about this topic and you...
    Charles Bannon
    last modified by Charles Bannon
  • 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
  • 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