3 Replies Latest reply: Dec 1, 2015 4:49 AM by Christoph Daetz RSS

    Loading specific data

    Christoph Daetz

      Hi all,

       

      in our Company we started with Qlikview now and the only help is a book for developers     

      So hopefully you can help me a little bit...

       

      I have a main data and want to load a second table now, but not the whole table.

       

      My Syntax:

       

      [Text];
      LOAD Kostenart,
                  Sprache,
                  Beschreibung

      FROM
      CSKU.xlsx
      (ooxml, embedded labels, table is Tabelle1)
      Where Exists (Kostenart);

       

      It is a table with translations for a lot of languages.

      Is it possible to load only the data, where "Sprache" is filled with "DE"?

       

      Thanks a lot!