to follow, share, and participate in this community.
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... 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 ... I must admit that I never really thought about how Qlik handled colors internally and how they are stored. Inspired by the following discussion: https://community.qlik.com/thread/297454 I looked a bit more closely and... 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... QlikView has an intelligent algorithm to recognize dates independently of which region you are in. In most cases, you will have no problems loading them. It just works and you do not need to think about it. However, i... 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... A great primer to Section Access by Gustav Guldberg of QlikView Support. 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... //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... 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... 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... I have two tables Table1,Table2. Table1 has DATE, Table2 has START_DT,END_DT. Want to join these two tables on DATE columns. Intervalmatch function will help us to make the join in Qlik. If we use left join, we can av... 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... 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... 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... //Data load and store into QVD:
LOAD InvoiceNumber, InvoiceLineNumber, InvoiceDate, CustomerID, SalesmanID, ProductID, Quantity,
... 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... ByteSizes from Values in QlikView I think you know that QlikView had a very effective way to handle and store data. The general approach is described here: Symbol Tables and Bit-Stuffed Pointers and here: Symb... This example qlikview document can help you load excel files that contain a pivot table with multiple horizontal headers (dimensions) like in the image below: The instructions on how to use this documents can be fo... Inter-Record Functions: These functions are used when a value from previously loaded records of data is needed for the evaluation of the current record. For Example ,will Take Sample Table&nbs...