• 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
  • Send mail and Export in Qlikview

    Hi All, Please find the threads for sending email in Qlikview. Hope this will help. Thank you.   sending mail from desktop qvw app CREATING AUTOMATED ALERTS AND EMAILS SENDING BASED ON DATA LOADED IN QLIKVIEW...
    arjun rao
    last modified by arjun rao
  • Preparing examples for Upload - Reduction and Data Scrambling

    It's frequently useful to upload an example of your application when asking a question on the forum or sharing a technique with other Developers. Two concerns you may have about uploading an example are file size and ...
    Rob Wunderlich
    last modified by Rob Wunderlich
  • 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
  • Zero to D3 Extension in a few easy steps with an improved template

    Introduction Chapters Pre Reading- The Extension Template: See below or on the blog here: PreReading- Qlikview Extension in a few easy steps and with an improved template – Qlik and Dirty Step1- A bas...
    Adam Davies
    last modified by Adam Davies
  • 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
  • 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
  • World Cup 2018 Competition

    (MENSAJE EN ESPAÑOL A CONTINUACIÓN) Last status - 15/07/2018 QVW apps and original files with player predictions attached (RAR file) ----------------------------------------------------------------...
    Muñoz Héctor
    last modified by Muñoz Héctor
  • 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
  • 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
  • Export Variables.zip

    Many a times we may want to have same variables in different Qlikview document. So, we can put all those variables in a spreadsheet can bring them in Qlikview document using a simple piece of script.   Similarly...
    Kamal Kumar Sanguri
    last modified by Kamal Kumar Sanguri
  • Peek() or Previous() ?

    This article was sparkled by this discussion thread on Qlik Community. The question was: how to calculate the difference between dates that are stored in consecutive rows of a table? Three answers to the question sugg...
    Oleg Troyansky
    last modified by Oleg Troyansky
  • QlikView and Python Integration

    Python is a very popular scripting language and below explains how to implement Python into QlikView by using the edit module. In the below example, we will be returning operating system info by using Python’s ...
    Sinan Ozdemir
    last modified by Sinan Ozdemir