Qlik Community

Qlik Design Blog

All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.

A Historical Odyssey: QlikView 4 and the first Server

 

QlikView 3 was a giant leap forward. More and more people started developing applications with QlikView and it became much easier to convince prospects and partners to join us on our journey. As a result we faced more and more demands from the real world: tools with which you can customize a document, tools for security, tools to save and re-use a selection, client/server, etc. Much of this didn’t exist in QlikView 3.

 

QV04 Opening screen.png

 

So, for QlikView 4 we started to develop features based heavily on customer requirements.

 

We had already experimented a little with macros in QlikView 3 but in QlikView 4 we did it properly. We introduced the first color coding in pivot tables so that our customers could mark negative numbers red. We made it possible to activate several objects and align them. We made it possible to load Excel files. We introduced control structures such as For-Next loops in the script language. We introduced Section Access to address security demands. We introduced bookmarks. We introduced a proper NULL value handling and we introduced the text object, so that customers could show also static information.

 

We also had a new logo and a new icon.

 

QV04 Icon.png

 

But there are two features that, more than any others should be noted as the principal features in QlikView 4:

QV04 Chart properties.png

  • The chart engine.
    With QlikView 4, you could write any expression as an aggregation and QlikView would be able to evaluate it on the fly. This is true still today; you can have an expression with several arbitrary fields, where the fields reside in different tables, and then aggregate this expression. The aggregate can in turn be used in a new expression that uses other aggregations with fields from yet other tables, e.g., Sum(x*y)/Count(z). QlikView evaluates this expression correctly. This feature is unique to QlikView and is the core of one of QlikTech’s patents.

 

 

  • The Server.
    The second major advancement in QlikView 4 was the client-server capability. It was then called QlikView Web Solution. Compared to the QlikView Server of today, it was rudimentary. But it was a first step and some of the structure is still the same. Application development, then, was done just as it is today: on a standalone QlikView. QV04 Web Solution.pngThe file could then be copied to the server. The only client that existed then was a Java client talking directly to the server. The server had to have Microsoft IIS (Internet Information Server) installed and the client had to have Microsoft Java installed. This meant that in practice we only supported Microsoft environments, both on the client and on the server side.

 

As I think back on it, it was really with QlikView 4 that we started our journey toward being an enterprise software product.

 

HIC

 

Further reading on the Qlik history:

A Historical Odyssey: QlikView 3

A Historical Odyssey: QlikView 5 and the Rainbow Border

A Historical Odyssey: The Doctors’ Special

7 Comments
Not applicable

What year was that?

0 Likes
150 Views

1999

0 Likes
150 Views
MVP & Luminary
MVP & Luminary

Really enjoying these posts.  It would be great to have an expanded version in hard-back.  A nice coffee table book to browse through.  Thanks Henric!

0 Likes
150 Views

Thank you for these appreciating words. I will try to continue the same way.

HIC

Previous posts in the Historical Odyssey:

Initial post

QLIK

QlikView 1

QlikView 2

QlikView 3

0 Likes
150 Views
Luminary
Luminary

Very interesting series of posts. Thank you for sharing them.

Cheers,

DV

0 Likes
150 Views

Paul

Our vision for future versions is quite clear: We think that business intelligence will be more and more user centric. The needs of the user will be in focus and the technology will support the user exploring data freely and creating his own analysis. User empowerment. Also, business intelligence will be used by everyone - not just managers and controllers.

Further, we think that business intelligence is changing into something new - something different from tools just answering questions. It is just as much about exploring data, discovering new things and finding the new questions. We call this business discovery.

Read more about our themes for the next QlikView versions on the Business Discovery blog:

Gorgeous and Genius

The Premier Platform

HIC

0 Likes
150 Views
santiago_respane
Valued Contributor

Thanks again, its amazing to know QV history!

0 Likes
150 Views