Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Best approach in sales and purchase from supplier link key ?

Hi All

I have a sales table and a supplier table.

I like to create the link key.

My purpose is to check for certain period how much it my sales and supplier purchase ?

my question in order to create link key , i should use filed = date to link both table . Am i correct ?

Paul

3 Replies
jason_michaelid
Honored Contributor II

Re: Best approach in sales and purchase from supplier link key ?

Surely the link between Supplier and Sales will be something like SupplierID?

Not applicable

Re: Re: Best approach in sales and purchase from supplier link key ?

Hi Sir

May i know why you said should link thru supplier ID ?

As for my case my supplier ID only appear in my supplier purchase table. and it does not appear at sales table.

see the enclosed.


Edit :- i think i understand why you suggest link thru supplier ID is the best option , as it will be able to provide a lot of analysis. for example , each items should i can know which supplier we buy from and how much it our purchase price. For my case since my sales order table does not have supplier ID field. so alternative i should link thru date it is correct ?


Paul

MVP
MVP

Re: Best approach in sales and purchase from supplier link key ?

Hi Paul,

Check whether there is any link between

Sales -> Products -> Supplier

Hope this helps you.

Regards,

Jagan.

Community Browser