to follow, share, and participate in this community.
This is an example of a thematic (aka heat map) visualization using Google's Chart API. 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... Find the attached document helps to know shortcut keys in Qlikview. Regards. Siva Note: Updated the versions as per the comments(additional shortcut keys) by the community members below. 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... 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... Introduction
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... 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... A question that gets asked regularly is how to calculate a rolling measure over a period of N-months (or weeks or days). For example a 12-month rolling total or a 4-week rolling average. There are several ways to do t... AGGR is a very powerful aggregation function that is sometimes overlooked in the user interface due to is not being properly understood or indeed a developer not being sure how it can be utilised. Often, a QlikView de... 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... 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... 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... This QlikView shows how basic Set Analysis syntax can be used to deliver a Prior Period Comparison. Rather than taking the approach of flagging rows as being in certain periods at load time this example shows t... The blog posting 'The Power Of Yellow' describes how Show Alternatives can be used to highlight data excluded by a selection on a field that would otherwise be included. This QlikView application illustrates thi... In the attached technical brief, learn how to add silent legends to your QlikView applications. Check out the blog I wrote on this topic. 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. ... 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... 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... 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 All, Here comes a document on how to create automated alerts and emails sending based on the data using qlikivew. For the benefit of beginners or newbies, i've created the document with few screenshots. Pleas...