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.

       

      -Homer