• Waterfall Chart for Bridging data

    Hi community,   This is my first contribution as a document. First I apologize for my english level, I hope it will be understandable. I searched the community and I think this subject is not covered.   ...
    shivaji ch
    last modified by shivaji ch
  • Optimize Group By Performance

    One of our Qlik Community Buddy (Rupinder Singh) shared an awesome way to optimize the performance of group by statement but I don't think this got enough lime light which it should have. In order to give it better ex...
    Sunny Talwar
    last modified by Sunny Talwar
  • Barcode 39 with QlikView Standard Barchart (no font)

    QlikView can produce Barcodes (Encoding: 39)  itself. This little app uses the ability of a QlikView standard bar chart to draw the necessary black and white stripes to build a scanner-readable barcode   A ...
    Christof Schwarz
    last modified by Christof Schwarz
  • 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
  • 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
  • Easily managing global variables externally

    A really simple script I must_include at the beginning of all my scripts to load global variables, managed in a seperate place (an Excel file in the example below, could of course be just as well SQL.   Any comm...
    Ronald van der Does
    last modified by Ronald van der Does
  • Organization Chart (Version 3)

    I updated the organizational chart from bmz to included a few additional features that were required from a customer. Allow for multiple organization charts to be render on one page Ability to filter the data in the...
    Samuel Pena
    last modified by Samuel Pena
  • 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
  • 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
  • License_Analyser_K3FDS.qvw

    The QlikView Management Console is a great tool for configuring your QlikView environment, but one thing it is not great at, ironically, is analysing your usage of licenses. In particular analysing your use allocation...
    David Foster
    last modified by David Foster
  • 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
  • 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