8 Replies Latest reply: Feb 27, 2017 7:40 AM by Coen Donders RSS

    queries qlik sense

    souhail karoune

      Hi everybody,

       

      I want to ask you, if i can using function NOT EXISTS in qlik sens script with Sub-queries?
      this is the example :  

       

      Villes:

      LOAD VILLETIE,

        GeoKey02,

          capitale,

          CTIE,

          LTIE,

          CPAYS

      FROM [lib://Villes/Villes.xls]

      (biff, embedded labels, table is Sheet1$);

      Load VILLETIE,

        GeoKey02,

          capitale,

          CTIE,

          LTIE,

          CPAYS

      SELECT Villes

        WHERE NOT EXISTS(VILLETIE)

          (SELECT CPAYS, capitale

              FROM Sheet1$

                  WHERE capitale = "OUI");

       

      If 'yes' can you tell me where is the error in my queries?

       

      Best regards.

      souhail karoune