topic Re: Duplicate values due to Item Code in QlikView

Duplicate values due to Item Code

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I getting stuck here with the item code .

I getting duplicate values against item code when I remove Item code from chart then i am come to near my output but here is also I am missing my Shipment No. SHGO316/000207

Here I am missing Shipment No. SHGO316/000207

Pfa qvw attachment with expected output.

Can anyone help me out.

Thanks

Re: Duplicate values due to Item Code

tresB — Thu, 23 Mar 2017 07:20:58 GMT

Like this?

Re: Duplicate values due to Item Code

Anonymous — Thu, 23 Mar 2017 07:25:11 GMT

But when I add Item code here then why values getting duplicate.

But i need to show quantity in Expression

Any Suggestion ???

Re: Duplicate values due to Item Code

tresB — Thu, 23 Mar 2017 08:16:58 GMT

I don't see Item_Code in your expected output. Please share your exact expected output.

Re: Duplicate values due to Item Code

sunny_talwar — Thu, 23 Mar 2017 08:55:23 GMT

I think the key between the two tables is not granular enough to give you Item_Code level Quantity.... You are joining the two tables on Document No_ and whereas it seems that you want to join on Document No_ and Item_Code. Is there Item information in Shipment table? It seems No_ include the same information as Item_Code... try this

Shipment:

LOAD [Document No_] as ShipmentNo,

[Sell-to Customer No_],

Type,

No_ as Item_Code,

[Location Code],

[Shipment Date],

Description,

Quantity,

[Unit Price],

[Unit Cost (LCY)],

[Shortcut Dimension 1 Code],

[Shortcut Dimension 2 Code],

[Order No_] as DocNum,

[Order No_] ,

[Order Line No_],

[Bill-to Customer No_],

[Gen_ Bus_ Posting Group],

[Gen_ Prod_ Posting Group],

[Unit Cost],

[Posting Date],

[Planned Delivery Date],

[Planned Shipment Date],

[Order Date]

FROM

(qvd)

where Quantity <> 0;

and may be you want to further link them on the Location Code also....

Note: You will get synthetic key which can be avoided by created a concatenated key using Document No_ and No_ field from Shipment table and similarly Document No_ and Item_Code from SalesLine table

Re: Duplicate values due to Item Code

Anonymous — Thu, 23 Mar 2017 09:55:36 GMT

PFA...

Re: Duplicate values due to Item Code

Anonymous — Thu, 23 Mar 2017 10:56:42 GMT

stalwar1 , swuehl , tresesco / All,

Any update on this?

Re: Duplicate values due to Item Code

sunny_talwar — Thu, 23 Mar 2017 11:00:12 GMT

Did you look at what I proposed?

Re: Duplicate values due to Item Code

Anonymous — Thu, 23 Mar 2017 11:05:57 GMT

Hi Sunny ,

I try with you solution but I didn't understand what to do ..

In attached qvd there is my main fact table called "Sales Line" in sales line which field need to be link..