1 Reply Latest reply: Jul 29, 2015 12:19 AM by Tresesco B RSS

    one to many relationship

      Hello everyone,

       

      I'm a new learner in qlikview.

      I have a key in two tables...with one to many relationship.

       

      Can someone throw some limelight on how to go ahead in qlikview.

       

      I have to perform Sum() Count() operations in the report with values touching both the tables..

        • Re: one to many relationship
          Tresesco B

          One to many relationship is good in qv. You can directly load the tables in qv and perform any operation like sum/count on it. Like:

           

          Master:

          Load * inline [

          ID, ProdName, UnitPrice

          1, Shoe, 100

          2, Shirt, 200

          3, Belt, 50

          ];

          Tans:

          Load * inline [

          ID, Date, SoldQty

          1, 07-29-2015, 20

          1, 07-28-2015, 5

          1, 07-27-2015, 7

          2, 07-29-2015, 30

          2, 07-28-2015, 05

          ]

          Then in the front-end use sum() or so.

          PFA