• QlikView Scheduled & Automated Reports – Sending Excel via Email

    Hello everyone!   Higher management often requires specific data delivered to their mailbox every morning. They are not interested in interaction, using filters and “playing” with data. They just wan...
    Jakub Szurogajło
    last modified by Jakub Szurogajło
  • 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
  • Continuous Ranking (no missing Rank)

    First of all I want to thank few people here before I go over this document   Massimo Grossi - He is the brains behind this (Simple Rank() question) Thirumala Dandamudi - Shared the link for the post so that I ...
    Sunny Talwar
    last modified by Sunny Talwar
  • 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
  • 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
  • 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
  • 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
  • Store Qvd file with Timestamp value

    //Load Your Table here with proper name given TableName: Load * Inline [ Users,ID A,1 B,2 C,3 ]; //Create a variable for capture the Timestamp value of the QVW //with help of NOW() function and give proper Fo...
    Anand Chouhan
    last modified by Anand Chouhan
  • 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
  • Intervalmatch example – with dates

    I have two tables Table1,Table2. Table1 has DATE, Table2 has START_DT,END_DT. Want to join these two tables on DATE columns. Intervalmatch function will help us to make the join in Qlik. If we use left join, we can av...
    arjun rao
    last modified by arjun rao
  • SQL Insert from QlikView.qvw

    In this app I showed how to insert data into SQL Table by LOAD Script or using macro. Data from variables insert into SQL Table by this script:   INSERT INTO [dbo].[Table1]       &nb...
    Stanislav Strogiy
    last modified by Stanislav Strogiy
  • Previous YTQ, QTD, MTD and WTD

    In reference to YTQ, QTD, MTD and WTD   This is to a analysis of Sales up to the Selected day in Previous year. YTD - Year To Date A date should be selected and it will look for the Starting date of the Previous...
    Celambarasan Adhimulam
    last modified by Celambarasan Adhimulam
  • 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
  • Macro that combines two sheet objects and export as a single image.

    Hi Friends,   I have come across some questions posted by the community members asking if there is any way to combine 2 or more sheet objects and export them into a single image file.   While this is not p...
    Sasidhar Parupudi
    last modified by Sasidhar Parupudi
  • A more comprehensive HELP on Maxstring() / Minstring() than the HELP file

    Hi all,   the HELP file and the old reference manual are my first places if I want to learn something about Qlik functions. But sometimes I think they are not giving 100% correct or complete answers. For example...
    Stefan Wühl
    last modified by Stefan Wühl
  • 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
  • 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
  • Three Tier Architecture

    The Three-tier Architecture includes three layers in order to extract the data from the various database and store data in the qlikview data file, apply the business logic and develop the data model using QVD files an...
    Mayil Vahanan Ramasamy
    last modified by Mayil Vahanan Ramasamy