topic Re: link between tables in QlikView

link between tables

Anonymous — Tue, 08 Dec 2015 12:16:34 GMT

I have the following script

QV 
Vente:
LOAD
 [Code Site]
      ,[Code Article]
,date
.....

from vente

How could I integrate the following query

SELECT [Code Site]
      ,[Code Article]
      ,[PrixVente]
      ,[Date debut]
      ,[Date fin ]
  FROM [dbo].[PrixVentePermanent]

How could I use intermatch and applymap to link between vente and prixventepermanent where vente.codesite=prixventepernent.codesite and [pPvente.codearticle=prixventepernent.codearticle

and vente.date between date debut and date fin ?

Re: link between tables

Peter_Cammaert — Tue, 08 Dec 2015 12:24:15 GMT

Like this?

INTERVALMATCH(date, [Code Site], [Code Article])

LOAD [Date debut], [Date fin], [Code Site], [Code Article];

SELECT ...

FROM ...;

This will create a synthetic key (no danger there). You can perform a LEFT JOIN twice to add PrixVente into table Vente.

Best,

Peter

Re: link between tables

Anonymous — Tue, 08 Dec 2015 12:29:01 GMT

see this, will be helpful for you:

IntervalMatch