First look at Qlikview beta 9.0

Posted by William on 25/03/2009 under Articles | 8 Comments to Read

Finally I caught up in the Qlikview 9 beta program and I’m glad to share my first experiences from version 9 with you. I will discuss some improvement points of Qlikview 9 and my overall experience.
Read more of this article »

Qlikview 9 in Beta

Posted by Gilles on 13/03/2009 under Articles | Be the First to Comment

Qlikview 9 is in Beta. We are trying to enroll in the beta program and come up with our own conclusions. In the mean while we’ll show you some other qlikview bloggers conclusions. BI Commons has a pretty comprehensive post on new features in three parts.

Part 1: updates and new functionalities about licensing, the server, mobile functionalities, performance, scripts, front end and data visualisations.
Part 2:  sparklines one of the new visualisations
Part 3: Trellis charts another new visualisation

And points beyond writes about it here where the most liked new features by Jay Jokosky are written down

Read more of this article »

Qlikview Scripting Tips Part 6: General Tips & Tricks

Posted by Gilles on under How To | Be the First to Comment

excerpt from QlikNews Issue 8:

Tip 1: Search Settings
On the User Preferences > Properties General page, there is an area with“Search Settings.” Here you can switch between including excluded values in your search or not. In the first case, you can search over all values regardless of state. The alternative setting is when you want to “drill down” and search only the results of a previous search

Tip 2: Working with large documents
When handling large documents, the time spent opening and saving documents can become a little annoying. Instead, you can keep a limited-data (reduced) document and the script as separate files. This saves time when troubleshooting a document and when making changes in script and layout.

Tip 3: Variable for repeated expressions
Some expressions have a tendency to repeat over many objects. These expressions can be replaced with a variable so that one variable represents all the occurrences of the expression. (e.g. var1=sum(xyz); replace sum(xyz) with $(var1)). Read more of this article »

The software engineering process explained

Posted by Gilles on 10/03/2009 under Nice Reads | Be the First to Comment

'Twas the night before implementation and all through the house,
  Not a program was working not even a browse.
The programmers hung by their tubes in despair,
  with hopes that a miracle would soon be there.
The users were nestled all sung in their beds,
  while visions of inquiries danced in their heads.
When out in the machine room there arose such a clatter,
  I sprang from my desk to see what was the matter.
And what to my wondering eyes should appear,
  but a super programmer (with a six-pack of beer).
His resume glowed with experience so rare,
  he turned out great code with a bit-pusher's flair.
More rapid than eagles, his programs they came,
  and he cursed and muttered and called them by name:
On update! on add! on inquiry! on delete!
  on batch jobs! on closing! on functions complete!
His eyes were glazed-over, fingers nimble and lean,
  from weekends and nights in front of a screen.
A wink of his eye, and a twitch of his head,
  soon gave me to know I had nothing to dread.
He spoke not a word, but went straight to his work,
  turning specs into code; then turned with a jerk;
And laying his finger upon the "ENTER" key,
  the systems came up and worked perfectly.
The updates updated; the deletes, they deleted;
  the inquiries inquired, and closings completed.
He tested each whistle, and tested each bell,
  with nary an abend, and all had gone well.
The system was finished, the tests were concluded.
  The users' last changes were even included.
And the user exclaimed with a snarl and a taunt,
  "It's just what I asked for, but not what I want!"

Is it that Informatica needs a frontend or that Qlikview needs a datawarehouse?

Posted by Gilles on 06/03/2009 under Articles, News | 6 Comments to Read

In this press release: http://www.prweb.com/releases/informatica/zyme/prweb2209914.htm you can read that a channel intelligence solution from Zyme uses qlikview in combination with  informatica for its solution.

Qliktechs aggressive marketing and sales always told me that there’s no need for a datawarehouse when using qlikview. So it seems strange that Zyme chooses to do so.  Or is it that Informatica doesn’t have a solid solution for analyzing business data? But then again why not only use qlikview?

Maybe (and I think you do!) you do need a platform which can handle data from heterogenous sources, which can transform your data to uniform definitions, which can treat history, which can do cleansing and enrichment of your data and then you use qlikview for your analysis and some other product in conjunction for your reports!

So that’s where I position qlikview, as a frontend solution, for analyzing data that’s in a solidly built datawarehouse.  

Please feel free to share your insights on this! Where do you position Qlikview? As the all in one solution (DWH and BI) or as a frontend BI tool?

Get Adobe Flash playerPlugin by wpburn.com wordpress themes