Qlikview Animation – First Look
Did you know Qlikview can animate your graphs and charts?
This can really help bring your data to life. It also can help point out trends.
This video will show you a little of what qlikview can do.
Please leave a comment below if you would be interested in a tutorial video that would show how to actually create one of these in Qlikview.
Qlikview Map Charts Video
I just created a video showing how to create map charts in qlikview.
It runs a little under 3 minutes.
Pick up the free qlikview software at qlikview.com.
Here is the script data used in the demo:
Data:
LOAD * INLINE [
Country,Population,GDP_PPP_M, latitude, longitude
Albania, 3600523, 19621, 41.153332, 20.168331
Algeria, 33858000, 269201, 28.033886, 1.659626
Argentina, 40301927, 523169, -38.416097, -63.616672
Armenia, 3230100, 17139, 40.069099, 45.038189
Australia, 21446187, 760800, -25.274398, 133.775136
Austria, 8340924, 317800, 47.516231, 14.550072
Azerbaijan, 8629900, 64082, 40.143105, 47.576927
Bahrain, 760168, 24245, 25.930414, 50.637772
];
// Google Maps in QlikView
// V0.9 - October 1st 2008 © Copyright QlikTech International AB 2008 / AES
// Google Maps Key
// get a key here http://code.google.com/apis/maps/signup.html
gmap_key = 'xx';
max_zoom_level = 5; //maximum value 17
// Variables required for calculating map
// No need to change these
var_pi180= '=pi()/180';
var_lat_offset= '0';
var_mc2= '=256*pow(2,$(var_zoom))';
var_mc1= '=256*pow(2,($(var_zoom)-1))';
var_mid_lat= '=min(latitude)+(1+var_lat_offset)*((max(latitude)-min(latitude))/2)';
var_mid_long= '=min(longitude)+(max(longitude)-min(longitude))/2';
var_zoom= '=max(aggr(if(max( round(256*pow(2,(_zoom_level -1)))+( longitude *((256*pow(2,_zoom_level ))/360)) )-min( round(256*pow(2,(_zoom_level -1)))+( longitude *((256*pow(2,_zoom_level ))/360)) )
map_size_x= '400';
map_size_y= '400';
SET HidePrefix='_' ;
// Field required for calcualting best zoom level
_zoom_level:
Load RecNo( ) as _zoom_level autogenerate(max_zoom_level);
maptype:
LOAD * INLINE [
maptype
roadmap
mobile
satellite
terrain
hybrid
];
Good price on Camtasia
— Update on this post 11/15/2010
The software came right away. Nice.
I didn’t need to install it right away as I was still running the trial version and it was working fine.
Last weekend I decided to use the ‘new’ one as the trial was approaching it’s end. When I looked at the box I noticed it was the ‘Academic Upgrade’ version of the software.
It upgraded perfectly, it just wasn’t the version I thought I would be getting. Be warned.
——————– Original post below… ——————–
I just bought the Camtasia Studio software from this company ( link below ) for an amazing price ( $86 – retails $299 ).
www.thenerds.net -Camtasia_Studio_v70
The rumor I heard was that they buy up the ‘older’ version ( 7.0 ) of boxed software when the ‘new’ release ( 7.1 ) comes out. Everyone wants the new one, so they have to discount the boxes that say 7.0.
The 7.1 software can be downloaded for a free upgrade so only the box is out of date.
I will update this if it turns out to be a scam.
Now I have to do something useful with the software…
— Update on this post 11/15/2010
The software came right away. Nice.
I didn’t need to install it right away as I was still running the trial version and it was working fine.
Last weekend I decided to use the ‘new’ one as the trial was approaching it’s end. When I looked at the box I noticed it was the ‘Academic Upgrade’ version of the software.
It upgraded perfectly, it just wasn’t the version I thought I would be getting. Be warned.