• 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
  • 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
  • REST Connector & Pagination on Pipedrive

    This document explains some issues identified in testing the REST connector with Pipedrive data using the Start & Limit parameters for paging the output results from the Pipedrive API.   I have been using th...
    Colin Albert
    last modified by Colin Albert
  • 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
  • Master Calendar Generation Script

    Below script helps in generating the Master calendar.  In this script I am getting the Minimum and Maximum dates in my Invoice table and generating the entries for each date in CalendarMaster table between minimu...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • 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
  • 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
  • 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
  • Variables

    Variables are really useful for a lot of things because you could store many different things within them and this could be changed while runtime or on user-action. Therefore they will be called variables.   Qli...
    Marcus Sommer
    last modified by Marcus Sommer
  • JSON Loader

    Hey,   I hope I can solve a lot of peoples headache with a better way of loading JSON data.   This method works by loading the JSON data into an table with a single field, and then placing it into a variab...
    Torben Seebach
    last modified by Torben Seebach
  • QlikView JDBC Connector

    Hi everyone,   this is a demo version of our JDBC Connector for QlikView. It will enable a lot of non-ODBC/OLEDB sources for loading data into QlikView.   Also, it would give much more performance on QV 9 ...
    Ralf Becher
    last modified by Ralf Becher
  • Script for Incremental Loading of Multiple QVDs from a List of Table Names

    Below is a script that was developed to quickly pull the fields from a list of tables into QVDs and perform incremental loads on the QVDs going forward.  This particulate script was created to pull data from Sale...
    Josh Good
    last modified by Josh Good
  • 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
  • Section Access: Strict Exclusion

    The strict exclusion feature often causes confusion and misunderstanding. The main purpose is to protect user access, due to  incorrectly setup section access reduction. A good start to understanding the feature ...
    Toni Kautto
    last modified by Toni Kautto
  • Load Multiple excel sheets using For loop

    Hi All, The script below loads the data into qlikview file for multiple sheets in a single load by using the Loop statements.    LET vStartSheetNumber = 1; LET vEndSheetNumber = 50; LET vExcelFileName ...
    jagan mohan rao appala
    last modified by jagan mohan rao appala