Incremental Load in QlikView – Part1

In QlikView, incremental load is used  when large transactional tables are involved. Incremental load is a mechanism by which updated/new data is loaded in QlikView. Incremental load require the use of QVD files for data storage. Why use incremental load In many business environments, there will be many large transaction tables. These tables may receive 1000’s […]

Continue reading


Gauge Chart in QlikView

Gauge charts in QlikView are very useful to display when your measure lies within a threshold and outside a threshold value. There are times when executives want to see visually their key measures and want to know at a glance whether values are falling within a acceptable value(green) or outside acceptable value (red). I will show you […]

Continue reading


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