• #### Document Getting the most out of a Trellis bar chart, some tricksGetting the most out of a Trellis bar chart, some tricks

Getting the most out of a Trellis bar chart, some tricks.   The Trellis chart can be useful for displaying the same chart over a dimension, but it has its limitations. This document aims to show how to get arou...
• #### Document Aggr() and set analysis: set modifiers inside and / or outside aggr()?!?Aggr() and set analysis: set modifiers inside and / or outside aggr()?!?

Hi community,   "Where should the set modifier be placed? Inside and/or outside the aggr()?"   The standard answer is mostly:   "If you are unsure, you should place the set modifiers inside and outsi...
• #### Document Creating a Custom CalendarCreating a Custom Calendar

Hi, Everyone!   Today we gonna make a custom calendar: So, let's get started! For instance we have a field with dates during 2017 year called "PostDate".   First of all we need to improve our data with...
• #### Document Visual tricks with charts. EQ-graphVisual tricks with charts. EQ-graph

Hello, Everyone!   Today we gonna make this cute equalized graph: I call it "eq" because it similar with equalizer. Maybe it has a different name, no matter. Let's make it live! Any data may be converted in ...
• #### Document QlikView App: At The Qlik Of A ButtonQlikView App: At The Qlik Of A Button

This example has been produced to accompany the blog post QlikView Buttons, When, Why and How.   The shared QlikView demonstrates how actions can be attached a number of different types of objects and used to na...
• #### Document QlikView App: Creating a Variance To Target Bar ChartQlikView App: Creating a Variance To Target Bar Chart

This example QlikView document shows how to create a bar chart that shows variance to target, both as an absolute value and as a percentage.   The charts produced look like this: By showing both these charts ...

created by
• #### Document Calculating rolling n-period totals, averages or other aggregationsCalculating rolling n-period totals, averages or other aggregations

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...
• #### Document YTQ, QTD, MTD and WTDYTQ, QTD, MTD and WTD

Year, Quarter, Month and Week To Date are the common analysis that I seen many applications. I will share the expression to do here First to do this your data model should have the DateField in number format by apply...
• #### Document Ignore all selections except few fields using Set AnalysisIgnore all selections except few fields using Set Analysis

Hello,   This requirement has come up again and again and believe would keep coming up in QlikView/Qlik Sense development. Fortunately there are already some solutions been discussed and documented here in the c...
• #### Document VB Macro Loop to Create Field Trigger Set Variable ActionVB Macro Loop to Create Field Trigger Set Variable Action

This has been created with help from multiple questions and answers on the forum and some extra vb searches. Hopefully, others will be able to adapt this for other purposes as required.   Requirements I needed ...
• #### Document Script for Storing/ Dropping Table with Exceptional listScript for Storing/ Dropping Table with Exceptional list

Problem Statement: Always tedious task to maintain drop table statement for all existing table of any Application. Below script handle table list which should be there even if there is drop statement. At the end of ...
• #### Document QlikView App - Generic Data ProfilerQlikView App - Generic Data Profiler

Often when building QlikView applications, or picking up applications which have been built by someone else I want to have a quick and easy way of viewing the data that is in that application.  To enable me to do...
• #### Document Fiscal and Standard Calendar generationFiscal and Standard Calendar generation

Hi All, What is Fiscal Calendar? From Wikipedia: A fiscal year (or financial year, or sometimes budget year) is a period used for calculating annual ("yearly") financial statements in businesses and other organizat...
• #### Document Prepare PPT from different QVW objects with MacroPrepare PPT from different QVW objects with Macro

CTRL+M activate macro screen then write below code (Export_All_Chart_Images) in macro screen. Scripting Engine = VBScript selected. Requested Module Security = System Access Current Local Security = Allow System Acce...

QVPR Analysis is a tool that will load a Qlikview Repository (QVPR) and allow you to analyze the contents.   With this app you can do Qlikview Analysis of the Reload and Distribution tasks defined on your server...
• #### Document QlikView 12 Application: System MonitorQlikView 12 Application: System Monitor

A derivative of the QlikView System Monitor for versions 10/11, finally the QlikView 12-compatible version has arrived. The UI has undergone some changes and the structure/setup has been simplified. This application w...