How To Install Netflix in Ubuntu 12.10

Until recently, watching Netflix on Linux was not possible since Silverlight was not available on Linux. Finally, Netflix is available in Ubuntu 12.10 in the form an unofficial app. I have used it and it works great.
Installing Netflix on Ubuntu 12.10 is quite simple.

Here are the steps:

1. Open up a terminal window
2. Type sudo apt-add-repository ppa:ehoover/compholio and hit Enter
3. Issue the command sudo apt-get update
4. Issue the command sudo apt-get install netflix-desktop
5. Say OK to dependencies and Installation will begin.

Depending on the network speed, this could take some time. Once that’s over.

1. Open the Unity Dash
2. Type netflix  and NetFlix app will appear.
3. Click on the Icon and Enjoy your movies!

Note this is a work around and  not an official app from Netflix and is not supported from Netflix.

Line Chart Trick to Avoid Horizontal Scroll Bar

Often line chart in Qlikview apps  are displayed partially due to space limit on the sheet. When the chart is stretched the the lines starts appearing completely.
To make the lines on the chart appear completely either chart needs to stretched or chart properties needs to updated to have horizontal scroll bar (presentation tab).
Horizontal scrolls works most of the time but they are annoying sometimes.
Do you want to display the line on the chart completely without stretching or scroll bars?
Follow the simple trick to cheat Qlikview to make it display complete chart without horizontal scroll bars.

1) Right  click on the line chart and open the Properties.
2) In General , select Bar Chart as Chart Type
3) In Presentation tab,  select"Show All Bars" check box.
4) Now, go back to General tab and select Line Chart as Chart Type.
5) Click OK

Line chart now displays complete line and horizontal scroll bar is suppressed.

Hope this helps!

Alternative to Count Distinct

Count distinct "Count( Distinct <Field Name>)" is an expensive expresssion in Qlikview. Whenever used, it turns Qlikview to use single core instead of multi-cores resulting in slow performance of the app.
By making a small change in data model we can replace COUNT DISSTINCT with SUM function and improve the app performance marginally and increase app response time to users actions.
To achive this add another field in Qlikview table having value 1 along with the field you need to count.

Example:

Bookings:
LOAD
    [Member Id],
    [Booked Date],
    [Transaction Id],
    [Booking Amount]
FROM Bookings.qvd (qvd);

"Member Count":
LOAD
    [Member Id],
    1 AS "Unique Members"
Resident Bookings;

To count distinct members
COUNT(DISTINCT [Member Id]) can be replaced with SUM([Unique Members]).