Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

oseimuduame
Contributor

Duplicate Qty 2

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

5 Replies
johncaqc
Valued Contributor

Re: Duplicate Qty 2

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?

felipedl
Valued Contributor III

Re: Duplicate Qty 2

Hi Omotayo,

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

Re: Duplicate Data

johncaqc
Valued Contributor

Re: Duplicate Qty 2

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

oseimuduame
Contributor

Re: Duplicate Qty 2

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

oseimuduame
Contributor

Re: Duplicate Qty 2

Dear John,

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

Thank You

Community Browser