• White Paper - QlikView Migration Guidelines.pdf

    Hi,   Sharing a document on the Qlikview Migration guidelines. I found this to be very useful when planning to migrate the Qlikview to the latest version.   Regards,   SJ
    Sandeep Joglekar
    last modified by Sandeep Joglekar
  • 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
  • QlikTip#: Keep Optimized QVD Load

    Generally, QVD's are one of the most important in any Qlikview deployment.   A QVD (QlikView Data) file is a file containing a table of data exported from QlikView. QVD is a native QlikView format and can only b...
    Srikanth P
    last modified by Srikanth P
  • 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
  • Q-Eye version 6.5 is available for download

    Q-Eye is an easy to use QVD files editor that works with both QVD and QVX files It can export data as excel text and sql files   In this release we concentrated on making the life of end users easier.   Th...
    Mike Rewnick
    last modified by Mike Rewnick
  • Example of Selecting Multiple Field Values

    In this post, I will demonstrate how to programmatically select multiple values in a field.   We know that manually, we can select multiple field values by pressing down on the Ctrl button and selecting the valu...
    Lior Abitbol
    last modified by Lior Abitbol
  • 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
  • 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
  • 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
  • Table Viewer Table Automatically generated and Export to Excel

    Hi Community,   I developed the Northwind application for table viewer table automatically generated and Export to Excel in Local drive ('C:\Northwind DataViewer Table) using Macro. Please check and let me know...
    Iyyappan v
    last modified by Iyyappan v
  • How to reload Qlikview application on every Monday?

    How to reload Qlikview application on every Monday?   ///$tab Main SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; SET MoneyDecimalSep='.'; SET MoneyFormat='$#,##0.00;($#,##0.00)'; SET TimeForm...
    arjun rao
    last modified by arjun rao
  • 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
  • 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
  • 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