Diane Blackwood's 2015 Book 

QlikView for Finance 

QlikView for Finance


Deliver dynamic business intelligence dashboards for financial analysis with QlikView

About This Book

Who This Book Is For

If you are a finance professional with basic knowledge of QlikView functions and wish to increase your knowledge of QlikView to apply it in the field of finance, then this book is for you. A good knowledge of financial aspects is an must-have.

Book available from Packt Publishing, Safari, www.amazon.com,  www.barnesandnoble.com:

        e-book prices around $26.59. Print $34.99.  ISBN: 978-1-78439-574-2


Diane Blackwood's 2013 Book 

Instant QlikView 11 Application Development 

Book available from Packt Publishing, Safari, www.amazon.comwww.barnesandnoble.com:

        e-book prices around $16.99. Print $27.99.  ISBN: 978-1-84968-964-9


Sample section from bonus chapter:

Getting ready

You may have played the game Six Degrees of Kevin Bacon or at least heard of it. It is a game based on the sociological theory of six degrees of separation, the idea that everyone is on average approximately six steps away by way of introduction, from any other person in the world. Social psychologist Stanley Milgram put the idea of six degrees of separation to the test in the 1960s by asking volunteers to get a message to a random individual living near Boston. The test subjects were asked to send the message to a friend who was more likely than they to know the target person. It took an average of 5.2 people in the chain to get the letter to the target, so because it was over five, the theory rounded up to six degrees apart from any other person on the globe.

Duncan Watts expanded the theory of six degrees of separation to Network Theory, the scientific field that examines how networks form and how they work in society. Network Theory covers many subjects, including:

How people interact socially

How diseases spread

How people find jobs

How aspects of the World Wide Web operate

Using this theory and the QlikView Movie Database available from QlikView in the Getting Started examples section; we are going to play the game Six Degrees of Kevin Bacon as an analysis example. If we understand how to analyze data on this smaller scale, then it should make it easier for us to see ways of using the expanded and refined version, Network Theory, to analyze our own data in ways we might not have seen before.

How to do it...

We start by opening QlikView 11. This time at the start screen, scroll down to the Examples section and select Movie Database. Note that it claims to have over four thousand movies. With approximately four hundred movies produced each year, currently, that represents the equivalent of ten years of recent movies, but the movies in the QlikView Movie Database range from Tillie's Punctured Romance (1914) to movies released in the year 2008. Therefore, we know it is not a comprehensive list of movie titles, directors, and actors.

If you are interested in verifying this for yourself, jump to the Analysis tab of the

QlikView Movie Database.