Recently i was reading an article on National Geographic about best places to visit this summer. It made me think which place i would visit. The decision was simple. I would visit QlikView.com. Why QlikView In Memory – QlikView is an in memory business discovery application. QlikView can merge variety of data sources and present to you the […]
Executing Stored procedure in QlikView
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 […]
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 […]
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 […]
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, […]