1 Reply Latest reply: Jan 6, 2016 7:09 AM by Marcus Sommer RSS

    Help with keys / tables

    Daniel Mann

      Good Evening everyone,

       

      I need your help as I am getting very confused with keys and associations.

       

      I have 13 tables each of which contain the columns Year, Month & Ship.

       

      When I loaded the data into the system, it generated a synthetic key table.

       

      Now when I am creating graphs based on Month I am getting odd results, sometimes the Months are not ordered correctly, sometimes I am getting a new bar names ' - ' which I can get rid of if I deselect null values, but I don't have any null values in the table data.

       

      Am I doing something wrong?

        • Re: Help with keys / tables
          Marcus Sommer

          If your tables contain the same content or at least are quite familiar together then it's often the best to concatenate these tables, like:

           

          t_match:

          Load * From t1;

               concatenate

          Load * From t2;

               concatenate

          Load * From t3;

          ....

           

          Commenly used are also combined keys between the tables to avoid the synthetic keys, like:

           

          Year & '|' & Month & '|' & Ship as KEY

           

          whereby I do not believe that those approach will be really suitable for you with 13 tables.

           

          Many good postings about how to develop datamodels could you find here:

           

          Get started with developing qlik datamodels.

           

          - Marcus