topic Re: how to remove synthetic key in QlikView

how to remove synthetic key

Tue, 09 Jun 2015 10:58:05 GMT

how to remove synthetic key present in this table where opn_stck is opening stock

i have created a link table ,but it gives a wrong output

Re: how to remove synthetic key

giakoum — Tue, 09 Jun 2015 11:13:46 GMT

you need to find out which fields uniquely link your tables.

use only store code to link the showroom table for example. drop entity. If a store is uniquely identified by both store code and entity, create a composite key with the two and drop the rest of the fields.

Same for opening and sales. Looks like they are both fact tables, so concatenate them.

See attached for more guidelines

Re: how to remove synthetic key

ankitaag — Tue, 09 Jun 2015 11:16:39 GMT

Hi Shweta,

Why link tabe is not giving you right result.

I suppose it is the good option. create keys in Item Master, Showroom, Sales and Opening table and link the same with keys present in Link tables

Re: how to remove synthetic key

ankitaag — Tue, 09 Jun 2015 11:18:12 GMT

If you feel and find that concatenating Opening with Sales doesnt give you wrrong opening qty then yes, the best option is to concatenate these two fact tables

Re: how to remove synthetic key

vcanale — Tue, 09 Jun 2015 11:32:57 GMT

Hi,

You can try to create a key field and join the two tables

Re: how to remove synthetic key

Anonymous — Fri, 15 Jan 2016 10:04:37 GMT

I am looking for the best practices in QV. Thank for the documentations really useful.

Claudia