Reference Line in QlikView

Reference line is important in any business scenario. Reference line can be a sales goal/target that an Organization want to achieve. Reference line can be  a mile stone from where a business want to grow. For example, a business achieved a Sales of $10million in 2009, they can use this as a reference for their future growth. In […]

Continue reading


Dimensions and Facts

What is STAR Schema Recently a student in my training class asked me, is it enough to know QlikView. One of my  friend who is  reasonably knowledgeable in QlikView also asked me the same question. He is struggling to meet client’s requirement. His question was the same ,is it not enough to just know QlikView. My response to them was, it is a […]

Continue reading


Cross Table in QlikView

Cross Table is a table with Orthogonal list of headers. Orthogonal simply means at right angles. We come across cross tables everywhere in our daily lives. Michael Jordan  is the greatest basketball player of our times. I am a big fan of Michael Jordan. To explain the concept of Cross table, i will take a sample of […]

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