3 Replies Latest reply: Jan 16, 2013 4:14 AM by Klaus Kring RSS

    Using the new SQL() function

      I am using the new version of QlikView since I have tables with billions of lines of data that I don't want to have to load using memory.


      The new SQL function seems very powerful since you can do active queries on data, I just don't understand how extensive of a query we can put in the SQL() function.


      I would like to do something similar to set analysis, where you can pull back values associated only with certain names, for example


      SQL('value WHERE name="Fred"')


      Is this possible? Are there any details about this new function anywhere?


      Thanks in advance.