• Functions Cheatsheet.pdf

    Hello Everyone,   I have attached the document for the important Qlikview functions used in script as well as in UI. Please have a look and also feel free to update the document or comment in the session for th...
    Ritesh Agarwal
    last modified by Ritesh Agarwal
  • Loading Multiple Excel Sheets Dynamically along with file name and sheet name

    Hi All,   This document helps you in loading multiple excels and excel sheets with the name of the sheet and data.   //to read each file from the specified folder FOR EACH file in FileList('filepath\*.xlsx...
    Enrique Colomer
    last modified by Enrique Colomer
  • Extension to copy cell values in Ajax

    Ajax is missing the "Copy cell value" functionality available in the IE Plugin/QV Developer.   This extension allows you to get the value of a cell and easily copy it to the clipboard. You should first click on ...
    Daniel Rozental
    last modified by Daniel Rozental
  • User-Experience Guidlines for QlikView

    We all dream of building QlikView applications that show off the peaks and valleys of the data through stunning visualization and bring out the value of QlikView. But have you ever wondered what creates an overall goo...
    Sara Leslie
    last modified by Sara Leslie
  • How to do Forecasting In Qlikview( with Example)

    Hi All,  Here is another document with screenshot for beginners. This is all about how to perform 'Forecasting' in qlikview with manual input. Please find the document attached.  Your comments are welcome. R...
    sivasankar kanagasabai
    last modified by sivasankar kanagasabai
  • 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
  • YTQ, QTD, MTD and WTD

    Year, Quarter, Month and Week To Date are the common analysis that I seen many applications. I will share the expression to do here First to do this your data model should have the DateField in number format by apply...
    Hirish V
    last modified by Hirish V
  • Designing a Self Report with Qlik View

    Enable your users to design their own reports!       Often it´s the case that your users would like to have the possibility to see many different reports with many different dimensions. You usual...
    Carolin Borchert
    last modified by Carolin Borchert
  • 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
  • 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