Practical QlikView 2 - Beyond Basic QlikView

Practical QlikView 2 is for people who have developed documents with QlikView for at least a few months and are looking for concise instructions on some of the more advanced topics in QlikView Development.

You will be comfortable with the basics of creating QlikView documents and eager to learn more techniques and functions that QlikView has to offer.

Practical QlikView 2 is focussed on the QlikView Desktop and the development of QlikView documents but we will also cover QlikView server topics and creating applications in Visual Studio which can access information in your QlikView server (extra license required for QlikView Server examples). Other topics cover in this book include: Creating Custom Data Sources using QVX. QlikView extensions - examples including Jquery and CSS. Advanced Sheet Objects - such as Dynamic Charts, Trendlines, Sparklines, Custom Chart Formatting and creating links to documents from charts. Alternate States. Advanced Scripting Techniques and functions such as interval match, aggr. Set Analysis/ QVD and Incremental Loading. QlikView table joins. Security using section access and QlikView Server security. Installation and Setup of a QlikView Server (extra license required). Finally QlikView Design tips.

What does QlikView actually do? Although QlikView is becoming more and more popular and even being requested in job advertisements many people might wonder what QlikView actually does. With QlikView you can: -Analyse data in sources such as Excel Spreadsheets, Databases, or text files. -Combine data easily from a variety of sources. -Create charts from your data. -Search through your data very quickly, explore your data easily which can help you make decisions or may just confirm what you thought. QlikView is part of a category of software called 'Business Intelligence'. This is not to say that it cannot be used by people in their everyday lives. This book will cover examples of how you can use QlikView at home or in business. Why should I buy this book? This book will: -Teach you how to create QlikView documents from scratch in easy to understand steps with plenty of screenshots. -Explain how to get data into a QlikView document from a variety of sources such as Excel, text files and databases. -Show you how to create various charts and tables (such as pivot tables) in QlikView. Once you have covered the basics what do you do then? This book provides examples of how you can apply QlikView to do something useful and practical such as analysing computer performance, information from a sql server database or tracking your spending habits. We also provide tips to help in the development of QlikView documents. Finally we look at more advanced topics in QlikView and discuss how to can take the knowledge you have gained further to improve your future whether it is monitoring your own spending or to start using QlikView in your job. The examples in this book use QlikView version 11.

What does QlikView actually do? Although QlikView is becoming more and more popular and even being requested in job advertisements many people might wonder what QlikView actually does. With QlikView you can: -Analyse data in sources such as Excel Spreadsheets, Databases, or text files. -Combine data easily from a variety of sources. -Create charts from your data. -Search through your data very quickly, explore your data easily which can help you make decisions or may just confirm what you thought. QlikView is part of a category of software called 'Business Intelligence'. This is not to say that it cannot be used by people in their everyday lives. This book will cover examples of how you can use QlikView at home or in business. Why should I buy this book? This book will: -Teach you how to create QlikView documents from scratch in easy to understand steps with plenty of screenshots. -Explain how to get data into a QlikView document from a variety of sources such as Excel, text files and databases. -Show you how to create various charts and tables (such as pivot tables) in QlikView. Once you have covered the basics what do you do then? This book provides examples of how you can apply QlikView to do something useful and practical such as analysing computer performance, information from a sql server database or tracking your spending habits. We also provide tips to help in the development of QlikView documents. Finally we look at more advanced topics in QlikView and discuss how to can take the knowledge you have gained further to improve your future whether it is monitoring your own spending or to start using QlikView in your job. The examples in this book use QlikView version 11.