how can i create LinkTable from 2 Table in QVD

[#1]

Hi,

I have two different Table:

OrderTable (has 20 Field For Example)

SalesDocId

CreateOrder as Datum

Linenr.

NetVal

DeliveryCharges

BillingTable (has 35 Field for Example)

SalesDocId

CreateBill as Datum

BillingNr.

NetSales

BillingType

Tax

Calendar (as normal Calendar)

Date

Week

Day

I will create LinkTabel in Qlikview :

Sales DocId (when (Sales DocId from OrderTable) = Sales DocId from BillingTable)

KeyDatum(when CreateOrder from OrderTable = CreateBill from BillingTable)

Where

BillingType from BillingTable = ZBV or ZCR1

distinct Sales DocId

When the LinkTable is Create, I will link KeyDatum to Calendar for crate a formula to Count SalesDocId from LinkTable with CalenderDatum:

Thanks

Shideh

[disqr_rm]

Check this out:

http://www.naturalsynergies.com/LinkTable85_Qonnections.ppt

Phil has put together a very nice presentation on this one.

[#3]

Hi,

Thank s for your Help.

Shideh

[#4]

Hi rakesh,

Do u have the example

Link Table85_Exercise.qvw which is referred in the PPT. I could not find it.
Thanks in advance..

Sravan

[#5]

Hi Sravan,

do you found any example?

Thanks

Shideh

[#6]

Hallo Shideh,

No I did not find the said example..