9 Replies Latest reply: Aug 5, 2014 11:21 AM by Miguel Angel Baeyens de Arce RSS

    "Concatenate" does not work as expected

    Christian Moke

      Hey Qlik-guys (and ofcourse -girls),

       

      although I'm working with QlikView in Germany as a Developer and User since five years, this is my first posting in this wonderful community.

       

      Yesterday I downloaded Qlik Sense for my private use, so I can test it at home before I will test it for our existing data models in our company.

       

      My private data model (about Formula 1) contains separate crosstables from Excel like this:

       

      >>>>>>>>>>>>>>>>>>>>>>>>>>>>>

      Ergebnisse:

      Crosstable(Typ, Tipp, 2)

      Load

           Rennen,

           '2014' as YearRace,

           [2],

           [3],

           [4]

      From Datasource_2014.xlsx

      (ooxml, embedded labels, table is QV4);

       

      Store Ergebnisse into Ergebnisse_2014;

       

      drop table Ergebnisse;

       

      Ergebnisse:

      Crosstable(Typ, Tipp, 2)

      Load

           Rennen,

           '2013' as YearRace,

           [2],

           [3],

           [4]

      From Datasource_2013.xlsx

      (ooxml, embedded labels, table is QV4);

       

      Store Ergebnisse into Ergebnisse_2013;

       

      drop table Ergebnisse;

       

      >>>>>>>>>>>>>>>>>>>>>>>>>>>>

       

       

      These steps I have for six years and this works in Sense without any problems.

       

      But in the next step I want to combine these separate Year-Tables to only one Complete Table:

       

       

      >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

      Kombination:

      Load

            *

      From Ergebnisse_2014.qvd (qvd);

       

      concatenate

      Load

            *

      From Ergebnisse_2013.qvd (qvd);

      >>>>>>>>>>>>>>>>>>>>>>>>>>>>>

       

      In the first QVD are 260 rows and after concatenating with the second QVD there are only the same 260 rows and no row from the 2013 file has been concatenated.

       

      Is this a bug or where is my mistake?

       

      Thanks for your help - I already love Dashboard Designing with Qlik Sense, it's much more comfortable as in AJAX.

      Best regards

      Christian Moke