topic Re: Duplicate in Total Qty in QlikView

Duplicate in Total Qty

Anonymous — Thu, 07 Aug 2014 00:26:29 GMT

Hello!

I hope someone can help me solve my problem... I'm trying to get a total Qty for Consign Inv which duplicates the value.

Based on my example Material 15-10791-01, I would be expecting a total of 1350 but turned out to be 2700. I already tried using a distinct function on the left join and (on the expression too)and got the same problem. I had this kind of problem before and I just changed the total mode to sum of rows and it worked but this one doesn't.

Pls. not sure...not sure what's the issue is.

Tks.

Re: Duplicate in Total Qty

Clint_Carr — Thu, 07 Aug 2014 00:52:04 GMT

Hi,

Does it do the same without the JOIN? That is remove the JOIN and just query the main QVD.

It appears to be a data issue to me.

Re: Duplicate in Total Qty

jer_2011 — Thu, 07 Aug 2014 01:57:38 GMT

hello,

within the CM column makes double,

what you could do is to exclude the data within the expression,

example sum({< CM={'CTH'} > } [Consign Qty])

Re: Duplicate in Total Qty

Anonymous — Thu, 07 Aug 2014 15:08:48 GMT

Hi! Clint,

If I take out the left join ,the total qty works fine but I need to join it from the inventory table since I want to create 2 new fields Direct Part Flag and Lean Part Flag through Base Material, Plant and CM. Not sure if I did the right thing but what I'm trying to get that if 3 fields Base Part Number , Plant CM from the joined table matches with Inventory table, then it will show thse Direct Part flags or Lean part flag.

Tks.