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

The nuts and bolts of the sales analysis dashboard


We will now start looking at the components that make up the Sales Analysis dashboard so that we can leverage them to make improvements.

The group button

Although the text title on the left-hand side of the straight table (Segment Change in Revenue vs Last Year) does not change, you can change what is displayed in the straight table, Segment Changes in Revenue, using the Group button in the upper left corner of the table (see Figure 5-3):

Figure 5-3: The Dimension Selection button in the straight table

This button looks like a circular arrow; if you hover over it, the word Cycle pops up in a box. The button allows you to scroll through group measures selected for the table. Provided at least two or more expressions are available to create a group, the Group button can be used in transforming merged group expressions of dimensions or measures into one or more cyclic groups.

In the QlikView layout, you can cycle through the expressions belonging...

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