How to analyze and understand qlikview application(s) ?

[anil_y_86]

How to analyze and understand qlikview application(s) ? For example - I am from programming background.  To understand my application I start with step by step function calls something like that.............

In the same way what are the basic things that I have to look for an unknown application in QVW to understand?

[salto]

Hello Anil,

basically, read the load script, the code that builds the data model in which the application resides.

The script creates a structure of related tables, "similar" to a relational databse but with some important differences (the one that most impacted me at the beggining was the way to make relationships between tables - they are made via the field name).

If you have a SQL querying background it will no tbe of any difficulty.

If you do not have any previous experience in QV, I would suggest you to start with a book that helps me a lot, "QlikVIew 11 for developers".

Godd luck!

[brijesh1991]

At first press: Ctrl+T which will show you table view. Half of the linking(Outer joins) you will smell from there.

Then go to Edit Script and see if there is any left/Right/Inner joins

Then check how the new measures are created from existing fields

Finally look at front end

[Miguel_Angel_Baeyens]

Hi Anil,

Apart from all the above, which is correct, I think you should start using and understanding the QlikView Governance Dashboard, a tool based in QlikView Expressor that allows you to search for specific functions and definitions data lineage, files read and stored in each application and so.

Miguel

[anil_y_86]

Hi Miguel,

I didn't see download option for Governance Dashboard File.

Can someone share it ?

Regs,

Anil

[Miguel_Angel_Baeyens]

Anil,

Go to the download site and grab it from there

http://eu.demo.qlik.com/download

Miguel