5 Replies Latest reply: Dec 18, 2017 11:14 AM by Omotayo Olokede

Duplicate Qty 2

Omotayo Olokede Dec 15, 2017 12:43 PM

Dear Felip,

Attached is two excel sheet which contains the Table in my Database and Table in Qlikview. I named them Qlikview and Database.

Re: Duplicate Qty 2

John Cavoulas Dec 15, 2017 1:05 PM (in response to Omotayo Olokede)

I presume you are using Sum(QTY) in your QlikView table.

How many rows in your QlikView table (look in table viewer)? Is it double the export from the DB? What if you use Distinct on the select statement in QlikView?
Like Show 0 Likes (0)

Actions
- Re: Duplicate Qty 2
  
  Omotayo Olokede Dec 15, 2017 5:25 PM (in response to John Cavoulas)
  
  Yes it is Double the Export from the DB.
  
  However i will try that Distinct, i will get back to you on this
  
  Thank You once again
  
  Like Show 0 Likes (0)
  
  Actions
- Re: Duplicate Qty 2
  
  Omotayo Olokede Dec 18, 2017 11:14 AM (in response to John Cavoulas)
  
  Dear John,
  
  This works fine and i am currently test running the result.
  
  Thank You
  
  Like Show 1 Like (1)
  
  Actions
Re: Duplicate Qty 2

Felip Drechsler Dec 15, 2017 2:00 PM (in response to Omotayo Olokede)

Hi Omotayo,

I've posted on the other thread for you to see:
Re: Duplicate Data
Like Show 0 Likes (0)

Actions
- Re: Duplicate Qty 2
  
  John Cavoulas Dec 15, 2017 2:11 PM (in response to Felip Drechsler )
  
  Thanks Felip. I wasn't aware of that one. Sounds like you are deep into this one. Good luck helping him.
  
  Like Show 0 Likes (0)
  
  Actions