7 Replies Latest reply: Apr 12, 2015 7:41 AM by Michael Solomovich RSS

    Writing SQL scripts in qlikview editor

      Hi,

       

      i have imported a few tables (by importing excel files) in a qlikview script and want to perform some more tasks such as aggregations at various levels.

       

      Do I need to use the Load syntax or is there a way to use the SQL syntax ?

       

      For example, I would like to write the following SQL:

       

      Create table XXX as

      select country, sum(sales)

      from YYY

      where item_code in (Select item_code from ZZZ)

      group by country;