QlikView Tech Tips #2

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 #2-4 Solution:

1. Configure chart Expressions in the Advanced Mode. See PIC 003
2. Configure 3 three fields: 1- X axis, 2 - Y axis, 3 - bubble size. See PIC 004
3. Configure bubbles color - relates to the Status (Paid, Waiting, Due, Overdue). See PIC 005
4. Add expression statement for custom hint line. See PIC 006
5. Only first 3 mandatory Expression are used for Chart display, any other optional Expression used  for Hint information
6. Add one more hint expression - use Hint field as a datasource
7. Select "Text as Pop-up" option
8. Add sorting based on Status field. See PIC 007
9. Configure chart elements type. See PIC 008
10. Add expression statement for Reference Line. See PIC 009

PIC 003

PIC 004

PIC 005

PIC 006

PIC 007

PIC 008

PIC 009