Search icon
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Qlikview for Finance

You're reading from  Qlikview for Finance

Product type Book
Published in Sep 2015
Publisher
ISBN-13 9781784395742
Pages 174 pages
Edition 1st Edition
Languages

Table of Contents (18) Chapters

QlikView for Finance
Credits
Disclaimer
About the Author
About the Reviewers
www.PacktPub.com
Preface
1. Getting That Financial Data into QlikView 2. QlikView Dashboard Financial KPIs 3. KPIs in the Financial Officer QlikView Dashboard 4. QlikView Asset Management with Multiple Data Sources 5. QlikView Sales Analysis 6. QlikView Forecasting and Trends 7. QlikView Inventory Analysis 8. QlikView Order Details Dashboard 9. QlikView Expenses Dashboard 10. Sharing Your QlikView Insights Index

Analysis of the expenses dashboard display


The Expenses dashboard is another four-quadrant dashboard with a Pivot Table on the upper right-hand side, surrounded by three graphs analyzing essentially the same data in different formats. The pivot table is organized by the Cost Center group and reports in thousands, as the title clearly states. It is well-organized with fairly standard income-expense statement section type columns. Therefore, we can see the 2011 expenses as compared to the budget and the previous year, with the variance in both dollars and percentages. The unfavorable variances are the positive numbers shown in red; those columns must be formatted in Properties so that the text for those numbers is set to red when the value is greater than zero. This is just the opposite of the setting used in the previous chapter covering the Order Details tab. My preference would be to only have the pivot table and to have more detailed information loaded so that we can drill-down on the...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime}