Dear All, It is a challenge to all of us to mimic SQL query into a Data model, quite often in the current project I face such challenges. One question you might ask is why not directly use the query in script and convert it as a qvd but in the architecture we are in right now we load most of the tables in to qvds and question comes when you have all the tables as qvds why can’t we create a...

Continuing my post on Section access introduction, I would like to give more insight into the topic.What is Section access ? Section access is a command in QlikView/Qlik Sense which is used to restrict data access on a qvw file or qvf file so that the person who is looking into the file would see only the data which is intended for him. Let me give a simple example, Business Scenario: A company...

Good Day, All of you. In the process of building a data model in QlikView/Qlik Sense sometimes we may require to load a set of files like .txt,.csv or .xlsx/.xls, but assume a case where we need to load a set of 100 files which are snap shots of data like complete weeks data kept on next Monday with a Date to it, like below. Now here is the task to load all the files at once with out loading them...

Good Day, All of you. To start with a simple quote…..                                                  ** Repetition is the crux of Education ** Section access is one such topic which can be discussed for hours together as it has a greater usage in QlikView/Qlik Sense...

I have been hearing this question from multiple people who want to learn QlikView or Qlik Sense but in reality both the tools are the same at the core architecture level(I mean QIX engine, associative model), but then what are the differences. QlikView is more useful for guided analytics, where Qlik Sense is useful for self service.           Phew! What are these...

Dear All, I am very glad today to create this blog so that I can share my experiences in Qlik world( QlikView, Qlik Sense). Things are too deep in Qlik as it is a wonderful tool which can be used as a Self Service and Guided Analytical tool.In this blog I would like to share some of the common things people like to know about Qlik, like technical things, common myths , some real time...