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

    Writing SQL scripts in qlikview editor

    Ashmeet Thukral



      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;