AQL document request

Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone, i want to ask anyone if it's possible to have the document of AQL (Associative Query Language), help me to learn expression on QV because i have the problem to understand the expression.

Thanks,

-Sunil

Re: AQL document request

ramasaisaksoft — Tue, 19 Sep 2017 07:25:47 GMT

AQL was an abbreviation used many years ago, but with little relevance to the technical design of QlikView. Documents about AQL are either very old or written by non QlikTech people. So, I think the discussion would improve if we stopped using this abbreviation.

The important points about QlikView are

QlikView internally uses a relational model. And this is determined by the script. (So here you - developer - need to think a lot about the relational schema.)
QlikView doesn't care about whether a key is primary or secondary - it just links the fields that have same names, assuming that they are keys. (So here you - developer - need to define the keys by naming them correctly.)
A selection in a field propagates to other fields also in other tables, thus determining whether a record or a field value is possible or not.
Possible records are aggregated in all QlikView expressions. Non-possible records are not included in the calculation.

And that's basically it. Read more here:

http://community.qlik.com/blogs/qlikviewdesignblog/2012/11/20/symbol-tables-and-bit-stuffed-pointers

http://community.qlik.com/blogs/qlikviewdesignblog/2013/01/15/states-and-state-vectors

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/15/logical-inference-and-aggregations

topic Re: AQL document request in QlikView

AQL document request

Re: AQL document request