topic Re: Duplicate Qty 2 in App Development

Duplicate Qty 2

oseimuduame — Fri, 15 Dec 2017 17:43:13 GMT

Dear Felip,

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

felipedl‌

Re: Duplicate Qty 2

johnca — Fri, 15 Dec 2017 18:05:02 GMT

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?

Re: Duplicate Qty 2

felipedl — Fri, 15 Dec 2017 19:00:49 GMT

Hi Omotayo,

I've posted on the other thread for you to see:

Re: Duplicate Data

Re: Duplicate Qty 2

johnca — Fri, 15 Dec 2017 19:11:40 GMT

Thanks Felip. I wasn't aware of that one. Sounds like you are deep into this one. Good luck helping him.

Re: Duplicate Qty 2

oseimuduame — Fri, 15 Dec 2017 22:25:47 GMT

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

Re: Duplicate Qty 2

oseimuduame — Mon, 18 Dec 2017 16:14:29 GMT

Dear John,

This works fine and i am currently test running the result.

Thank You