Index

A

• Asset Management dashboard
  • about / Assets under management (financial investments)
  • URL / Assets under management (financial investments)

C

• CFO dashboard
  • opening / Opening the example CFO dashboard
  • reopening / Reopening the CFO dashboard, Reopening the CFO dashboard, Reopening the CFO example dashboard
• charts
  • trend lines, adding / Trend and forecast lines in charts
  • forecast lines, adding / Trend and forecast lines in charts
• colors, Trending dashboard
  • about / Colors
  • formulas, experimenting with / Experimenting with color formulas
  • obtaining / How to get other colors
  • layout themes / Layout themes
• common size income statement
  • about / Common size income statement
  • creating / Common size income statement

D

• data
  • loading, from Excel / Loading data from Excel
• databases
  • data sources, loading / Loading from databases
• data sources
  • adding / Adding data sources
  • loading, from another QlikView document / Loading from another QlikView document
  • loading, from files / Loading from files
  • loading, from QlikView files / QlikView files
  • loading, from XML files / XML files
  • loading, from HTML files / HTML files
  • loading, from Excel files / Excel files
  • loading, from text files / Text and delimited files
  • loading, from delimited files / Text and delimited files
  • loading, from databases / Loading from databases
• delimited files
  • data sources, loading / Text and delimited files
• development source control integration
  • about / Development source control integration
  • URL / Development source control integration
• document
  • data sources, loading / Loading from another QlikView document

E

• enterprise application
  • securing / Security, deployment, and technology in an enterprise application
  • security / Security
  • deployment / Deployment
  • technology / Technology
• enterprise application, technology
  • data sources / Data sources
  • mobile applications / Mobile applications
• example CFO dashboard
  • reopening / Reopening the example CFO dashboard, Reopening the example CFO dashboard
• Excel
  • data, loading / Loading data from Excel
  • additional data, adding / Adding more data – modifying the load script
  • multiple spreadsheet, loading / Loading more than one spreadsheet
  • order details dashboard, exporting / Export to Excel
• Excel files
  • data sources, loading / Excel files
• expenses dashboard
  • display, analyzing / Analysis of the expenses dashboard display
  • pie chart, minimizing / Minimizing the pie chart
  • line chart, improving / Improving the line chart
  • bar chart formulas / Bar chart formulas
  • pivot table variances, calculating / Pivot table variances
  • formatting / Formatting and linking
  • linking / Formatting and linking
• expression shortcuts
  • about / Expression shortcuts
• eXtensible Markup Language (XML)
  • about / Data sources

F

• files
  • data sources, loading / Loading from files
• File Transfer Protocol (FTP)
  • about / Loading from databases
• financial KPIs
  • Return on Assets (ROA) / What are the three most common financial KPIs?
  • Return on Investment (ROI) / What are the three most common financial KPIs?
  • Return on Equity (ROE) / What are the three most common financial KPIs?
• fixed asset management
  • about / Fixed asset management
• forecast line
  • adding, in charts / Trend and forecast lines in charts
  • trend line, extending into / Extending a trend line into a forecast line
• four-quadrant layout
  • delving / Delving into the four-quadrant layout

H

• HTML files
  • data sources, loading / HTML files

I

• information sharing
  • with business associates / Sharing QlikView information with business associates
  • licensing / Licensing and servers, Licensing
  • servers / Licensing and servers
  • QlikView Business Servers / QlikView business servers
• inventory dashboard
  • Inventory On Hand Report / Inventory on hand
  • about / The nuts and bolts of the Inventory dashboard
  • pivot table / The pivot table
  • inventory profile ranges, creating / Creating the inventory profile ranges
• Inventory On Hand Report
  • about / Inventory on hand
  • Inventory profile / Inventory profile
  • on time delivery / On time delivery
• inventory tab
  • advantages / The good and bad of the Inventory tab
  • disadvantages / The good and bad of the Inventory tab
  • inventory turnover / What is inventory turnover?
  • URL / What is inventory turnover?
  • dashboard level, other measures / Other measures at the dashboard level

K

• KPIs
  • about / What are key performance indicators?
  • financial KPIs / What are the three most common financial KPIs?
• KPIs tab
  • about / The KPIs tab in a nutshell
  • Sheet objects, delving into / Delving into sheet objects
  • script, loading / Load script for the KPIs dashboard tab

L

