Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Qlikview for Finance

You're reading from   Qlikview for Finance Concoct dynamic business intelligence dashboards for financial analysis with QlikView

Arrow left icon
Product type Paperback
Published in Sep 2015
Publisher
ISBN-13 9781784395742
Length 174 pages
Edition 1st Edition
Arrow right icon
Toc

Table of Contents (12) Chapters Close

Preface 1. Getting That Financial Data into QlikView FREE CHAPTER 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 $19.99/month. Cancel anytime