6 Replies Latest reply: Oct 13, 2016 5:34 AM by Andy Weir RSS

    Creating table in qliksense with datas from multiple table

    Supriya R

      Hi all,

       

      My client table will be

       

      clientID    ClientName

      1                Parlegi

      2                Kitkat

      3                Nescafe

       

      Batch table

      BatchID  BatchName ClientName

      2                batch1        Parlegi

      3                batch2        Parlegi

      4                batch3        Parlegi

      6                batch4        Nescafe

      7                batch4         Kitkat

      8                batch6        Kitkat

      9                batch10       Nescafe

       

      Client Data  Table contains

      clientID    accessedCount    marketCount      Date_created

      1                      2                           2                           2016/2/3

      1                     1                            1                           2016/4/6

      1                     4                            4                             2016/5/7

      2                     5                            8                          2016/2/3

      2                     6                            6                             2016/2/9

      3                     1                            1                              2016/12/1

      1                       2                           1                             2016/11/30

      2                      3                             3                           2016/2/3

       

       

      from all this table   i need to create a single table in qliksense where it contains total of accessedCount  and marketCount for each client with their specific batches, like this

       

       

      Qliksense Table:

      clientID   BatchID   accessedCount      marketCount

      1                2                3                             3

      1                3                2                             1

      1                4                4                             4

      2                7               11                            14

      2                8                3                             3

      3                6                0                              0

      3                9                1                              1

       

      Any suggestion.idea,answers , comments  are all appreciated. Please help me on this.