• layout themes, Trending dashboard
  • about / Layout themes
  • creating / Creating your own theme
  • applying / Applying your new theme
  • applying, to whole document / Applying a theme to a whole document
  • applying, to sheet / Applying a theme to a sheet
  • applying, to sheet object / Applying a theme to a sheet object

M

• mathematical operators
  • about / Mathematical and set operators

N

• NTLM (Windows NT LAN Manager)
  • about / Security

O

• Open DataBase Connectivity (ODBC)
  • about / Data sources
• order details dashboard
  • analyzing / Analyzing the order details dashboard display
  • about / Analyzing the order details dashboard display
  • order and inventory management, comparing / Comparing the order and inventory management online demonstration
  • reference link / Comparing the order and inventory management online demonstration
  • properties, setting / The nuts and bolts of the CFO dashboard order detail tab
  • exporting, to Excel / Export to Excel
  • coding data, coloring / Color-coding data
  • number format patterns / Number format patterns
  • Dynamic Expressions, calculating / Dynamic expressions

Q

• QlikCommunity
  • about / QlikCommunity
  • URL / QlikCommunity
• Qlik Sense
  • about / Delving into Qlik Sense
• QlikView
  • usage / When do we use QlikView?
  • URL / Downloading and installing QlikView
  • downloading / Downloading and installing QlikView
  • installing / Downloading and installing QlikView
  • for financial insight / Becoming familiar with QlikView
  • opening / Opening and examining QlikView
  • examining / Opening and examining QlikView
  • data, loading from Excel / Loading data from Excel
  • used, for analysis / How QlikView works for analysis – finding the out of balance
  • demo site, URL / Assets under management (financial investments)
  • reference manual / QlikView Reference Manual
• QlikView Business Servers
  • about / QlikView business servers
  • URL / QlikView business servers
• QlikView data exchange (QVX)
  • about / Data sources
• QlikView files
  • data sources, loading / QlikView files
• QlikView Help / How to get other colors

R

• reference manual
  • about / QlikView Reference Manual
• RGB visual basic code
  • URL / How to get other colors

S

• sales, as KPI
  • displaying / Display sales as a KPI
  • Return on Assets (ROA), adding / Adding ROI, ROA, and ROE into a QlikView dashboard
  • Return on Investment (ROI), adding / Adding ROI, ROA, and ROE into a QlikView dashboard
  • Return on Equity (ROE), adding / Adding ROI, ROA, and ROE into a QlikView dashboard
  • set expressions, building / Building our set expressions
  • expression shortcuts / Expression shortcuts
  • mathematical operators / Mathematical and set operators
  • set operators / Mathematical and set operators
  • three-KPI display, creating / Creating our three-KPI display
• sales analysis dashboard
  • about / The nuts and bolts of the sales analysis dashboard
  • group button / The group button
  • containers / Containers
  • improving / Improving the sales analysis dashboard
  • sales analysis tab, creating / Steps to create a new sales analysis tab
  • new variable, creating / Creating a new variable
  • interface, for new variable / An interface for the new variable
  • new variable, applying / Applying the new variable
  • container, adding with multi boxes / Adding a container with multi boxes
  • chart, moving / Moving and changing the chart
  • chart, changing / Moving and changing the chart
• sales analysis tab
  • about / The sales analysis tab in a nutshell
  • table display / The table display
  • chart display / The chart display
• set expressions
  • building / Building our set expressions
• set operators
  • about / Mathematical and set operators
• Sheet objects, KPIs tab
  • first Text object / Delving into sheet objects
  • delving into / Delving into sheet objects
  • second Text object / Delving into sheet objects
  • third Text object / The third text object in the first row
  • second row of Sheet objects / The second row of sheet objects
  • third row of sheet objects / The third row of sheet objects

T

• text files
  • data sources, loading / Text and delimited files
• Text object
  • action types / The third text object in the first row
• Text objects
  • about / Delving into sheet objects
  • in first row / Delving into sheet objects
• three-KPI display
  • creating / Creating our three-KPI display
• Trending dashboard
  • about / The nuts and bolts of the trending dashboard
  • colors / Colors
• trend line
  • adding, in charts / Trend and forecast lines in charts
  • adding, to chart monthly sales and margin / Adding a trend line to the monthly sales and margin chart
  • basing, on existing measure / Basing a trend line on an existing measure
  • extending, into forecast line / Extending a trend line into a forecast line

W

• What If? dashboard
  • about / The nuts and bolts of the What If? dashboard

X

• XML files
  • data sources, loading / XML files