• 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
  • 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
  • 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
  • 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 manage your NPrinting task execution from QlikView script

    Recently I have heard this question several times, therefore it might be worth of writting something about it.   Since version 17.2, NPrinting has empowered its features to external programs by its RESTful APIs....
    Yang Jiao
    last modified by Yang Jiao
  • dropdown menu extension

    When you are using many tab sheets within QlikView your application can easily become unclear and very full. Using standard tab sheets it is not possible to build a hierarchy in your menu. I have built a dropdown ...
    Petra Bloem
    last modified by Petra Bloem
  • 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
  • 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
  • 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
  • Loading Excel file from Sharepoint into Qlikview.

    I was able to load data from excel sheet which was in share point but was not able to do that in server. I try to find solution in community but i did not see anyone had a good documentation on how to do this. So her...
    everest226 KC
    last modified by everest226 KC
  • 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
  • Using QlikView for (bulk) INSERT into SQL

    Hi everyone, Here is a file to write the content of a QVD into an MS SQL database with minimum amount of coding. The script uses bulk insert function in SQL and inserts 1,000 rows at a time. There are instruc...
    Cheenu Janakiram
    last modified by Cheenu Janakiram
  • How to resolve Qlikview Server Errors

    Error: “The Qlikview web server service on Local computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.” Cause: When you are tr...
    Tharindu Ranathunge
    last modified by Tharindu Ranathunge
  • How to use - MaxString & MinString

    Bullet points: MaxString and MinString belongs to Qlikview String Aggregation function. They are equivalent to MAX and MIN for integers They return the highest and lowest string value   What actually a value o...
    Robert Mika
    last modified by Robert Mika