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

The nuts and bolts of the Inventory dashboard


Now, we will look at the object components of the Inventory dashboard. When we click on the white area of our sheet object, we can see that again we have a container object, but this container only contains text and lines and two list boxes, one for the fiscal year and one for the fiscal month. What about the charts? Also, what is that looking like a complicated list box in the right-hand side quadrant?

The pivot table

When we open the properties of the object in the upper-right-hand side corner, the Inventory On Hand Report, we can see that the object is actually a Pivot Table. We have not worked with a Pivot Table object before:

Figure 7-5: Closeup of the Pivot Table icon on the General tab

Since this is the first time that we have worked with a Pivot Table, open Properties by right-clicking and choosing Properties in the context menu so that we can see what is unique about a Pivot Table object.

On the Dimensions tab, we can see that we are using...

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}