one to many relationship

Wed, 29 Jul 2015 02:34:53 GMT

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

tresB — Wed, 29 Jul 2015 04:19:02 GMT

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

topic Re: one to many relationship in QlikView

one to many relationship

Re: one to many relationship