one to many relationship

[#1]

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..

[tresesco]

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