what is the main purpose of AQL in qlikview

[#1]

what is the main purpose of AQL in qlikview

[svenkita · Accepted solution]

Check this link

What is AQL? How It  behavior in QlikView?

AQL is a query language based on a data base management system which uses Codd's relational model of data. It has been designed mainly to be used by the nonspecialist in data processing for interactive problem solving, application building, and simulation. Ease of use is achieved by providing an interface which allows the use of default options, synonyms, and definitions of attributes, inference, and the possibility of interactive completion of the query (i.e., menu). AQL combines the capabilities of the relational model of data with the powerful computational facilities and control structure of the host programming language (i.e., APL). A prototype version of AQL, which has been implemented, is reviewed.

[sushil353]

Hi,

Hope this will help you: How AQL realy works? QV vs Tradicional BI? Advantages and disadvantages?

[svenkita]

Associate Query Logic QlikView is based upon patented technology called Associative Query Logic (AQL). AQL enables QlikView to work with millions of cells and still respond to queries in less than a second. High-speed associations occur as the user clicks in the various sheet objects, and the display is updated immediately. By replacing resource intensive relational joins with AQL, QlikView removes the need to pre-aggregate data for most applications. In Online Analytical Processing (OLAP) applications, QlikView removes the need to define complex dimensional hierarchies and generate cubes. QlikView performs calculations on the fly, allowing any user to become a sophisticated knowledge worker.

[ToniKautto]

This question has been asked and answered several times before. Please search the community before asking questions. I have now closed this thread.