QlikView Tech Tips #1

Advanced Scatter Chart Design

Many Thanks to Alex Boyko and Luxoft Company for materials to this post

Challenge:  

1. to display invoices amount as a bubble grid
2. bubble size correspond to amount value
3. three different invoice statuses must be shown separately
4. display custom horizontal lines
5. display additional parameters to the bubble hints (on mouse over pop-up window)

PIC 001

PIC 002

Having fields : 

• Amount with VAT
• Status: Paid, Waiting, Due, Overdue
• Payment Lag

Challenge #1 Solution:

1. Prepare Loading script in the Script Editor. See PIC 003
2. Add new Chart Element. See PIC 004
3. Select Scatter Chart. See PIC 005
4. Add Dimensions
5. Add Trellis configuration to separate chart with Status - use Status Dimension

PIC 003

PIC 004

PIC 005

PIC 006

PIC 007