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

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

Ubuntu 9.10 Install Cannon LBP3000

Situation:
Network Cannon LBP 3000 printer connected to remote machine in the Windows domain

Task:
Be able to use the printer from the Ubuntu 9.10 amd6. Ubuntu host is not in the Windows domain

Problems:
No predefined drivers for LBP3000 in the Ubuntu 9.10 installation.

Solution:
- Download the most fresh drivers from the Cannon website (use Australian website). In my case version 2.00.x
- There are 2 .deb files for i386 in the installation archive.
- To install them use

sudo dpkg --force-architecture -i <.deb file>

- Restart CUPS

sudo /etc/init.d/cups restart

Go System->Printing->Add PrInter->Windows Printing via SAMBA
Specify smb:// path to the printer
Specify Authentication. Username with Domain if needed


See references for further details 

References:

1. http://ubuntuforums.org/showthread.php?t=134937
2. http://www.canon.com.au/en-AU/Support-Services
3. http://ubuntuforums.org/showthread.php?p=1356211
4. https://help.ubuntu.com/community/HardwareSupportComponentsPrinters/CanonPrinters/Canon_LBP_2900
5. http://ubuntuforums.org/showthread.php?t=267168