Set analysis or another method to get accurate data

burgersurfer — Wed, 02 Jun 2010 19:13:29 GMT

After a lot of help from this forum, I now have a table with few synthetic keys. Through one of the combined keys, I now have a PRODUCTLEDGER table linked to the SALESTRANSACTIONDETAIL table, as shown in this data structure. But this seems to be wrong, because I have gaps in my data, that must be fixed through either a different key, or through set analysis.I am not sure that a ledger table should link to a detail table like this, but this is how I removed the loop.

When selecting an item in QV from my list of products, I correctly get the transactions for that product (this comes from SALESTRANSACTIONDETAIL). But, in that same selection,I only get the stock on-hand for the sizes where I had sales. I want to see all stock on-hand for the item, whether we had sales on it or not. I tried this with inaccurate results:

sum({$<TD_QTY = >} PL_QTYONHAND)

Any help please?

Set analysis or another method to get accurate data

burgersurfer — Thu, 03 Jun 2010 06:28:56 GMT

Anyone?

Maybe the real question in this is what must the data structure look like, for a Sales>Sales Detail + order>OrderDetail + Purchase>Purchase Detail + Product + Ledger + Store set of tables.

topic Set analysis or another method to get accurate data in QlikView

Set analysis or another method to get accurate data

Set analysis or another method to get accurate data