• 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
  • 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
  • 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
  • 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
  • A sneaky use of QlikView gauges - Doughnut gauges

    Here is a quick entry on how to create a doughnut gauge. These gauges provide an effective way of representing a percentile measure like a KPI. The gauge has the advantage over a Pie Chart of only requiring only one e...
    John Trigg
    last modified by John Trigg
  • 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
  • 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
  • Calculating Months difference between two dates

    The script below calculates the months difference between two given dates.    //Function to calculate Months Difference in script SET MonthDiff = Num(((year($2) * 12) + month($2)) - (((year($1) * 12) + mo...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • Ageing Stock Analysis in Qlik Sense

    I was recently set the task to create a table that looked at Ageing Stock for one of my clients. It required looking at the date, Qty and Location of stock ‘In and outs’ on and First in First Out (FIFO) ba...
    Jon Foote
    last modified by Jon Foote
  • Apply Map Concept

    For new comers I am Uploading example of How Apply Map works.   Thanks   Vikas
    vikas mahajan
    last modified by vikas mahajan
  • NULL handling in QlikView

    What is the difference between a NULL and a missing value? How are NULLs propagated in expressions? How does QlikView display NULLs? How do I make NULLs selectable? How do I search for NULLs? Can NULLs be used in...
    Henric Cronström
    last modified by Henric Cronström
  • How To /Missing Manual (25 articles)

              How To / Missing Manual                        ...
    Robert Mika
    last modified by Robert Mika
  • Graphic to display market share 

    Hi, Usually we want our graphics are possible as more visual and enable the user to quickly perceive what is going on with their data. I attached a graph often used to show market shares from the mean. You can see ...
    Enrique Colomer
    last modified by Enrique Colomer

    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
  • 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