In certain business environments all the complex business logic is implemented in a stored procedure. This usually happens when the source system is a huge transactional database system and data warehouse is not available. In such scenarios you have two choices – load all the tables in QlikView and recreate stored procedure logic – execute the stored proc and get […]
Author: Chandraish Sinha
QlikView – Set Analysis and Alternate State
QlikView Set Analysis allows you to perform flexible aggregation. Usually aggregation occurs on the set of values in the current selection. But many a times business requirements demand to perform aggregation on a Set of records that are independent of current selection. For e.g. your current selection may be Year = 2001, but using set Analysis you can […]
Share this:
QlikView – Alternate States – part 2.
In QlikView, Alternate States are not accessible in the load script.They are a feature of User interface. To use/create Alternate state, user have to first create Alternate state in Settings/Document properties. Once an Alternate state is created then user can either use this alternate state in any sheet object or create new ones. If Alternate State is […]
Share this:
QlikView – Alternate States – part1
Today I want to discuss Alternate states in QlikView, but before we start on Alternate states, we need to understand Attach/detach functionality in QlikView. In QlikView, data is associated based on the common field names in one or more table. For e.g. If you have 3 Tables, when a selection is made in one table, […]
Share this:
Master Calendar in QlikView
In any Dashboard,Time is an important factor. Users will always be interested in viewing the data by time period and also will be interested in performing comparitive analysis between 2 time periods. In a data warehouse, a Time dimension table is usually present, which joins to the fact table and produces results.In some situations, time […]
: