• 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
  • Guide to Dashboard Design.pdf

    A Guide to Creating Dashboards People Love to Use by juice   Thanks BKC
    balkumar chandel
    last modified by balkumar chandel
  • Advanced search: a possible pitfall

    Some of you will think that I'm writing about a very trivial topic. However nearly every day I find examples at the community using advanced search (expression search) and sometimes I'm in doubt, if people will get re...
    Robin Hausdörfer
    last modified by Robin Hausdörfer
  • Personal Transport for London Dashboard

    Hi All,   I made this dashboard with the data os my Oyster Card, with the commuting with bus and tube (I don't use the other ways).   I want to improve this dashboard, with the automation of the data, with...
  • 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
  • How to use- Dual()

    Have you ever wonder how the examples from the Qlikview help may look like? Please see below and enjoy responsibly...   Dual()   Definition: Forced association of an arbitrary string representation s with a...
    Robert Mika
    last modified by Robert Mika
  • Qlikview Parameterised Variables

    The Qlikview Variables are quite cool and they can be used as little functions too. For example, the below variable declaration gives the flexibility to use any simple aggregation functions on any fields in the model ...
    Sasidhar Parupudi
    last modified by Sasidhar Parupudi
  • QvM - Qlikview Modules

    QlikView Modules Demo - YouTube   More info at QlikViewModules.com   Have fun Qlik'n, Koen
    Koen Bal
    last modified by Koen Bal
  • QvM - Navigation & filters

    The navigation & filters module helps you in setting up a nice and sleek navigation menu design for the navigation between sheets. It includes a top bar, drop down panel for your filters, current selections and a ...
    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
  • QvM - AdHoc table

    The AdHoc table module provides an easy to setup AdHoc table (aka lego table). The dimensions and expressions are managed in the QVMeta_Dashboard excel which is part of the Documentation Module. The possibility to add...
    Koen Bal
    last modified by Koen Bal
  • QvM - Dynamic Data Model

    "Can you test and predict the behaviour of your datamodel ?" Ever wondered how the data model looks like with the current selections? How selections in one table have an influence on another table in your datamodel...
    Koen Bal
    last modified by Koen Bal
  • 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 - Color Management

    "How to reduce time to set up and manage the colors of your dashboard and start creating business value faster?"   Imagine there would be a module that could help set up and manage the colors for your dashboard ...
    Koen Bal
    last modified by Koen Bal
  • QvM - Advanced Data Discovery

    "How to discover your data in a fast dynamic way?"   When starting a new project the first thing I want to do is get a feel for the data. Preferably in a fast and dynamic way. You can use the "Advanced Data Disco...
    Koen Bal
    last modified by Koen Bal
  • QvM - Business User Help

    The Business User Help is a drop down panel with a universal search and a link to a video playlist with a general introduction to Qlikview for business users. The module integrates nicely with the Navigation module. I...
    Koen Bal
    last modified by Koen Bal
  • 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
  • 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
  • Do you Qualify?- How to use QUALIFY statement

    What it is used for? The Qualify statement is used for switching on the qualification of field names, i.e. field names will get the table name as a prefix.’   In situation where we have two (or more) Ta...
    Robert Mika
    last modified by Robert Mika
  • How To /Missing Manual (25 articles)

              How To / Missing Manual                        ...
    Robert Mika
    last modified by Robert Mika