Best places to visit this summer – QlikView.com

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 […]

Continue reading


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 […]

Continue reading


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 […]

Continue reading


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 […]

Continue reading