• Dynamic Update - Using Actions

    Celambarasan Adhimulam
    last modified by Celambarasan Adhimulam
  • 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
  • Dependency Matrix

    Hi Qlikers,   Update: Added a date formatting parameter to verify if the QVDs are in a certain format to the QVW. Added the QVW lineageinfo directly by loading the Discriminator field from the [DocumentSummary...
    Felip Drechsler
    last modified by Felip Drechsler
  • Use Silent Legend with Cross Colors

    When I create a dashboard to mantain a good layout and to offer a good user experience always I need to set the same color for the same dimension value in each chart. Unfortunally there isnt' a easy way to do this, a...
    Luca Jonathan Panetta
    last modified by Luca Jonathan Panetta
  • Colors in Qlik

    I must admit that I never really thought about how Qlik handled colors internally and how they are stored. Inspired by the following discussion: https://community.qlik.com/thread/297454 I looked a bit more closely and...
    Marcus Sommer
    last modified by Marcus Sommer
  • Calculating Holidays in script

    Every time I see a discussion which mentions holidays, there is a recommendation to keep holiday list in an external file or hardcoded using load inline.   Both these methods are valid.  QlikView is very go...
    Michael Solomovich
    last modified by Michael Solomovich
  • Barcode 39 with QlikView Standard Barchart (no font)

    QlikView can produce Barcodes (Encoding: 39)  itself. This little app uses the ability of a QlikView standard bar chart to draw the necessary black and white stripes to build a scanner-readable barcode   A ...
    Christof Schwarz
    last modified by Christof Schwarz
  • F1 Data of Formula 1

    Hello everyone, We attach a file with data QlikView history of Formula 1 from 1950 to today. Not particularly bright in terms of presentation, but if you have enough information that Formula 1 fans will surely appre...
    Enrique Colomer
    last modified by Enrique Colomer
  • 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
  • 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
  • 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
  • Calendar Heatmap Extension (D3CalendarView)

    I have recently published a free calendar heatmap extension to compare values on a day-per-day basis over a long period of time (several years). The extension is developed using D3 and an existing visualization called...
    Stefan Walther
    last modified by Stefan Walther
  • 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
  • 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
  • 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
  • Selector Desde Hasta con Campos

    Para lograr filtros de fecha de tipo Desde Hasta usando Campos, y obtener un resultado como el siguiente:   Puede usarse la técnica con los siguientes pasos: 1. Cargar la Fact Table Ventas 2. Crear una ...
    Enmanuel Santana
    last modified by Enmanuel Santana